JR30989: ALTER SEQUENCE STATEMENT CAUSES MEMORY LEAK IN APPLICATION HEAP

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

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.
  

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.1, FixPak 7 (build s090308)
  

Temporary fix

• see LOCAL FIX
  

Comments

APAR Information

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

  JR30988

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

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