home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC99899 Status: Closed

DB2 CRASHES WITH "UNKNOWN PROGRAM ERROR" IN
SQLDFINDRIDFROMPAGECACHECOMPLEX AFTER A NON-SEVERE ERROR

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
Customer hit a non-severe log full error and DB2 crashed: 
 
2014-02-27-14.43.53.095786-480 I905588A593          LEVEL: Error 
 
PID     : 18546702             TID : 22552          PROC : 
db2sysc 0 
INSTANCE: dbboss01             NODE : 000           DB   : 
BOSSPROD 
APPHDL  : 0-57714              APPID: GA01F447.B5E0.140227223720 
 
AUTHID  : BOSSPROD             HOSTNAME: scldbbos01u 
 
EDUID   : 22552                EDUNAME: db2agent (BOSSPROD) 0 
 
FUNCTION: DB2 UDB, data protection services, sqlpWriteLR, 
probe:6680 
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE 
 
          "Log File has reached its saturation point" 
 
          DIA8309C Log file was full. 
 
 
2014-02-27-14.44.04.151471-480 I5853424A2683        LEVEL: 
Severe 
PID     : 18546702             TID : 22552          PROC : 
db2sysc 0 
INSTANCE: dbboss01             NODE : 000           DB   : 
BOSSPROD 
APPHDL  : 0-57714              APPID: GA01F447.B5E0.140227223720 
 
AUTHID  : BOSSPROD             HOSTNAME: scldbbos01u 
 
EDUID   : 22552                EDUNAME: db2agent (BOSSPROD) 0 
 
FUNCTION: DB2 UDB, data management, 
sqldFindRidFromPageCacheComplex, 
probe:4421 
 
MESSAGE : ZRC=0x87040055=-2029780907=SQLD_PRGERR "Unknown 
PROGRAM ERROR" 
          DIA8576C A data management services programming error 
 
          occurred. 
 
DATA #1 : String, 20 bytes 
 
Invalid append cache 
 
DATA #2 : unsigned integer, 8 bytes 
 
0 
 
DATA #3 : unsigned integer, 8 bytes 
 
1 
 
DATA #4 : unsigned integer, 8 bytes 
 
4 
 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are 
resolved to the nearest symbol) 
 
  [0] 0x090000000767FBA4 
 
sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_ 
TABLE_CA 
CHET3 + 0xB1C 
 
  [1] 0x090000000767F384 
 
sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_ 
TABLE_CA 
CHET3 + 0x2FC 
 
  [2] 0x0900000007694114 
 
sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_ 
TABLE_CA 
CHET3 + 0x1400 
 
  [3] 0x0900000007692824 sqldInsertRow__FP13SQLD_DFM_WORKi + 
0x3FC 
  [4] 0x090000000768CED0 
 
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv + 
0xB8C 
  [5] 0x0900000007699288 
 
sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud 
oFlags17 
t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xBC 
 
  [6] 0x09000000076994E4 sqlriisr__FP8sqlrr_cb + 0x184 
 
  [7] 0x09000000078FFBCC 
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 
0x448 
 
  [8] 0x0900000008246590 
 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interfac 
e + 0x3C7C 
 
  [9] 0x09000000082434E4 
 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interfac 
e + 0xBD0 
 
  [10] 0x0900000008243810 
 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interfac 
e + 0xEFC 
 
  [11] 0x090000000824D030 
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x9C8 
 
  [12] 0x090000000824D030 
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x9C8 
 
  [13] 0x090000000824CC3C 
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x5D4 
 
  [14] 0x090000000904F240 
 
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8 
 
  [15] 0x090000000904FD2C 
 
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5E0 
 
  [16] 0x0900000007228210 RunEDU__8sqeAgentFv + 0x465D0 
 
  [17] 0x0900000007170624 RunEDU__8sqeAgentFv + 0xD8 
 
  [18] 0x0900000007F1D10C EDUDriver__9sqzEDUObjFv + 0x110 
 
  [19] 0x090000000719CC78 sqloEDUEntry + 0x38C 
 
  [20] 0x0900000000728E10 _pthread_body + 0xF0 
 
  [21] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF 
 
