IT05262: RSAM POOL GROWS LARGE AFTER DBSCHEMA OR SYSMASTER QUERY WHEN AN INSTANCE HAS MANY DATABASES, TABLES, AND INDEXES

APAR status

• Closed as program error.

Error description

• The instance has hundreds or more databases and thousands of
  tables and indexes. Some sysmaster queries and dbschema -c -ns
  will cause many tables and indexes data to be cached in the RSAM
  pool. On systems with a large number of databases, tables, and
  indexes the RSAM pool can grow by gigabytes.
  
  onstat -g afr rsam will show many entries like this:
  
  3eb604000        49152      keys         3555   rsbtree.c:82
  3eb610000        32768      keys         3555   rsbtree.c:82
  3eb618000        1232       partn        3626   rspartn.c:6098
  3eb6184d0        64         partn        3626   rspartn.c:6497
  3eb618510        80         partn        3626   rspartn.c:6539
  3eb618560        64         keys         3551   rsbtcln.c:3625
  3eb6185a0        96         keys         3551   rsbtcln.c:3671
  3eb618600        176        keys         3601   rskey.c:3279
  3eb61a000        39280      keys         3555   rsbtree.c:82
  3eb623970        1232       partn        3626   rspartn.c:6098
  
  Subsequent run of the sysmaster query or dbschema do not cause
  memory usage to increase. Although this caching is normal
  behavior in the case of an instance with many databases, tables,
  and indexes the allocation of memory can be excessive ( over 12
  GB in one specific system, leading to a crash ).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * large number of index per instance                           *
  * (several hundred thousand)                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC9                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC9
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RB70 PSN

     UP

• RB70 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP