- 论坛徽章:
- 0
|
古老的帖子!
用SYSIBMADM.CONTAINER_UTILIZATION查到的只有container_usable_pages和container_total_pages,再算出来吧!
为什么不用select?用db2pd或db2support行吗?
也可以参考这个API:sqlbmtsq,在/usr/opt/db2_08_01/include/sqlutil.h中:
API and data structure syntax
SQL_API_RC SQL_API_FN /* Tablespace Query */
sqlbmtsq (
struct sqlca * pSqlca, /* SQLCA */
sqluint32 * pNumTablespaces, /* out: total number of */
/* table spaces */
struct SQLB_TBSPQRY_DATA *** pppTablespaceData, /* out: mem returned to */
/* application */
sqluint32 reserved1, /* in: SQLB_RESERVED1 */
sqluint32 reserved2); /* in: SQLB_RESERVED2 */
/******************************************************************************
** sqlgmtsq API
*******************************************************************************/
SQL_API_RC SQL_API_FN /* TableSpace Query */
sqlgmtsq (
struct sqlca * pSqlca,
sqluint32 * pNumTablespaces, /* out: total number of */
/* table spaces */
struct SQLB_TBSPQRY_DATA *** pppTablespaceData, /* out: mem returned to */
/* application */
sqluint32 reserved1, /* in: SQLB_RESERVED1 */
sqluint32 reserved2); /* in: SQLB_RESERVED2 */ |
|