2014-02-27-14.44.07.480016-480 I6556429A536         LEVEL: 
Severe 
PID     : 18546702             TID : 22552          PROC : 
db2sysc 0 
INSTANCE: dbboss01             NODE : 000           DB   : 
BOSSPROD 
APPHDL  : 0-57714              APPID: GA01F447.B5E0.140227223720 
AUTHID  : BOSSPROD             HOSTNAME: scldbbos01u 
EDUID   : 22552                EDUNAME: db2agent (BOSSPROD) 0 
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, 
probe:10 
MESSAGE : DIA0505I Execution of a component signal handling 
function has begun. 
 
2014-02-27-14.47.12.800637-480 I9676984A2444        LEVEL: Info 
PID     : 18546702             TID : 29147          PROC : 
db2sysc 0 
INSTANCE: dbboss01             NODE : 000           DB   : 
BOSSPROD 
APPHDL  : 0-57449              APPID: GA01F447.B3DE.140227221250 
AUTHID  : BOSSPROD             HOSTNAME: scldbbos01u 
EDUID   : 29147                EDUNAME: db2agent (BOSSPROD) 0 
FUNCTION: DB2 UDB, base sys utilities, 
sqeLocalDatabase::ForceDBShutdown, probe:15039 
MESSAGE : Regular agent EDU doing ForceDBShutdown.  Force DB 
shutdown agent ID 
          is: 
DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes 
0-57449 
DATA #2 : sqeApplication_acbInfo, 
PD_TYPE_sqeApplication_acbInfo, 4 bytes 
x0 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x0900000008FE7CB0 ForceDBShutdown__16sqeLocalDatabaseFi + 
0xC64 
  [1] 0x090000000A55F994 
sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x9CC 
  [2] 0x090000000767B4CC 
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv + 
0x6D74 
  [3] 0x090000000768CA84 
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv + 
0x740 
  [4] 0x0900000007699288 
sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud 
oFlags17t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xBC 
  [5] 0x09000000076994E4 sqlriisr__FP8sqlrr_cb + 0x184 
  [6] 0x09000000078FFBCC 
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x448 
  [7] 0x0900000008246590 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x3C7C 
  [8] 0x09000000082434E4 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0xBD0 
  [9] 0x0900000008243810 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0xEFC 
  [10] 0x090000000824D030 
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x9C8 
  [11] 0x090000000824D030 
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x9C8 
  [12] 0x090000000824CC3C 
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x5D4 
  [13] 0x090000000904F240 
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8 
  [14] 0x090000000904FD2C 
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5E0 
  [15] 0x0900000007228210 RunEDU__8sqeAgentFv + 0x465D0 
  [16] 0x0900000007170624 RunEDU__8sqeAgentFv + 0xD8 
  [17] 0x0900000007F1D10C EDUDriver__9sqzEDUObjFv + 0x110 
  [18] 0x090000000719CC78 sqloEDUEntry + 0x38C 
  [19] 0x0900000000728E10 _pthread_body + 0xF0 
  [20] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF 
 
2014-02-27-15.04.15.499949-480 E116514A495          LEVEL: Info 
PID     : 16056568             TID : 2829           PROC : 
db2sysc 0 
INSTANCE: dbboss01             NODE : 000           DB   : 
BOSSPROD 
APPHDL  : 0-8                  APPID: 
*LOCAL.dbboss01.140227230413 
AUTHID  : DBBOSS01             HOSTNAME: scldbbos01u 
EDUID   : 2829                 EDUNAME: db2agent (BOSSPROD) 0 
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:200 
MESSAGE : ADM1530I  Crash recovery has been initiated. 
 
NOTE:  Any non-severe error, such as log full or interrupt, will 
trigger this defect.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or higher.                                           * 
****************************************************************
Local Fix:
N/A
available fix packs:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
Solution
Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4)
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.03.2014
22.09.2014
22.09.2014
Problem solved at the following versions (IBM BugInfos)


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


10.5.0.4

FixList