Symptom
Db2 Offline backup fails with SQL1035N
db2diag.log shows initiation of backup, first with db2stop and db2start with Database not activated.
The error SQL1035N is received once the backup has commenced and then terminates.
PID : 0000 TID : XXX PROC : db2stop
INSTANCE: db2<SID> NODE : XXX
HOSTNAME: XXXXXXX
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 31 bytes
/db2/db2XXX/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0x00007FFEC6355CF0 : 2F64 6232 2F64 6232 7064 722F 7371 6C6C /db2/db2xxx/sqll
0x00007FFEC6355D00 : 6962 2F61 646D 2F64 6232 7374 6F70 3200 ib/adm/db2stop2.
=======================================>
0000000000000000000000000000000000000 LEVEL: Info
PID : 0000 TID : XXX PROC : db2start
INSTANCE: db2<SID NODE : XXXX
HOSTNAME: XXXXX
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:16474
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 36 bytes
0000000000000000000000000000000000000 LEVEL: Info
PID : 0000 TID : XXX PROC :
INSTANCE: db2<SID NODE : XXXX
HOSTNAME: XXXXX LEVEL: Event
START : DATABASE: <SID> : ACTIVATED: NO
Backup is initialising
0000000000000000000000000000000000000 LEVEL: Info
PID : XXXX TID : XXXXXXXXXXXXX PROC : db2sysc 0
INSTANCE: db2<SID> NODE : 000 DB : <SID>
APPHDL : XX APPID: *XXXXXXXXXXXXXXXXX
AUTHID : DB2<SID> HOSTNAME: XXXXXX
EDUID : 00 EDUNAME: db2agent (<SID>) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:558
DATA #1 : <preformatted>
Autonomic backup/restore - using parallelism = X.
0000000000000000000000000000000000000 LEVEL: Info
PID : XXXX TID : XXXXXXXXXXXXX PROC : db2sysc 0
INSTANCE: db2<SID> NODE : 000 DB : <SID>
APPHDL : XX APPID: *XXXXXXXXXXXXXXXXX
AUTHID : DB2<SID> HOSTNAME: XXXXXX
EDUID : 00 EDUNAME: db2agent (<SID>) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:558
DATA #1 : <preformatted>
MESSAGE : Starting an offline db backup.
0000000000000000000000000000000000000000000 LEVEL: Warning
PID : XXXXX TID : 0000000000000 PROC : db2sysc 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::SubsequentConnect, probe:00000
RETCODE : ZRC=0xFFFFFBF5=-1035
SQL1035N The operation failed because the specified database cannot
be connected to in the mode requested.
0000000000000000000000000000000000000000000 LEVEL: Severe
PID : XXXXX TID : 0000000000000 PROC : db2sysc 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::SubsequentConnect, probe:00000
MESSAGE : Backup terminated.
Read more...
Environment
Db2 LUW IBM
Product
Keywords
available, multiple, prevent , KBA , BC-DB-DB6-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.