SAP Knowledge Base Article - Preview

3304292 - Offline DB6 backup fails with SQL1035N

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

SAP NetWeaver all versions

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.