Home

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IT07056	Status: Closed
DB2 RESTORE MAY TERMINATE WITH -902 OR DB2 CONNECT WITH -1042 ON WINDOWS IF DB WAS NOT DROPPED OR FULLY REMOVED PRIOR TO RESTORE
product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
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.
Problem Summary:
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 fixpack 7 * ****************************************************************
Local Fix:
unset DB2NTNOCACHE
Solution
Problem was first fixed in DB2 version 10.5 fixpack 7
Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	10.02.2015 22.01.2016 22.01.2016
Problem solved at the following versions (IBM BugInfos)

Problem solved according to the fixlist(s) of the following version(s)
10.5.0.7