IC84266: CHANCES OF MEMORY LEAK INTRODUCED IN VERSION 9.7 FIX PACK 5

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In Version 9.7 Fix Pack 5, chances of having a memory leak have
  been introduced. To check if a memory leak has happened, issue
  the db2pd -memb command and check if the output of the command
  looks similar to the following output:
  
  Memory blocks sorted by size for private pool:
  PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
  88         private    264376936                      164622
  1541  2904145706
  88         private    131072                               1
  1287  789176096
  88         private    49152                                  5
  385   1234005865
  88         private    7072                                    2
  1253  2506170342
  88         private    4296                                    1
  246   2926445243
  
  Total size for PRIVATE memory set: 283633406 bytes
  
  Memory blocks sorted by size for private pool:
  PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
  88         private    283437968                     175389
  1541  2904145706
  88         private    131072                             1
  1287  789176096
  88         private    49152                                5
  385   1234005865
  88         private    7072                                2
  1253  2506170342
  
  The private memory usage in file 2904145706 at line 1541 keeps
  leaking and consumes physical memory.
  
  This memory leak can happen if a query uses a LOB locator for
  the output column.
  
  Example:
  ODBC  application does:
  select substr( clob_column, 1, 30 ) from t1
  SQLBindCol is done with with SQL_C_CLOB_LOCATOR
  
  The query is returning a LOB column, but the client wants a LOB
  locator.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * N/A                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Install fix                                                  *
  ****************************************************************
  

Problem conclusion

• Install fix
  

Temporary fix

Comments

APAR Information

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

  IC80394

• 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 PSY

     UP