Troubleshooting
Problem
Symptom
Cause
Diagnosing The Problem
LIST TABLESPACES will list the current table space state.
In the db2diag.log the following example errors may be seen, where in this case table space SYSCATSPACE is in a state that disallows the backup to complete:
2016-04-26-06.47.28.644000-240 E6358F940 LEVEL: Severe
PID : 4060 TID : 7112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-27764 APPID: *LOCAL.DB2.160426104803
AUTHID : DB2ADMIN
EDUID : 7112 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1721
MESSAGE : SQL2048N An error occurred while accessing object "". Reason code:
"".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2048 sqlerrml: 3
sqlerrmc: 0 6
sqlerrp : sqlubBui
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2016-04-26-06.47.28.644000-240 E7300F692 LEVEL: Error
PID : 4060 TID : 7112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-27764 APPID: *LOCAL.DB2.160426104803
AUTHID : DB2ADMIN
EDUID : 7112 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1725
MESSAGE : SQL2048N An error occurred while accessing object "". Reason code:
"".
DATA #1 : String, 114 bytes
The BACKUP_IN_PROGRESS state cannot be turned on.
It is not compatible with the current state of the table space.
DATA #2 : String, 11 bytes
SYSCATSPACE
Enter the command:
db2pd -db <database> -reorg -appl -locks showlock -wlock
Replace <database> with the name of the database. This will show if you have a REORG running, you should find it in a Lock-Wait state, you should then be able to see the application which is causing the Lock-Wait in the same about.
You can read an example on the use of the db2pd command at the link below.
http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.trb.doc/doc/c0054595.html?lang=en#c0054595__example1
Resolving The Problem
Once the lock has been released try performing the online backup again.
Related Information
Was this topic helpful?
Document Information
Modified date:
07 December 2022
UID
swg21982212