This structure is used to return table space data to an application
program.
Table 14. Fields in the SQLB-TBSPQRY-DATA Structure
| Field Name | Data Type | Description |
|---|---|---|
| TBSPQVER | CHAR(8) | Structure version identifier. |
| ID | INTEGER | Internal identifier for the table space. |
| NAMELEN | INTEGER | Length of the table space name. |
| NAME | CHAR(128) | Null-terminated name of the table space. |
| TOTALPAGES | INTEGER | Number of pages specified by CREATE TABLESPACE (DMS only). |
| USEABLEPAGES | INTEGER | TOTALPAGES minus overhead (DMS only). This value is rounded down to the next multiple of 4KB. |
| FLAGS | INTEGER | Bit attributes for the table space. |
| PAGESIZE | INTEGER | Page size (in bytes) of the table space. Currently fixed at 4KB. |
| EXTSIZE | INTEGER | Extent size (in pages) of the table space. |
| PREFETCHSIZE | INTEGER | Prefetch size. |
| NCONTAINERS | INTEGER | Number of containers in the table space. |
| TBSSTATE | INTEGER | Table space states. |
| LIFELSN | CHAR(6) | Time stamp identifying the origin of the table space. |
| FLAGS2 | INTEGER | Bit attributes for the tablespace. |
| MINIMUMRECTIME | CHAR(27) | Earliest point in time that may be specified by point-in-time tablespace rollforward. |
| STATECHNGOBJ | INTEGER | If TBSSTATE is SQLB_LOAD_PENDING or SQLB_DELETE_PENDING, the object id in tablespace STATECHANGEID that caused the tablespace state to be set. Otherwise zero. |
| STATECHNGID | INTEGER | If TBSSTATE is SQLB_LOAD_PENDING or SQLB_DELETE_PENDING, the tablespace id of the object STATECHANGEOBJ that caused the tablespace state to be set. Otherwise zero. |
| NQUIESCERS | INTEGER | If TBSSTATE is SQLB_QUIESCED_SHARE, UPDATE, or EXCLUSIVE, the number of quiescers of the tablespace and the number of entries in QUIESCERS. |
| QUIESCEID | INTEGER | The tablespace id of the object QUIESCEOBJ that caused the tablespace to be quiesced. |
| QUIESCEOBJ | INTEGER | The object id in tablespace QUIESCEID that caused the tablespace to be quiesced. |
| RESERVED | CHAR(32) | Reserved for future use. |
Possible values for FLAGS (defined in sqlutil) are:
Possible values for TBSSTATE (defined in sqlutil) are:
Possible values for FLAGS2 (defined in sqlutil) are:
Language Syntax
C Structure
/* File: sqlutil.h */
/* ... */
SQL_STRUCTURE SQLB_TBSPQRY_DATA
{
char tbspqver[SQLB_SVERSION_SIZE];
unsigned long id;
unsigned long nameLen;
char name[SQLB_MAX_TBS_NAME_SZ];
unsigned long totalPages;
unsigned long useablePages;
unsigned long flags;
unsigned long pageSize;
unsigned long extSize;
unsigned long prefetchSize;
unsigned long nContainers;
unsigned long tbsState;
char lifeLSN[6];
char pad[2];
unsigned long flags2;
char minimumRecTime[SQL_STAMP_STRLEN+1];
char pad1[1];
unsigned long StateChngObj;
unsigned long StateChngID;
unsigned long nQuiescers;
struct SQLB_QUIESCER_DATA quiescer[SQLB_MAX_QUIESCERS];
char reserved[32];
};
/* ... */
|
/* File: sqlutil.h */
/* ... */
SQL_STRUCTURE SQLB_QUIESCER_DATA
{
unsigned long quiesceId;
unsigned long quiesceObject;
};
/* ... */
|
COBOL Structure
* File: sqlutbsp.cbl
01 SQLB-TBSPQRY-DATA.
05 SQL-TBSPQVER PIC X(8).
05 SQL-ID PIC 9(9) COMP-5.
05 SQL-NAME-LEN PIC 9(9) COMP-5.
05 SQL-NAME PIC X(128).
05 SQL-TOTAL-PAGES PIC 9(9) COMP-5.
05 SQL-USEABLE-PAGES PIC 9(9) COMP-5.
05 SQL-FLAGS PIC 9(9) COMP-5.
05 SQL-PAGE-SIZE PIC 9(9) COMP-5.
05 SQL-EXT-SIZE PIC 9(9) COMP-5.
05 SQL-PREFETCH-SIZE PIC 9(9) COMP-5.
05 SQL-N-CONTAINERS PIC 9(9) COMP-5.
05 SQL-TBS-STATE PIC 9(9) COMP-5.
05 SQL-LIFE-LSN PIC X(6).
05 SQL-PAD PIC X(2).
05 SQL-FLAGS2 PIC 9(9) COMP-5.
05 SQL-MINIMUM-REC-TIME PIC X(26).
05 FILLER PIC X.
05 SQL-PAD1 PIC X(1).
05 SQL-STATE-CHNG-OBJ PIC 9(9) COMP-5.
05 SQL-STATE-CHNG-ID PIC 9(9) COMP-5.
05 SQL-N-QUIESCERS PIC 9(9) COMP-5.
05 SQL-QUIESCER OCCURS 5 TIMES.
10 SQL-QUIESCE-ID PIC 9(9) COMP-5.
10 SQL-QUIESCE-OBJECT PIC 9(9) COMP-5.
05 SQL-RESERVED PIC X(32).
*
|