Nome da coluna |
Tipo de dados |
Descrição |
Uso |
NAME |
CHAR(8) NOT NULL |
Name of the table space. |
G |
CREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the table space |
G |
DBNAME |
CHAR(8) NOT NULL |
Name of the database containing the table space. |
G |
DBID |
SMALLINT NOT NULL |
Internal identifier of the database which contains the table space. |
S |
OBID |
SMALLINT NOT NULL |
Internal identifier of the table space file descriptor. |
S |
PSID |
SMALLINT NOT NULL |
Internal identifier of the table space page set descriptor. |
S |
BPOOL |
CHAR(8) NOT NULL |
Name of the buffer pool used for the table space. |
G |
PARTITIONS |
SMALLINT NOT NULL |
Number of partitions of the table space; 0 if the table space is not partitioned. |
G |
LOCKRULE |
CHAR(1) NOT NULL |
Lock size of the table space:
A Any
P Page
R Row
S Table space
T Table |
G |
PGSIZE |
SMALLINT NOT NULL |
Size of pages in the table space in kilobytes. |
G |
ERASERULE |
CHAR(1) NOT NULL |
Whether the data sets are to be erased when dropped. The value is
meaningless if the table space is partitioned.
N No erase
Y Erase |
G |
STATUS |
CHAR(1) NOT NULL |
Availability status of the table space:
A Available
C Definition is incomplete because no partitioned index has been
created.
P Table space is in a check pending state.
S Table space is in a check pending state with the scope less than the
entire table space.
T Definition is incomplete because no table has been created. |
G |
IMPLICIT |
CHAR(1) NOT NULL |
Whether the table space was created implicitly:
Y Yes
N No
|
G |
NTABLES |
SMALLINT NOT NULL |
Number of tables defined in the table space. |
G |
NACTIVE |
INTEGER NOT NULL |
Number of active pages in the table space. A page is termed active if it is
formatted for rows, even if it currently contains none. The value is 0 if
statistics have not been gathered. This is an updatable column. |
G |
DSETPASS |
CHAR(8) NOT NULL |
The password for the data sets of the table space. |
G |
CLOSERULE |
CHAR(1) NOT NULL |
Whether the data sets are candidates for closure when the limit on the
number of open data sets is reached.
Y Yes
N No |
G |
SPACE |
INTEGER NOT NULL |
Number of kilobytes of DASD storage allocated to the table space, as
determined by the last execution of the STOSPACE utility. The value is 0
if the table space is not related to a storage group, or if STOSPACE has
not been run. If the table space is partitioned, the value is the total
kilobytes of DASD storage allocated to all partitions that are storage
group defined. |
G |
IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM)
tape:
N No
Y Yes
C V2R1 dependency indicator; not from MRM tape
F V3R1 dependency indicator; not from MRM tape
G V4 dependency indicator; not from MRM tape
H V5 dependency indicator; not from MRM tape |
G |
|
VARCHAR(18) NOT NULL |
Internal use only |
I |
|
CHAR(8) NOT NULL |
Internal use only |
I |
SEGSIZE |
SMALLINT NOT NULL WITH DEFAULT |
The number of pages in each segment of a segmented table space. The
value is 0 (ZERO) if the table space is not segmented. |
G |
CREATEDBY |
CHAR(8) NOT NULL WITH DEFAULT |
Primary authorization ID of the user who created the table space. |
G |
STATSTIME |
TIMESTAMP NOT NULL WITH DEFAULT
| If RUNSTATS updated the statistics, the date and time when the last
invocation of RUNSTATS updated the statistics. The default value is
'0001-01-01.00.00.00.000000'. This is an updatable column. |
G |
LOCKMAX |
INTEGER |
The maximum number of locks per user to acquire for the table or table
space before escalating to the next locking level.
0 Lock escalation does not occur.
n
n, where n > 0, is the maximum number of locks (row or page
locks for the
table or table space) an application process can
acquire before lock escalation occurs.
-1 Represents LOCKMAX SYSTEM. The value of field LOCKS PER
TABLE(SPACE) on
installation panel DSNTIPJ determines lock
escalation. If the value of the field
is 0, lock escalation does not
occur. If the value is n, where n > 0, lock
escalation occurs as it
does for LOCKMAX n. |
G |
TYPE |
CHAR(1) NOT NULL WITH DEFAULT |
The type of table space:
blank The table space is not large and was not defined with MEMBER
CLUSTER.
I
The table space is not large and was defined with MEMBER
CLUSTER.
K
The table space is large and was defined with MEMBER
CLUSTER.
L
The table space is large and was not defined with MEMBER
CLUSTER |
G |
CREATEDTS |
TIMESTAMP NOT NULL WITH DEFAULT |
Time when the CREATE statement was executed for the table space. If
the table space was created in a DB2 release prior to Version 5, the
value is '0001-01-01.00.00.00.000000'. |
G |
ALTEREDTS |
TIMESTAMP NOT NULL WITH DEFAULT |
Time when the most recent ALTER TABLESPACE statement was
executed for the table space. If no ALTER TABLESPACE statement has
been applied, ALTEREDTS has the value of CREATEDTS. If the index was
created in a DB2 release prior to Version 5, the value is
'0001-01-01.00.00.00.000000'. |
G |
ENCODING_SCHEME |
CHAR(1) NOT NULL WITH DEFAULT |
Default encoding scheme for the table space.
E EBCDIC
A ASCII
blank For tables spaces in work file databases.
The value will be 'E' for tables in non work file databases and blank for
tables in work file databases created prior to Version 5 or the default
database, DSNDB04. |
G |
SBCS_CCSID |
INTEGER NOT NULL WITH DEFAULT |
Default SBCS CCSID for the table space. For databases created in a DB2
release prior to Version 5, the value is 0. |
G |
DBCS_CCSID |
INTEGER NOT NULL WITH DEFAULT |
Default DBCS CCSID for the table space. For databases created in a DB2
release prior to Version 5,the value is 0. |
G |
MIXED_CCSID |
INTEGER NOT NULL WITH DEFAULT |
Default mixed CCSID for the table space. For databases created in a DB2
release prior to Version 5, the value is 0. |
G |
MAXROWS |
SMALLINT NOT NULL DEFAULT 255 |
The maximum number of rows that DB2 will place on a data page. The
default value is 255. |
G |
LOCKPART |
CHAR(1) NOT NULL WITH DEFAULT |
Y LOCKPART YES is specified for the table space.
blank
LOCKPART NO is specified, or LOCKPART is not specified or
not a partitioned table space. |
G |