Unanswered: "SQL1035N The database is currently in use. SQLSTATE=57019" at backup start
I's appreciate any help or suggestion regarding this matter:
We've got 2 databases (DB2/NT64 9.7.0). During or eod routine, we perform a backup of each. Sometimes the routine returns "SQL1035N The database is currently in use. SQLSTATE=57019" for teh second db.
The "sometimes" part is driving us crazy...
The script goes as follows:
result for first db
backup - successful
result for second db
backup - sometimes successful, sometimes "SQL1035N The database is currently in use. SQLSTATE=57019"
after the force a new connection can be activated
use quiesce instead to avoid this message or take online backup if possible
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be