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

WITH DB2 V11.1 M1FP1 ON ZLINUX WITH HARDWARE LEVEL EQUAL OR OLDER THAN
ZEC12 DB2START WILL FAIL

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
With DB2 v11.1 m1fp1 on zLinux: 
 
Informational tokens are "DB2 v11.1.1.1", "s1612051900", 
"DYN1612051900Z390", Fix Pack "1". 
 
with hardware level equal or older then zEC12 db2start will fail 
with the following... 
 
db2start 
01/12/2017 09:50:59     0   0   SQL1042C  An unexpected system 
error occurred. 
SQL1032N  No start database manager command was issued. 
SQLSTATE=57019 
 
In db2diag.log, the following messages can be seen: 
 
2017-01-12-09.50.13.821967-420 E15035A1474          LEVEL: 
Severe 
PID     : 35871                TID : 4397341862160  PROC : 
db2sysc 0 
INSTANCE: db2inst1               NODE : 000 
HOSTNAME: myhost 
EDUID   : 1                    EDUNAME: db2sysc 0 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
probe:90 
MESSAGE : ADM14011C  A critical failure has caused the following 
type of error: 
          "Trap". The database manager cannot recover from the 
failure. First 
          Occurrence Data Capture (FODC) was invoked in the 
following mode: 
          "Automatic". FODC diagnostic information is located in 
the following 
          directory: 
 
"/home/db2inst1/sqllib/db2dump/FODC_Trap_2017-01-12-09.50.10.746 
429_0000 
          /". 
