Troubleshooting
Problem
An offline database backup after the database was quiesced and deactivated might fail with SQL1035N.
Symptom
The following output demonstrates the issue:
db2 connect to DBXX
Database Connection Information
Database server = DB2/AIX64 10.1.2
SQL authorization ID = DB2INST1
Local database alias = DBXX
db2 quiesce database immediate force connections
DB20000I The QUIESCE DATABASE command completed successfully.
db2 connect reset
DB20000I The SQL command completed successfully.
db2 terminate
DB20000I The TERMINATE command completed successfully.
db2 deactivate database DBXX
DB20000I The DEACTIVATE DATABASE command completed successfully.
db2 terminate
DB20000I The TERMINATE command completed successfully.
db2 "backup database DBXX use tsm open 1 sessions ..."
SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP \u0026 UDF) - SQL","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;9.1;10.1","Edition":"Advanced Enterprise Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
swg21636292