DB2 - SQL1035N The database is currently in use

17 October,2012 by Jack Vamvas

Question : I’m trying to complete an OFFLINE FULL BACKUP and  receive this error message when executing db2 backup DB mydb.

 SQL1035N  The database is currently in use.  SQLSTATE=57019

 I’ve checked db2 list applications  - which returns no applications .

 How can I  fix?

Answer: First , check if the database is activated.

db2pd -db mydb -app


db2 list active databases

Second, if it’s activated , then deactivate the database

 db2 deactivate database

Third, try OFFLINE FULL BACKUP again

Related Posts on DB2 restore

DB2 – Restore database from a ONLINE backup

DB2 – check backup command and contents of a database

Author: Jack Vamvas(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on DB2 - SQL1035N The database is currently in use

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright