SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 03:36 PM
| ||||
| ||||
 backup status Dear all, I am running DB2 v7 in AIX. After I issued a db2 backup command, the command prompt hanged. I log on another term and check. No backup image file is generated, but when I issue "db2 list application show detail", I found a connection is made to the db with status "performing a backup". I try to "db2 force application (app-id) to break the backup connection but fail, I would like to ask : 1) how to check the backup command status (check if it is running or hang) 2) any command to break the backup process after I issue the backup command. Thanks a lot !!      |
|
02-26-2008, 03:36 PM
| |||
| |||
| Re: backup status "Deacon" <deacon@hkem.com> wrote in message news:<blul1j$c2k4@imsp212.netvigator.com>... > Dear all, > > I am running DB2 v7 in AIX. > > After I issued a db2 backup command, the command prompt hanged. I log on > another term and check. No backup image file is generated, but when I issue > "db2 list application show detail", I found a connection is made to the db > with status "performing a backup". > > I try to "db2 force application (app-id) to break the backup connection but > fail, I would like to ask : > > 1) how to check the backup command status (check if it is running or hang) > 2) any command to break the backup process after I issue the backup command. > > > Thanks a lot !! Hi, Check the db2diag.log to check what is happening. It will be in the directory <instancehome>/sqllib/db2dump/db2diag.log use tail to check the last few lines to see what's it complaining about. Regards, -Manoj |
|
02-26-2008, 03:36 PM
| |||
| |||
| Re: backup status Hi, Did you submit your DB2 backup command from prompt. Sometimes the telnet session may expire if its idle for long time and still show a connection to database. Always submit backup as a background process, use either 'nohup' or 'at now' or 'crontab'. Where is your backup going disk or TSM ? If disk then you can see the size of backup image growing, if its going to TSM you may login to TSM and monitor or ask TSM admin to see if the backup is running fine. I hope this helps. Sunila manrajshekar@yahoo.com (Manoj Rajshekar) wrote in message news:<ab2c7140.0310071603.4c5e9ac7@posting.google. com>... > "Deacon" <deacon@hkem.com> wrote in message news:<blul1j$c2k4@imsp212.netvigator.com>... > > Dear all, > > > > I am running DB2 v7 in AIX. > > > > After I issued a db2 backup command, the command prompt hanged. I log on > > another term and check. No backup image file is generated, but when I issue > > "db2 list application show detail", I found a connection is made to the db > > with status "performing a backup". > > > > I try to "db2 force application (app-id) to break the backup connection but > > fail, I would like to ask : > > > > 1) how to check the backup command status (check if it is running or hang) > > 2) any command to break the backup process after I issue the backup command. > > > > > > Thanks a lot !! > |
|
02-26-2008, 03:37 PM
| ||||
| ||||
| Re: backup status Deacon <deacon@hkem.com> wrote: > After I issued a db2 backup command, the command prompt hanged. I log on > another term and check. No backup image file is generated, but when I issue > "db2 list application show detail", I found a connection is made to the db > with status "performing a backup". You're saying that the backup hangs before it even creates the backup image? That's very strange. The backup target is opened very early in the process, far before anything happens that could cause the command to appear to hang. What is the exact command that you're running? > I try to "db2 force application (app-id) to break the backup connection but > fail, I would like to ask : > > 1) how to check the backup command status (check if it is running or hang) a. Watch the backup file and see if it continues to get bigger. b. Set diaglvl=4 and watch db2diag.log. An entry is made at the start of each tablespace that's processed. > 2) any command to break the backup process after I issue the backup command. Ctrl-C. This won't work if the backup is stalled because of lock contention or if it's making a noninterruptable system call, but for most general purposes it will do. dave |
Linear Mode