DATA #1 : Signal Number Recieved, 4 bytes 
4 
DATA #2 : Siginfo, 128 bytes 
0x000003FFD5FE4D10 : 0000 0004 0000 0000 0000 0001 FD69 A298 
.............i.. 
0x000003FFD5FE4D20 : 0000 03FF F05F 2E72 0000 03FF FD69 9F6C 
....._.r.....i.l 
0x000003FFD5FE4D30 : 0000 03FF D5FE 4CB8 0000 0000 0000 0000 
......L......... 
0x000003FFD5FE4D40 : 0000 03FF EA4E 2B98 0000 03FF D5FE 4DE8 
.....N+.......M. 
0x000003FFD5FE4D50 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x000003FFD5FE4D60 : 0000 0000 0000 0005 0000 0000 02EE 450E 
..............E. 
0x000003FFD5FE4D70 : 0000 03FF D5FE 4F28 0000 03FF EA37 DCA0 
......O(.....7.. 
0x000003FFD5FE4D80 : 0000 03FF D5FE 4F18 0000 03FF D5FE 4DA0 
......O.......M. 
 
2017-01-12-09.50.13.879410-420 I16510A1486          LEVEL: Event 
PID     : 35871                TID : 4397341862160  PROC : 
db2sysc 0 
INSTANCE: db2inst1               NODE : 000 
HOSTNAME: myhost 
EDUID   : 1                    EDUNAME: db2sysc 0 
FUNCTION: DB2 UDB, oper system services, 
sqloPGRPRegisterOneCrash, probe:2161 
MESSAGE : lastCrashCount 
DATA #1 : unsigned integer, 8 bytes 
0 
DATA #2 : String, 10 bytes 
inRecovery 
DATA #3 : Boolean, 1 bytes 
false 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x000003FFF57D9C44 sqloPGRPRegisterOneCrash + 0x414 
  [1] 0x000003FFF592D466 sqloEDUCodeTrapHandler + 0x1A52 
  [2] 0x000003FFD5FE4D08 0x000003FFD5FE4D08 + 0x0 
  [3] 0x000003FFF05F2E78 
_ZN7ibm_cde5query14PackedBankSIMDILi2EE27initializePrecomputedTa 
blesEv + 0x310 
  [4] 0x000003FFEDE8D938 
_ZN7ibm_cde4data10cdeStartupENS0_11StartupModeE + 0x190 
  [5] 0x000003FFF1AECFE6 _ZN12cdeInterface14initCdeRuntimeEv + 
0x8A 
  [6] 0x0000000080017C32 
_Z15sqleInitSysCtlrPmPtP15sqleResyncAgtCB + 0x1636 
  [7] 0x0000000080014282 _Z11sqleSysCtlrv + 0x19E 
  [8] 0x000003FFF5925864 
/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xB6C3864 
  [9] 0x000003FFF5924666 sqloRunInstance + 0x3CA 
  [10] 0x000000008000C9BC DB2main + 0x11D4 
  [11] 0x000003FFF59311F0 _Z16sqloEDUMainEntryPcj + 0x24 
  [12] 0x000003FFF592D87A sqloEDUEntry + 0x28A 
  [13] 0x000003FFFD658524 /lib64/libpthread.so.0 + 0x8524 
  [14] 0x000003FFE9957F4A /lib64/libc.so.6 + 0xE7F4A 
 
Looking at the /var/log/messages file, the following can be 
seen: 
 
2017-01-12T09:50:13.887064-07:00 myhost kernel: User process 
fault: interruption code 0x60001 in libdb2e.so.1 
[3ffea262000+11847000] 
2017-01-12T09:50:13.887084-07:00 myhost kernel: CPU: 1 PID: 
35872 Comm: db2sysc Not tainted 3.12.28-4-default #1 
2017-01-12T09:50:13.887086-07:00 myhost kernel: task: 
000000023776a438 ti: 000000012ac50000 task.ti: 000000012ac50000 
2017-01-12T09:50:13.887097-07:00 myhost kernel: User PSW : 
0705200180000000 000003fff05f2e90 (0x3fff05f2e90) 
2017-01-12T09:50:13.887100-07:00 myhost kernel:           R:0 
T:1 IO:1 EX:1 Key:0 M:1 W:0 P:1 AS:0 CC:2 PM:0 EA:3 
2017-01-12T09:50:13.887101-07:00 myhost kernel: User GPRS: 
0000000000000001 000003fffd5f98e8 000003ff00000001 
000003ffd5fe4fd8 
2017-01-12T09:50:13.887103-07:00 myhost kernel: 
000000000000003e 0000000000000000 4000000000000000 
0000000000000001 
2017-01-12T09:50:13.887105-07:00 myhost kernel: 
5555555555555555 000003ffd5fe5030 000003ffd5fe4fe8 
0000000000000000 
2017-01-12T09:50:13.887107-07:00 myhost kernel: 
000003fffd605fa0 000003ffd5fe4ff8 0000000000000002 
000003ffd5fe4f18 
2017-01-12T09:50:13.887109-07:00 myhost kernel: User Code: 
000003fff05f2e7e: e380a0080004    lg    %r8,8(%r10) 
2017-01-12T09:50:13.887111-07:00 myhost kernel: 
000003fff05f2e84: ebe02000000d    sllg    %r14,%r0,0(%r2) 
2017-01-12T09:50:13.887113-07:00 myhost kernel: 
#000003fff05f2e8a: ecc820bf0059    risbgn    %r12,%r8,32,191,0 
2017-01-12T09:50:13.887116-07:00 myhost kernel: 
>000003fff05f2e90: b9040008        lgr    %r0,%r8 
2017-01-12T09:50:13.887118-07:00 myhost kernel: 
000003fff05f2e94: eb6e4000000d    sllg    %r6,%r14,0(%r4) 
2017-01-12T09:50:13.887120-07:00 myhost kernel: 
000003fff05f2e9a: b904002c        lgr    %r2,%r12 
2017-01-12T09:50:13.887129-07:00 myhost kernel: 
000003fff05f2e9e: eb480020000c    srlg    %r4,%r8,32 
2017-01-12T09:50:13.887131-07:00 myhost kernel: 
000003fff05f2ea4: b90c0007        msgr    %r0,%r7 
2017-01-12T09:50:13.887132-07:00 myhost kernel: Last 
Breaking-Event-Address: 
2017-01-12T09:50:13.887139-07:00 myhost kernel: 
[<0000000000619e48>] sysc_restore+0x22/0x26 
2017-01-12T09:50:13.887132-07:00 myhost rsyslogd-2007: action 
'action 2' suspended, next retry is Thu Jan 12 09:51:43 2017 
[try http://www.rsyslog.com/e/2007 ] 
 
NOTE this line: 
 
2017-01-12T09:50:13.887113-07:00 myhost kernel: 
#000003fff05f2e8a: ecc820bf0059    risbgn    %r12,%r8,32,191,0
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 11.1 Mod1 Fix Pack 1 iFix001                  * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

Solution
First fixed in DB2 11.1 Mod1 Fix Pack 1 iFix001
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.01.2017
01.05.2017
01.05.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)