I try to make an offline backup of a database, but everytime DB2 report to me:

SQL1035N Database already in use. SQLSTATE=57019


My info:
Product SQL08013
Level ident 02040106
Level DB2 v8.1.3.132
Build level s030728
PTF WR21324

I've already try to use command quiesce / force application to, but nothing to do.


Thank you veru much.

Hi,

Can you please try the following commands.

start--> run --> db2cmd

db2 force applications all.

db2stop

db2start

db2 backup database <database-name> to d:\db2bk

This will work.

Please let us know if it does not.

Hi nitingm,
thank you for your post.

Yesterday I forgot an active WebSphere app that used my db, and when I try to do backup again without WS active backup job work fine.

Thank you again,
fRANz