IBM Books

API Reference

sqlbgtss - Get Tablespace Statistics

Provides information on the space utilization of a table space.

Scope

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

Authorization

One of the following:

sysadm
sysctrl
sysmaint
dbadm

Required Connection

Database

API Include File

sqlutil.h

C API Syntax 



/* File: sqlutil.h */
/* API: Get Tablespace Statistics */
/* ... */
SQL_API_RC SQL_API_FN
  sqlbgtss (
    struct sqlca * pSqlca,
    unsigned long TablespaceId,
    struct SQLB_TBS_STATS * pTablespaceStats);
/* ... */

Generic API Syntax 



/* File: sqlutil.h */
/* API: Get Tablespace Statistics */
/* ... */
SQL_API_RC SQL_API_FN
  sqlggtss (
    struct sqlca * pSqlca,
    unsigned long TablespaceId,
    struct SQLB_TBS_STATS * pTablespaceStats);
/* ... */

API Parameters

pSqlca
Output. A pointer to the sqlca structure. For more information about this structure, see SQLCA.
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. For more information about this structure, see SQLB-TBS-STATS.

Sample Programs

C
\sqllib\samples\c\tabspace.sqc

COBOL
\sqllib\samples\cobol\tabspace.sqb

FORTRAN
\sqllib\samples\fortran\tabspace.sqf

Usage Notes

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

See Also

sqlbctsq - Close Tablespace Query



[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]