Gert Wohlgemuth wrote: > > Many thanks, > > Ok I'm the admin for this database and currently I'am a > little bit frighten what happens when I restart the hole > sapdb database engine with my database. Coud it be that man > database will be broken or crashed? > > And at the moment I can't do a backup to serve our data? > > So whats todo? >
Usually, the restart of a database (no matter if the whole hardware will be restarted or not) will result in a consistent, fine working database. I do not understand why you are afraid. Of course it is necessary to save data from time to time. And you are not able to find out who has the connection to the database using dbm...? And stop this to be able to start your backup? Did you check using select * from DOMAIN.CONNECTEDUSERS who seems to be connected (which termid)? If you are not able to solve the used utility-task, then: do you have data backup + log backups to recover your data in the very unlikely case of not being able to restart ? (I am not afraid, but...) Elke SAP Labs Berlin > Cheers Gert > > Gert Wohlgemuth - Java Programmer > > Max Planck Institut f�r Molekulare Pflanzenphysiologie > Am M�hlenberg 1 > 14424 Golm > > Fon: +49-331-5678320 > e-mail: [EMAIL PROTECTED] > > > -----Original Message----- > From: Zabach, Elke [mailto:[EMAIL PROTECTED] > Sent: Friday, February 27, 2004 4:45 PM > To: Gert Wohlgemuth; [EMAIL PROTECTED] > Subject: RE: database problem > > Gert Wohlgemuth wrote: > > > > > Dear list, > > > > > > > > Sometime Ii becomes in trouble with my database, I cannot > > make a backup, and the server told me: max task limit > > > > > > > > How can I fix this, I try to increase the max user tasks, but > > cannot restart my database, the same problem occurred. > > > > > > > > So, who can help me stupid guy? > > > There are two kinds of tasks in the kernel/server, which can > be occupied > by clients: 1..n usertasks, 1 (so-called) utility-task. > Only this single utility-task is able to do backups (with > newer versions it will be different). > If this single task is occupied, the error mentioned in your > mail will occur, no matter > how many unused usertasks are available. > > A Utility-task is occupied by backup/recovery, sometimes for > other work done > with dbm(gui/cli). --> Please assure that only one guy tries > to admin your database > using one of these dbm-tools. > > And there is no chance to increase the number of > utility-tasks (she KNOWS that > she is the only one and uses this knowledge). > > Elke > SAP Labs Berlin > > > > > Thanks gert > > > > Gert Wohlgemuth - Java Programmer > > > > Max Planck Institut f�r Molekulare Pflanzenphysiologie > > Am M�hlenberg 1 > > 14424 Golm > > > > Fon: +49-331-5678320 > > e-mail: [EMAIL PROTECTED] > > > > > > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
