The error can be encountered if a database crashes while
transactions are indoubt and during the subsequent crash
recovery a storage error is encountered on a tablespace
which makes the tablespace inaccessible. After completing
crash recovery, Db2 will detect the presence of indoubt
transactions and will attempt to resolve it. If the indoubt
transaction made changes to the tablespace that is no
longer accessible, SQL10003C error is returned and the
database is shut down.
$ db2 restart db sample
SQL10003C There are not enough system resources to process the
request. The request cannot be processed. SQLSTATE=57011
The following messages can be found in db2diag.log.
2019-10-09-02.16.00.686210-420 I28689E515 LEVEL: Info
PID : 3015 TID : 140427164378880 PROC :
db2sysc 2
INSTANCE: db2v1058 NODE : 002 DB :
SAMPLE
APPHDL : 2-57 APPID: *N2.db2v1058.191009091600
AUTHID : DB2V1058 HOSTNAME: TURING11
EDUID : 67 EDUNAME: db2agent (SAMPLE) 2
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
DATA #1 :
Crash recovery completed. Next LSN is 0000000000001969.
2019-10-09-02.16.00.686538-420 I29205E539 LEVEL:
Warning
PID : 3015 TID : 140427164378880 PROC :
db2sysc 2
INSTANCE: db2v1058 NODE : 002 DB :
SAMPLE
APPHDL : 2-57 APPID: *N2.db2v1058.191009091600
AUTHID : DB2V1058 HOSTNAME: TURING11
EDUID : 67 EDUNAME: db2agent (SAMPLE) 2
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3280
DATA #1 :
In-doubt transaction(s) exists at the end of crash recovery on
log stream 2.
2019-10-09-02.16.00.686951-420 E29745E495 LEVEL:
Warning
PID : 3015 TID : 140427164378880 PROC :
db2sysc 2
INSTANCE: db2v1058 NODE : 002 DB :
SAMPLE
APPHDL : 2-57 APPID: *N2.db2v1058.191009091600
AUTHID : DB2V1058 HOSTNAME: TURING11
EDUID : 67 EDUNAME: db2agent (SAMPLE) 2
FUNCTION: DB2 UDB, recovery manager, sqlpssdw, probe:100
MESSAGE : Resolving indoubt transactions with other nodes.
2019-10-09-02.16.00.918253-420 I30241E622 LEVEL:
Severe
PID : 3015 TID : 140427097270016 PROC :
db2sysc 2
INSTANCE: db2v1058 NODE : 002 DB :
SAMPLE
APPHDL : 2-57 APPID: *N2.db2v1058.191009091600
AUTHID : DB2V1058 HOSTNAME: TURING11
EDUID : 108 EDUNAME: db2agnsc (SAMPLE) 2
FUNCTION: DB2 UDB, data management, sqldmund, probe:1184
MESSAGE :
ZRC=0x80020033=-2147352525=SQLB_NOT_ALLOWED_ROLLFORWARD_P
"Access not allowed. Tblspc RF Pending."
DATA #1 :
Error during UNDO of LSN: 0000000000001965
2019-10-09-02.16.00.918622-420 I30864E554 LEVEL:
Severe
PID : 3015 TID : 140427097270016 PROC :
db2sysc 2
INSTANCE: db2v1058 NODE : 002 DB :
SAMPLE
APPHDL : 2-57 APPID: *N2.db2v1058.191009091600
AUTHID : DB2V1058 HOSTNAME: TURING11
EDUID : 108 EDUNAME: db2agnsc (SAMPLE) 2
FUNCTION: DB2 UDB, data management, sqldmund, probe:1184
RETCODE :
ZRC=0x80020033=-2147352525=SQLB_NOT_ALLOWED_ROLLFORWARD_P
"Access not allowed. Tblspc RF Pending."
2019-10-09-02.16.00.918823-420 I31419E739 LEVEL:
Severe
PID : 3015 TID : 140427097270016 PROC :
db2sysc 2
INSTANCE: db2v1058 NODE : 002 DB :
SAMPLE
APPHDL : 2-57 APPID: *N2.db2v1058.191009091600
AUTHID : DB2V1058 HOSTNAME: TURING11
EDUID : 108 EDUNAME: db2agnsc (SAMPLE) 2
FUNCTION: DB2 UDB, data management, sqldmund, probe:1184
MESSAGE : Error during UNDO of log record:
DATA #1 : Hexdump, 38 bytes
0x00007FB7BB3FC2E0 : 01A2 0200 1400 0000 1200 F41A 0700 0000
................
0x00007FB7BB3FC2F0 : 0000 041B 0000 1200 0100 0A00 0800 0000
................
0x00007FB7BB3FC300 : 0008 0000 0000
...... |
