IBM Support

IC89599: SQL0083C WHEN QUERYING TABLE SPACE CONTAINERS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • There are cases when a table space does not have any containers
    defined, for example during a restore into a staging database.
    Querying the containers for such a table space will fail with
    SQL0083C, e.g.:
    
    $ db2 list tablespace containers for 3
    SQL0083C  A memory allocation error has occurred.
    
    The DB2 diagnostic log will contain messages similar to:
    
    2012-11-30-15.24.32.880093-300 I1064514E3058         LEVEL:
    Warning
    PID     : 22028                TID : 46913126656320  KTID :
    23157
    PROC    : db2sysc
    INSTANCE: db2inst1               NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-20                 APPID:
    *LOCAL.db2inst1.121130202054
    AUTHID  : PSUSTR               HOSTNAME: hotel59
    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.
    
    <...skipping...>
    
    DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    0
    
    <...skipping...>
    
    DATA #8 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 11 bytes
    sqlbagapi.C
    DATA #9 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
    1665
    
    <...skipping...>
    
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] pdLog + 0x230
      [1] sqlogmblkEx + 0x22C6
      [2] sqlbQryPoolCont + 0x12EB
      [3] sqlbOpenPoolContQry + 0x109
    
    <...skipping...>
    
    2012-11-30-15.24.32.897240-300 I1067573E594          LEVEL:
    Error
    PID     : 22028                TID : 46913126656320  KTID :
    23157
    PROC    : db2sysc
    INSTANCE: db2inst1               NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-20                 APPID:
    *LOCAL.db2inst1.121130202054
    AUTHID  : PSUSTR               HOSTNAME: hotel59
    EDUID   : 18                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, buffer pool services, sqlbQryPoolCont,
    probe:1316
    MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
    invalid size"
              DIA8563C An invalid memory size was requested.
    

Local fix

  • Do not query the table space containers
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * See Error Description                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 for Linux, UNIX, and Windows Fix Pack 8.  *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 9.7 for Linux, UNIX, and Windows Fix
    Pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89599

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-17

  • Closed date

    2013-04-02

  • Last modified date

    2013-04-02

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

    IC88781

  • 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

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

Document Information

Modified date:
02 April 2013