IBM Support

IC92681: MEMORY LEAK IN COMPILER MEMORY POOL WHEN COMPILING A SQL QUERY THAT REFERENCES A FEDERATED DATA SOURCE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When a SQL query that references a federated data source is
    compiled, memory might be leaking in the sqlch memory pool.  The
    size of the leak depends on the number of data sources
    referenced, the number of columns in each data source and the
    column names. The problem was observed so far only for the DDL
    operations on the nicknames.
    
    To check if you hit this APAR, you need to collect a few
    iterations of db2pd -memblocks output, and seek for continuously
    increasing TotalSize(Bytes) and TotalCount values in following
    LOC and File:
    
    PoolID PoolName TotalSize(Bytes) TotalCount LOC
    File
    50       sqlch        3660006            107738      1028
    2675033028
    50       sqlch        3680134            108330      1028
    2675033028
    50       sqlch        3681494            108370      1028
    2675033028
    ...
    50       sqlch        4033394            118720      1028
    2675033028
    

Local fix

  • The leaked memory can be recovered by recycling the DB2 instance
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * FEDERATED                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 fix pack 9                        *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 version 9.7 fix pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC92681

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

  • Closed date

    2013-12-16

  • Last modified date

    2013-12-16

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

    IC92132

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC92681

Modified date: 16 December 2013