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 IC96181 Status: Closed

IN A DPF, IF AGENTPRI IS CHANGED, DB2START GETS SQL1042C AND DB2 INSTANCE
CAN'T START.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When the problem happens, following error can be observed in 
db2diag.log. 
 
2013-08-29-09.40.02.073501+600 E12276A1520        LEVEL: Severe 
(OS) 
PID     : 14745630             TID  : 1           PROC : 
db2star2 
INSTANCE: db2inst             NODE : 000 
EDUID   : 1 
FUNCTION: DB2 UDB, oper system services, sqloWaitIPCWaitPost, 
probe:100 
MESSAGE : ZRC=0x83000023=-2097151965 
CALLED  : OS, -, msgrcv 
OSERR   : ENOMSG (35) "No message of desired type" 
DATA #1 : timeout value, 4 bytes 
0 
DATA #2 : String, 203 bytes 
{ 
   pc    = 0x0 
   cs    = { 
   lock          = { 0x10000000 [ locked ] } 
   identity      = sqlo_waitpost::cs (6) 
} 
 
   state = 0x2 ((Empty)) 
   guard = initialized 
   flags = 0x2 
   numWaiters  = 1 
} 
DATA #3 : ipc waitpost, PD_TYPE_SQLO_IPCWAITPOST, 28 bytes 
0x07800000000100C8 : 0000 0000 1000 0000 0006 0000 0000 0002 
................ 
0x07800000000100D8 : 0000 ABFE 0002 0000 0000 0001 
............ 
DATA #4 : system V message queue identifier., 
PD_TYPE_SYSV_QUEUE_ID, 4 bytes 
0x04800028 
DATA #5 : Bitmask, 8 bytes 
0x0000000000000000 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x090000002C071AD4 pdLogSysRC@glueA + 0x174 
  [1] 0x090000002C088780 sqloWaitIPCWaitPost + 0x270 
  [2] 0x0000000100003B84 DB2StartMain + 0x3104 
  [3] 0x0000000100008670 main + 0x10 
  [4] 0x0000000100000320 __start + 0x98 
  [5] 0x0000000000000000 ?unknown + 0x0 
  [6] 0x0000000000000000 ?unknown + 0x0 
  [7] 0x0000000000000000 ?unknown + 0x0 
  [8] 0x0000000000000000 ?unknown + 0x0 
  [9] 0x0000000000000000 ?unknown + 0x0 
 
2013-08-29-09.40.02.074697+600 I13797A390         LEVEL: Error 
PID     : 14745630             TID  : 1           PROC : 
db2star2 
INSTANCE: db2inst             NODE : 000 
EDUID   : 1 
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:660 
MESSAGE : db2sysc exited prematurely. sqlcode : 
DATA #1 : Hexdump, 4 bytes 
0x0FFFFFFFFFFF92F8 : 8300 0023 
...#
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97FP9 or higher version.                     * 
****************************************************************
Local Fix:
Restart DB2 instance without AGENTPRI modification.
available fix packs:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Fixed on DB2 V97FP9
Workaround
Restart DB2 instance without AGENTPRI modification.
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC96745 IC96875 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.09.2013
17.12.2013
17.12.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.9 FixList
9.7.0.9 FixList