IBM Support

IT18118: INSTANCE CAN TRAP IN SQLDVALFROMFIXEDCOMMON WHEN SELECT A NULL CLOB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Instance can trap in sqldValFromFixedCommon when select a NULL
    CLOB.
    
    The database/table must also have been created under v6 and
    upgrade through to v11.1
    
    db2diag.log:
    
    2016-09-20-18.28.33.284000-180 I146603093F535       LEVEL:
    Warning
    PID     : 2168                 TID : 5104           PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   :
    BDPROD
    APPHDL  : 0-10645              APPID: *LOCAL.DB2.160920223039
    AUTHID  : DB2DBA               HOSTNAME: DB2PMW01
    EDUID   : 5104                 EDUNAME: db2agent (BDPROD) 0
    FUNCTION: DB2 UDB, RAS/PD component,
    pdEDUIsInDB2KernelOperation, probe:600
    DATA #1 : String, 12 bytes
    sqldReadNorm
    DATA #2 : String, 4 bytes
    sqld
    
    2016-09-20-18.28.33.299000-180 I146603630F613       LEVEL:
    Severe
    PID     : 2168                 TID : 5104           PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   :
    BDPROD
    APPHDL  : 0-10645              APPID: *LOCAL.DB2.160920223039
    AUTHID  : DB2DBA               HOSTNAME: DB2PMW01
    EDUID   : 5104                 EDUNAME: db2agent (BDPROD) 0
    FUNCTION: DB2 UDB, RAS/PD component,
    pdResilienceIsSafeToSustain, probe:800
    DATA #1 : String, 37 bytes
    Trap Sustainability Criteria Checking
    DATA #2 : Hex integer, 8 bytes
    0x0000000400021840
    DATA #3 : Boolean, 1 bytes
    false
    
    ...
    2016-09-20-18.28.52.053000-180 I146613258F621       LEVEL: Error
    PID     : 2168                 TID : 5104           PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   :
    BDPROD
    APPHDL  : 0-10645              APPID: *LOCAL.DB2.160920223039
    AUTHID  : DB2DBA               HOSTNAME: DB2PMW01
    EDUID   : 5104                 EDUNAME: db2agent (BDPROD) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
    probe:10
    MESSAGE : Error in agent servicing application with APPLICATION
    NAME:
    DATA #1 : Hexdump, 7 bytes
    0x0000006A0174876A : 4442 3248 4D4F 4E
    DB2HMON
    
    2016-09-20-18.28.52.146000-180 I146613881F537       LEVEL:
    Severe
    PID     : 2168                 TID : 5104           PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   :
    BDPROD
    APPHDL  : 0-10645              APPID: *LOCAL.DB2.160920223039
    AUTHID  : DB2DBA               HOSTNAME: DB2PMW01
    EDUID   : 5104                 EDUNAME: db2agent (BDPROD) 0
    FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler,
    probe:10
    MESSAGE : DIA0505I Execution of a component signal handling
    function has begun.
    
    2016-09-20-18.28.52.178000-180 I146614420F232     LEVEL: Severe
    PID:2168 TID:5104 NODE:000 Title: **** DRDA ASCB ****
    Dump
    File:C:\DB2INSTALL\\IBM\DB2\DB2COPY1\DB2\FODC_Trap_2016-09-20-18
    .28.33.174000_0000\2168.5104.000.dump.bin
    
    Stack:
    0000000088BCB990  offset: 00000000000000E7 in
    <sqldValFromFixedCommon>
    0000000088BCBA80  offset: 0000000000000B03 in <sqldReturnData>
    0000000088BCBF80  offset: 000000000000264E in <sqldRowFetch>
    0000000088BCC070  offset: 00000000000005C1 in
    <sqlritaSimplePerm>
    0000000088BCC2E0  offset: 0000000000000504 in <sqlriSectInvoke>
    0000000088BCC3C0  offset: 000000000000060E in
    <sqlrr_process_fetch_request>
    0000000088BCC580  offset: 00000000000007F6 in <sqlrr_fetch>
    0000000088BCC680  offset: 0000000000000571 in <sqljs_ddm_cntqry>
    0000000088BCC730  offset: 0000000000000129 in
    <sqljsParseRdbAccessed>
    0000000088BCC960  offset: 000000000000051C in <sqljsParse>
    0000000088BCCB00  offset: 000000000000061A in <sqljsSqlam>
    0000000088BCCD60  offset: 0000000000000586 in
    <sqljsDrdaAsInnerDriver>
    0000000088BCCEA0  offset: 0000000000000163 in
    <sqljsDrdaAsDriver>
    0000000088BCE100  offset: 0000000000000FBA in <sqeAgent::RunEDU>
    0000000088BCE190  offset: 000000000000017A in <sqlzRunEDU>
    0000000088BCFEB0  offset: 000000000000061D in <sqloEDUEntry>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 11.1 Mod 2 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT18118

  • 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

    2016-11-25

  • Closed date

    2017-06-23

  • Last modified date

    2017-06-23

  • 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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020