IBM Support

JR30988: ALTER SEQUENCE STATEMENT CAUSES MEMORY LEAK IN APPLICATION HEAP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running ALTER SEQUENCE statement in a loop causing memory leak
    in DB2 application heap. This can be monitored in V9.5 with
    db2mtrk -a or by running "db2pd -db <dbname> -memb all".
    This should produce a similiar output like:
    
    Memory blocks sorted by size for apph pool:
    PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
    1          apph       92000000             500000     281
    882766201
    ...
    
    All memory consumers in AppCtl memory set:
    PoolID     PoolName   TotalSize(Bytes)     %Bytes TotalCount
    %Count LOC   File
    1          apph       92000000             99.43  500000
    14.28  281   882766201
    

Local fix

  • If possible disconnect the application from time to time.
    This should release the memory.
    
    This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • Users Affected: ALL
    
    Problem Description:
    
    Running ALTER SEQUENCE statement in a loop causing memory leak
    in DB2 application heap. This can be monitored in V9.5 with
    db2mtrk -a or by running "db2pd -db <dbname> -memb all".
    This should produce a similiar output like:
    
    Memory blocks sorted by size for apph pool:
    PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
    1          apph       92000000             500000     281
    882766201
    ...
    
    All memory consumers in AppCtl memory set:
    PoolID     PoolName   TotalSize(Bytes)     %Bytes TotalCount
    %Count LOC   File
    1          apph       92000000             99.43  500000
    14.28  281   882766201
    
    Problem Summary:  See Problem Description.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 4 (build s090429)
    

Temporary fix

  • see LOCAL FIX
    

Comments

APAR Information

  • APAR number

    JR30988

  • Reported component name

    DB2 UDB WSE WIN

  • Reported component ID

    5765F3501

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-04

  • Closed date

    2009-06-15

  • Last modified date

    2010-12-09

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

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

    JR30989

Fix information

  • Fixed component name

    DB2 UDB WSE WIN

  • Fixed component ID

    5765F3501

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

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

Document Information

Modified date:
09 December 2010