IBM Support

IT20797: RUNSTATS DOES NOT HANDLE ALIASES ON CGTTS CORRECTLY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Runstats on the CGTT table will return SQL2310 with -83 reason
    code due to memory allocation failure.
    
    E.g.:
    CREATE GLOBAL TEMPORARY TABLE S1.CGTT  (c1 int);
    CREATE ALIAS S2.CGTT FOR TABLE S1.CGTT;
    runstats on table S2.CGTT;
    
    $ db2 runstats on table s2.cgtt
    SQL2310N  The utility could not generate statistics.  Error
    "-83" was
    returned.
    
    In db2diag.log, one can see:
    2017-05-29-16.51.56.564326-240 I7540821E2606         LEVEL:
    Warning
    PID     : 22524                TID : 140666722051840 PROC :
    db2sysc
    INSTANCE: amytang              NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-7                  APPID:
    *LOCAL.amytang.170529205053
    AUTHID  : AMYTANG              HOSTNAME: hotellnx116
    EDUID   : 18                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx,
    probe:1000
    MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
    invalid size"
              DIA8563C An invalid memory size was requested.
    DATA #1 : String, 43 bytes
    Memory management block allocation failure.
    DATA #2 : Codepath, 8 bytes
    2
    DATA #3 : Memory pool handle pointer,
    PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes
    0x00007fef689743b0
    DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    0
    DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8
    bytes
    0
    DATA #6 : Options for requested block, PD_TYPE_GET_MEM_OPTIONS,
    4 bytes
    0x00000200
    DATA #7 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 18 bytes
    sqlrl_temp_table.C
    DATA #8 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
    12173
    DATA #9 : Resource binding pointer,
    PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes
    0x0000000000000000
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00007FEF98CE6331 sqloGetMemoryBlockExtended + 0x3E1
      [1] 0x00007FEF99E30928
    _Z13sqlrlInitCGTTP8sqlrr_cbPhiS1_iP13sqlrlCGTTInfo + 0x418
      [2] 0x00007FEF992EF287
    _Z8sqlrrstaP8sqlrr_cbP11sqlrrstringS2_S2_hhP17sqlrl_stats_parmsP
    KhPs + 0x27F7
      [3] 0x00007FEF993727F6 _Z17sqlrr_runstats_DAP5sqldaP5sqlca +
    0x1876
      [4] 0x00007FEF972B6500
    _Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgent
    P5sqlca + 0x1160
      [5] 0x00007FEF972B8B47
    _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x1397
      [6] 0x00007FEF975609C8
    _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x618
      [7] 0x00007FEF9752BA0B
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x10B
      [8] 0x00007FEF9752CACE
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x54E
      [9] 0x00007FEF9751F9FA /home/amytang/sqllib/lib64/libdb2e.so.1
    + 0x55CE9FA
      [10] 0x00007FEF97525FD3
    /home/amytang/sqllib/lib64/libdb2e.so.1 + 0x55D4FD3
      [11] 0x00007FEF97526C8F
    _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x11F
      [12] 0x00007FEF96F623D3 _ZN8sqeAgent6RunEDUEv + 0xDE3
      [13] 0x00007FEF9A779E36 _ZN9sqzEDUObj9EDUDriverEv + 0x116
      [14] 0x00007FEF98D32DA8 sqloEDUEntry + 0x578
      [15] 0x00007FEFA0598806 /lib64/libpthread.so.0 + 0x7806
    
    
    2017-05-29-16.51.56.718079-240 I7543428E573          LEVEL:
    Error
    PID     : 22524                TID : 140666722051840 PROC :
    db2sysc
    INSTANCE: amytang              NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-7                  APPID:
    *LOCAL.amytang.170529205053
    AUTHID  : AMYTANG              HOSTNAME: hotellnx116
    EDUID   : 18                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, catalog services, sqlrlInitCGTT, probe:12176
    RETCODE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
    invalid size"
              DIA8563C An invalid memory size was requested.
    

Local fix

  • Run runstats against the real names instead.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * N/A                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v111m3fp3                                         *
    ****************************************************************
    

Problem conclusion

  • v111m3fp3 contains the fix, and runstats with CGTT alias will
    run successfully.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20797

  • 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-05-30

  • Closed date

    2018-03-15

  • Last modified date

    2018-03-15

  • 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

  • RA50 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"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:
15 March 2018