IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Mod1 Fix Pack 1 iFix001                  *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 11.1 Mod1 Fix Pack 1 iFix001
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT18914

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-01-19

  • Closed date

    2017-05-01

  • Last modified date

    2017-05-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
29 June 2020