DB2 Version 9.7 for Linux, UNIX, and Windows

FP5: Some administrative routines and views have changed

In Version 9.7, Fix Pack 5 and later fix packs, there have been additional return fields included in some administrative routines and views.

Several table functions and administrative views are enhanced in Version 9.7, Fix Pack 5. These monitoring routines now return additional information about your databases and corresponding systems.

MON_BP_UTILIZATION

Now returns information about:

AVG_SYNC_READ_TIME
AVG_ASYNC_READ_TIME
AVG_SYNC_WRITE_TIME
AVG_ASYNC_WRITE_TIME

MON_GET_BUFFERPOOL

Now returns information about:

POOL_ASYNC_READ_TIME
POOL_ASYNC_WRITE_TIME
BP_CUR_BUFFSZ

MON_GET_TABLE

Now returns information about:

DATA_OBJECT_PAGES
LOB_OBJECT_PAGES
LONG_OBJECT_PAGES
INDEX_OBJECT_PAGES
XDA_OBJECT_PAGES

MON_GET_TABLESPACE

Now returns information about:

POOL_ASYNC_READ_TIME
POOL_ASYNC_WRITE_TIME
TBSP_TRACKMOD_STATE