DB2 restore may terminate with -902 or db2 connect with -1042 on
windows, when DB2NTNOCACHE is set and DB is not dropped before
or not or fully removed prior to restore.
db2diag.log show:
2015-01-22-23.20.39.139000+060 I9512002F684 LEVEL: Error
PID : 11884 TID : 8312 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : XXX
APPHDL : 0-39182 APPID: *LOCAL.DB2.150122181908
AUTHID : SVCSCHEDULER HOSTNAME: AT010000SAD21
EDUID : 8312 EDUNAME: db2agent (XXX) 0
FUNCTION: DB2 UDB, data protection services, sqlpgrml, probe:50
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
DATA #1 : String, 66 bytes
Error deleting logpath1:
'H:\DB2\NODE0000\SQL00005\LOGSTREAM0000\'
2015-01-22-23.20.39.154000+060 E9512688F614 LEVEL:
Severe
PID : 11884 TID : 8312 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : XXX
APPHDL : 0-39182 APPID: *LOCAL.DB2.150122181908
AUTHID : SVCSCHEDULER HOSTNAME: AT010000SAD21
EDUID : 8312 EDUNAME: db2agent (XXX) 0
FUNCTION: DB2 UDB, database utilities, sqludProcessSingleLFH,
probe:2013
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-902
DATA #2 : Hexdump, 8 bytes
0x00000005B349DEE8 : 0200 0F87 0200 0000
........
2015-01-22-23.20.39.154000+060 E9513304F1032 LEVEL:
Severe
PID : 11884 TID : 8312 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : XXX
APPHDL : 0-39182 APPID: *LOCAL.DB2.150122181908
AUTHID : SVCSCHEDULER HOSTNAME: AT010000SAD21
EDUID : 8312 EDUNAME: db2agent (XXX) 0
FUNCTION: DB2 UDB, database utilities, sqludProcessSingleLFH,
probe:2013
MESSAGE : SQL0902C A system error occurred. Subsequent SQL
statements cannot
be processed. IBM software support reason code: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 1
sqlerrmc: 2
sqlerrp : sqludPro
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:
2015-01-22-23.20.39.357000+060 E9514338F478 LEVEL:
Severe
PID : 11884 TID : 8312 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : XXX
APPHDL : 0-39182 APPID: *LOCAL.DB2.150122181908
AUTHID : SVCSCHEDULER HOSTNAME: AT010000SAD21
EDUID : 8312 EDUNAME: db2agent (XXX) 0
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:896
MESSAGE : Restore Terminated. |
