cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

backupexec 12.5 on win2003 backup DB2.Error "The database is currently in use. "


Hi guys,

I tried to backup the DB2 database to tape via backupExec 12.5 DB2 agent .I using offline backup mode.
But 2 databases got some errors only  as below:

Note: Resource: "DB2-Win::\\DBSERVER\DB2\CTRL\0" is not snappable. Attempting to back up directly from the source volume.
.....
C:\WINDOWS\system32>C:\PROGRA~1\IBM\SQLLIB\bin\db2.exe -v connect to CTRL
connect to CTRL
SQL1035N The database is currently in use. SQLSTATE=57019

C:\WINDOWS\system32>C:\PROGRA~1\IBM\SQLLIB\bin\db2.exe -v quiesce database immediate
quiesce database immediate
SQL1024N A database connection does not exist. SQLSTATE=08003


If I need to backup with force mode?where I can change the setting,and I already choose OFFLINE backup.
Thank you.
3 Replies
Highlighted

Re: backupexec 12.5 on win2003 backup DB2.Error "The database is currently in use. "

Check the following
http://www-01.ibm.com/support/docview.wss?uid=std338d87fb78a4b882d492573ee000d7fb8

DB2 database should be deactivated before taking backup.
db2 deactivate db <database name>

This could be substituted using quiesce command.
db2 connect to <database name>
db2 quiesce database immediate force connections
db2 connect reset
db2 backup database <database name>
db2 connect to <database name>
db2 unquiesce database
db2 connect reset
BEWS DB2 agent utilizes this method.
However, user having sysadm/sysmaint/sysctrl/quiesce_connect privilege is able to access even after quiesce point. If this is the case, backup would fail with the SQL1035N SQLSTATE=57019
Highlighted

Re: backupexec 12.5 on win2003 backup DB2.Error "The database is currently in use. "

Hi,

SQL is most likely the culprit here. You'd have to take the DB offline in order to back it up. However, the SQL agent gets around this by allowing you to do an online backup/restore.
If you're not using this, I would suggest looking into it.

Cheers!
Highlighted

Re: backupexec 12.5 on win2003 backup DB2.Error "The database is currently in use. "

Thank you.

But I have 5databases,only 2 got this error,they are using the same setting.
attached is  my db2 backup setting,do you think need to change anything?

Thank you.