IC90228: USING XML IN QUERIES WITH REOPT BIND OPTION OR EXTENDED INDICATORS LEAKS MEMORY IN DATABASE HEAP IN DPF ENVIRONMENTS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A problem was introduced in DPF (multiple data partition)
    configurations in DB2 Version 9.7 Fix Pack 7 and Version 10.1
    Fix Pack 2 where memory is leaked on every recompile of a query
    referencing XML data.  Approximately 40K is leaked on each
    occurrence - the memory is allocated from the Database Heap
    memory pool inside the Database Memory set.
    
    Monitoring tools such as MON_GET_MEMORY_POOL, database snapshot,
    db2pd -alldbs -mempools will show the database heap continually
    growing in size.
    
    db2pd -alldbs -memblocks db 2
    will show a growing number of blocks similar to :
    Address            DataAddress        PoolID     PoolName
    BlkAge Size(Bytes)  I LOC   File
    0x07000004B1C3ED68 0x07000004B1C3ED80 2          dbh
    58235 2504         0 2228  1235116617
    0x07000004B1B30A48 0x07000004B1B30A60 2          dbh
    58233 2504         0 2228  1235116617
    0x07000004B1B31428 0x07000004B1B31440 2          dbh
    58229 2504         0 2228  1235116617
    ...
    
    Note the Size, LOC values may differ slightly, but the File
    value will be consistent.  It is also normal to have a buildup
    of allocations similar to this after database activation as
    tables are first accessed.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Systems using XML data in DPF environements together with    *
    * reopt bind option OR extended indicators                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix pack 8                        *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 Version 9.7 Fix Pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90228

  • 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-02-14

  • Closed date

    2013-07-10

  • Last modified date

    2013-07-10

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

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

    IC90241

Modules/Macros

  • sqri
    

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC90228

Modified date:

2013-07-10

Translate my page

Machine Translation

Content navigation