Starting in Version 9.7 Fix Pack 5, three monitoring table
functions and their corresponding administrative views have been deprecated
and might be removed in a future release.
Details
With the introduction of the two new
table functions MON_GET_MEMORY_SET and MON_GET_MEMORY_POOL in Version
9.7 Fix Pack 5, the following table functions are deprecated:
- The SNAP_GET_DBM_MEMORY_POOL table function and SNAPDBM_MEMORY_POOL
administrative view
- The SNAP_GET_DB_MEMORY_POOL table function and SNAPDB_MEMORY_POOL
administrative view
- The SNAP_GET_AGENT_MEMORY_POOL table function and SNAPAGENT_MEMORY_POOL
administrative view
In addition, the MON_GET_TABLE table function has been enhanced
to include additional information about the number of disk pages used
for storing different types of data objects. Because of this enhancement,
the SNAP_GET_TAB_V91 table function and the SNAPTAB administrative
view have been deprecated.
Resolution
Start using the new table functions
MON_GET_MEMORY_SET and MON_GET_MEMORY_POOL to get information about
memory usage, and the MON_GET_TABLE table function to obtain information
about disk pages before the deprecated views and table functions are
removed.
DB2 Version 9.7 for Linux, UNIX, and Windows