| TABSCHEMA |
VARCHAR(128) |
|
Schema name of the object. |
| TABNAME |
VARCHAR(128) |
|
Unqualified name of the object. |
| OWNER |
VARCHAR(128) |
|
Authorization ID under which the table, view,
alias, or nickname was created. |
| TYPE |
CHAR(1) |
|
Type of object.
- A = Alias
- G = Global temporary table
- H = Hierarchy table
- L = Detached table
- N = Nickname
- S = Materialized query table
- T = Table (untyped)
- U = Typed table
- V = View (untyped)
- W = Typed view
|
| STATUS |
CHAR(1) |
|
Status of the object.
- C = Set integrity pending
- N = Normal
- X = Inoperative
|
| BASE_TABSCHEMA |
VARCHAR(128) |
Y |
If TYPE = 'A', contains the schema name of the
table, view, alias, or nickname that is referenced by this alias;
null value otherwise. |
| BASE_TABNAME |
VARCHAR(128) |
Y |
If TYPE = 'A', contains the unqualified name of
the table, view, alias, or nickname that is referenced by this
alias; null value otherwise. |
| ROWTYPESCHEMA |
VARCHAR(128) |
Y |
Schema name of the row type for this table, if
applicable; null value otherwise. |
| ROWTYPENAME |
VARCHAR(128) |
Y |
Unqualified name of the row type for this table,
if applicable; null value otherwise. |
| CREATE_TIME |
TIMESTAMP |
|
Time at which the object was created. |
| INVALIDATE_TIME |
TIMESTAMP |
|
Time at which the object was last
invalidated. |
| STATS_TIME |
TIMESTAMP |
Y |
Time at which any change was last made to recorded
statistics for this object. Null if statistics are not
collected. |
| COLCOUNT |
SMALLINT |
|
Number of columns, including inherited columns (if
any). |
| TABLEID |
SMALLINT |
|
Internal logical object identifier. |
| TBSPACEID |
SMALLINT |
|
Internal logical identifier for the primary table
space for this object. |
| CARD |
BIGINT |
|
Total number of rows; -1 if statistics are not
collected. |
| NPAGES |
BIGINT |
|
Total number of pages on which the rows of the
table exist; -1 for a view or alias, or if statistics are not
collected; -2 for a subtable or hierarchy table. |
| FPAGES |
BIGINT |
|
Total number of pages; -1 for a view or alias, or
if statistics are not collected; -2 for a subtable or hierarchy
table. |
| OVERFLOW |
BIGINT |
|
Total number of overflow records in the table; -1
for a view or alias, or if statistics are not collected; -2 for a
subtable or hierarchy table. |
| TBSPACE |
VARCHAR(128) |
Y |
Name of the primary table space for the table. If
no other table space is specified, all parts of the table are
stored in this table space. Null for aliases, views, and
partitioned tables. |
| INDEX_TBSPACE |
VARCHAR(128) |
Y |
Name of the table space that holds all indexes
created on this table. Null for aliases, views, and partitioned
tables, or if the INDEX IN clause was omitted or specified with the
same value as the IN clause of the CREATE TABLE statement. |
| LONG_TBSPACE |
VARCHAR(128) |
Y |
Name of the table space that holds all long data
(LONG or LOB column types) for this table. Null for aliases, views,
and partitioned tables, or if the LONG IN clause was omitted or
specified with the same value as the IN clause of the CREATE TABLE
statement. |
| PARENTS |
SMALLINT |
Y |
Number of parent tables for this object; that is,
the number of referential constraints in which this object is a
dependent. |
| CHILDREN |
SMALLINT |
Y |
Number of dependent tables for this object; that
is, the number of referential constraints in which this object is a
parent. |
| SELFREFS |
SMALLINT |
Y |
Number of self-referencing referential constraints
for this object; that is, the number of referential constraints in
which this object is both a parent and a dependent. |
| KEYCOLUMNS |
SMALLINT |
Y |
Number of columns in the primary key. |
| KEYINDEXID |
SMALLINT |
Y |
Index identifier for the primary key index; 0 or
the null value if there is no primary key. |
| KEYUNIQUE |
SMALLINT |
|
Number of unique key constraints (other than the
primary key constraint) defined on this object. |
| CHECKCOUNT |
SMALLINT |
|
Number of check constraints defined on this
object. |
| DATACAPTURE |
CHAR(1) |
|
- L = Table participates in data replication, including
replication of LONG VARCHAR and LONG VARGRAPHIC columns
- N = Table does not participate in data replication
- Y = Table participates in data replication, excluding
replication of LONG VARCHAR and LONG VARGRAPHIC columns
|
| CONST_CHECKED |
CHAR(32) |
|
- Byte 1 represents foreign key constraint.
- Byte 2 represents check constraint.
- Byte 5 represents materialized query table.
- Byte 6 represents generated column.
- Byte 7 represents staging table.
- Byte 8 represents data partitioning constraint.
- Other bytes are reserved for future use.
Possible values are:
- F = In byte 5, the materialized query table cannot be refreshed
incrementally. In byte 7, the content of the staging table is
incomplete and cannot be used for incremental refresh of the
associated materialized query table.
- N = Not checked
- U = Checked by user
- W = Was in 'U' state when the table was placed in set integrity
pending state
- Y = Checked by system
|
| PMAP_ID |
SMALLINT |
Y |
Identifier for the distribution map that is
currently in use by this table (null for aliases or views). |
| PARTITION_MODE |
CHAR(1) |
|
Indicates how data is distributed among database
partitions in a partitioned database system.
- H = Hashing
- R = Replicated across database partitions
- Blank = No database partitioning
|
| LOG_ATTRIBUTE |
CHAR(1) |
|
- Always 0. This column is no longer used.
|
| PCTFREE |
SMALLINT |
|
Percentage of each page to be reserved for future
inserts. |
| APPEND_MODE |
CHAR(1) |
|
Controls how rows are inserted into pages.
- N = New rows are inserted into existing spaces, if
available
- Y = New rows are appended to the end of the data
Initial value is 'N'. |
| REFRESH |
CHAR(1) |
|
Refresh mode.
- D = Deferred
- I = Immediate
- O = Once
- Blank = Not a materialized query table
|
| REFRESH_TIME |
TIMESTAMP |
Y |
For REFRESH = 'D' or 'O', time at which the data
was last refreshed (REFRESH TABLE statement); null value
otherwise. |
| LOCKSIZE |
CHAR(1) |
|
Indicates the preferred lock granularity for
tables that are accessed by data manipulation language (DML)
statements. Applies to tables only. Possible values are:
- I = Block insert
- R = Row
- T = Table
- Blank = Not applicable
Initial value is 'R'. |
| VOLATILE |
CHAR(1) |
|
- C = Cardinality of the table is volatile
- Blank = Not applicable
|
| ROW_FORMAT |
CHAR(1) |
|
Not used. |
| PROPERTY |
VARCHAR(32) |
|
Properties for a table. A single blank indicates
that the table has no properties. |
| STATISTICS_PROFILE |
CLOB(10M) |
Y |
RUNSTATS command used to register a statistical
profile for the object. |
| COMPRESSION |
CHAR(1) |
|
- B = Both value and row compression are activated
- N = No compression is activated; a row format that does not
support compression is used
- R = Row compression is activated; a row format that supports
compression might be used
- V = Value compression is activated; a row format that supports
compression is used
- Blank = Not applicable
|
| ACCESS_MODE |
CHAR(1) |
|
Access restriction state of the object. These
states only apply to objects that are in set integrity pending
state or to objects that were processed by a SET INTEGRITY
statement. Possible values are:
- D = No data movement
- F = Full access
- N = No access
- R = Read-only access
|
| CLUSTERED |
CHAR(1) |
Y |
- Y = Table is multidimensionally clustered (even if only by one
dimension)
- Null value = Table is not multidimensionally clustered
|
| ACTIVE_BLOCKS |
BIGINT |
|
Total number of active blocks in the table, or -1.
Applies to multidimensional clustering (MDC) tables only. |
| DROPRULE |
CHAR(1) |
|
- N = No rule
- R = Restrict rule applies on drop
|
| MAXFREESPACESEARCH |
SMALLINT |
|
Reserved for future use. |
| AVGCOMPRESSEDROWSIZE |
SMALLINT |
|
Average length (in bytes) of compressed rows in
this table; -1 if statistics are not collected. |
| AVGROWCOMPRESSIONRATIO |
REAL |
|
For compressed rows in the table, this is the
average compression ratio by row; that is, the average uncompressed
row length divided by the average compressed row length; -1 if
statistics are not collected. |
| AVGROWSIZE |
SMALLINT |
|
Average length (in bytes) of both compressed and
uncompressed rows in this table; -1 if statistics are not
collected. |
| PCTROWSCOMPRESSED |
REAL |
|
Compressed rows as a percentage of the total
number of rows in the table; -1 if statistics are not
collected. |
| LOGINDEXBUILD |
VARCHAR(3) |
Y |
Level of logging that is to be performed during
create, recreate, or reorganize index operations on the table.
- OFF = Index build operations on the table will be logged
minimally
- ON = Index build operations on the table will be logged
completely
- Null value = Value of
the logindexbuilddatabase configuration
parameter will be used to determine whether or not index build
operations are to be completely logged
|
| CODEPAGE |
SMALLINT |
|
Code page of the object. This is the default code
page used for all character columns, triggers, check constraints,
and expression-generated columns. |
| ENCODING_SCHEME |
CHAR(1) |
|
- A = CCSID ASCII was specified
- U = CCSID UNICODE was specified
- Blank = CCSID clause was not specified
|
| PCTPAGESSAVED |
SMALLINT |
|
Approximate percentage of pages saved in the table
as a result of row compression. This value includes overhead bytes
for each user data row in the table, but does not include the space
that is consumed by dictionary overhead; -1 if statistics are not
collected. |
| LAST_REGEN_TIME |
TIMESTAMP |
|
Time at which any views or check constraints on
the table were last regenerated. |
| SECPOLICYID |
INTEGER |
|
Identifier for the security policy protecting the
table; 0 for non-protected tables. |
| PROTECTIONGRANULARITY |
CHAR(1) |
|
- B = Both column- and row-level granularity
- C = Column-level granularity
- R = Row-level granularity
- Blank = Non-protected table
|
| DEFINER1 |
VARCHAR(128) |
|
Authorization ID under which the table, view,
alias, or nickname was created. |
| REMARKS |
VARCHAR(254) |
Y |
User-provided comments, or null. |
|
Notes:
- The DEFINER column is included for backwards compatibility. See
OWNER.
|
加载中…
喜欢