IBM Support

IT23141: INTERMITTENT LOAD ABNORMAL END IN THE BUILD PHASE: UNEXPECTED MSG. , 28, 0, DETECTED IN FILE:SQLUVLD.C, LINE:5506

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A LOAD job can unexpectedly end with issue raised on build phase
    of the LOAD reporting "Unexpected msg. , 28, 0, Detected in
    file:sqluvld.C, Line:5506". Issuing the same job a second time
    most often succeed. Symptoms in db2diag.log :
    
    2017-03-29-22.03.49.137730+000 I30026460A575        LEVEL:
    Warning
    PID     : 12648892             TID : 43353          PROC :
    db2sysc 1
    INSTANCE: xxxxxx               NODE : 001           DB   : xxxxx
    APPHDL  : 0-24524              APPID:
    xxx.xx.xxx.152.33465.170329215211
    AUTHID  : xxxxxx                HOSTNAME: xxxxxxxx
    EDUID   : 43353                EDUNAME: db2lrid0 1
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg,
    probe:315
    DATA #1 : String, 104 bytes
    LOADID: 40662.2017-03-29-21.52.11.535870.0 (32;26)
    Starting BUILD phase at 03/29/2017 22:03:49.134619.
    
    2017-03-29-22.03.49.144039+000 I30027036A582        LEVEL: Error
    PID     : 12648892             TID : 73769          PROC :
    db2sysc 1
    INSTANCE: xxxxxx               NODE : 001           DB   :
    xxxxxx
    APPHDL  : 0-24524              APPID:
    xxx.x.xxx.152.33465.170329215211
    AUTHID  : xxxxxxxx             HOSTNAME: kfdcpu02
    EDUID   : 73769                EDUNAME: db2lload 1
    FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag,
    probe:0
    DATA #1 : String, 113 bytes
    LOADID: 40662.2017-03-29-21.52.11.535870.0 (32;26)
    Unexpected msg. , 28, 0, Detected in file:sqluvld.C, Line:5506
    
    2017-03-29-22.03.49.145281+000 I30027619A1046       LEVEL: Error
    PID     : 12648892             TID : 73769          PROC :
    db2sysc 1
    INSTANCE: xxxxxx               NODE : 001           DB   :
    xxxxxx
    APPHDL  : 0-24524              APPID:
    xxx.x.xxx.152.33465.170329215211
    AUTHID  : xxxxxxxx             HOSTNAME: xxxxxxxx
    EDUID   : 73769                EDUNAME: db2lload 1
    FUNCTION: DB2 UDB, database utilities, sqlulFRMResponse,
    probe:5509
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 50 bytes
    LOADID: 40662.2017-03-29-21.52.11.535870.0 (32;26)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2044   sqlerrml: 1
    sqlerrmc: 4
    sqlerrp : SQLUVLD
    sqlerrd : (1) 0x8015006D      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000001
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    
    2017-03-29-22.03.49.147511+000 I30028666A537        LEVEL:
    Severe
    PID     : 12648892             TID : 73769          PROC :
    db2sysc 1
    INSTANCE: xxxxxx               NODE : 001           DB   :
    xxxxxx
    APPHDL  : 0-24524              APPID:
    xxx.x.xxx.152.33465.170329215211
    AUTHID  : xxxxxxxx             HOSTNAME: xxxxxxxx
    EDUID   : 73769                EDUNAME: db2lload 1
    FUNCTION: DB2 UDB, database utilities, sqlulFRMResponse,
    probe:5509
    MESSAGE : DIA0001E An internal error occurred. Report the
    following error code
              : "".
    
    2017-03-29-22.03.49.148644+000 I30029204A573        LEVEL:
    Severe
    PID     : 12648892             TID : 73769          PROC :
    db2sysc 1
    INSTANCE: xxxxxx               NODE : 001           DB   :
    xxxxxxxx
    APPHDL  : 0-24524              APPID:
    xxx.x.xxx.152.33465.170329215211
    AUTHID  : xxxxxxxx             HOSTNAME: xxxxxxx
    EDUID   : 73769                EDUNAME: db2lload 1
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging function), probe:50
    MESSAGE : rc
    DATA #1 : Hexdump, 4 bytes
    0x0A000000C4BFBC28 : 0000 0000
    ....
    
    2017-03-29-22.03.49.149623+000 I30029778A180      LEVEL: Severe
    PID:12648892 TID:73769 NODE:001 Title: commacb
    Dump
    File:/db2fs/xxxxxx/NODE0001/db2dump/12648892.73769.001.dump.bin
    
    2017-03-29-22.03.49.151080+000 I30029959A180      LEVEL: Severe
    PID:12648892 TID:73769 NODE:001 Title: loadacb
    Dump
    File:/db2fs/xxxxxx/NODE0001/db2dump/12648892.73769.001.dump.bin
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Using LOAD command                                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to version 11.1 M3 FP3                               *
    ****************************************************************
    

Problem conclusion

  • First fixed in version 11.1 M3 FP3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23141

  • 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-11-13

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

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

    IT20501

  • 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

  • RB10 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 March 2018