DB2 Version 9.7 for Linux, UNIX, and Windows

sqlbgtss API - Get table space usage statistics

Provides information on the space utilization of a table space.

Important: This command or API has been deprecated and might be removed in a future release. You can use the MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions instead which return more information. For more information, see LIST TABLESPACES and LIST TABLESPACE CONTAINERS commands have been deprecated.

Scope

In a partitioned database environment, only the table spaces on the current database partition are listed.

Authorization

One of the following:

sysadm
sysctrl
sysmaint
sysmon
dbadm
load

Required connection

Database

API include file

sqlutil.h

API and data structure syntax

SQL_API_RC SQL_API_FN
  sqlbgtss (
   struct sqlca * pSqlca,
   sqluint32 TablespaceId,
   struct SQLB_TBS_STATS * pTablespaceStats);

SQL_API_RC SQL_API_FN
  sqlggtss (
   struct sqlca * pSqlca,
   sqluint32 TablespaceId,
   struct SQLB_TBS_STATS * pTablespaceStats);

sqlbgtss API parameters

pSqlca: Output. A pointer to the sqlca structure.
TablespaceId: Input. ID of the single table space to be queried.
pTablespaceStats: Output. A pointer to a user-allocated SQLB_TBS_STATS structure. The information about the table space is returned in this structure.

Usage notes

See SQLB-TBS-STATS for information about the fields returned and their meaning.