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's 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's 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 is created. |
Invalidate_time |
TIMESTAMP |
|
Time at which the object is last invalidated. |
Stats_time |
TIMESTAMP |
Y |
Time at which any change is last made to recorded statistics for this object. Null If statistics is 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 is 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 is not collected; -2 for a subtable or hierarchy table. |
Fpages |
BIGINT |
|
Total number of pages; -1 for a view or alias, or if statistics is 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 is 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 was specified, all parts of the table was 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 is 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, 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 is omitted or specified with the same value as The IN clause of the CREATE TABLE statement. |
Parents |
SMALLINT |
Y |
Number of the parent tables for this object; That's, the number of referential constraints in which this object is a dependent. |
Children |
SMALLINT |
Y |
Number of dependent tables for this object; That's, 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's, 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 the 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 (+) |
|
- Byte 1 represents fore IGN 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 is reserved for the future use.
Possible values are:
- F = in byte 5, the materialized query table cannot be refreshed Inc Rementally. In byte 7, the content of the staging table is incomplete and cannot are used for incremental refresh of the associated mat erialized query table.
- N = Not checked
- U = Checked by user
- W = is in ' U ' state when the table is placed in set integrity pending state
- Y = Checked by System
|
pmap_id |
SMALLINT |
Y |
Identifier for the distribution map, is currently on use by this table (null for aliases or views). |
Partition_mode |
CHAR (1) |
|
Indicates how data are 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 being reserved for the future inserts. |
Append_mode |
CHAR (1) |
|
Controls how rows is inserted into pages.
- N = New rows is inserted into existing spaces, if available
- Y = New rows is 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 is last refreshed (refresh TABLE statement); Null value otherwise. |
Locksize |
CHAR (1) |
|
Indicates the preferred lock granularity for tables that is 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 this table has no properties. |
Statistics_profile |
CLOB (10M) |
Y |
RUNSTATS command used to register a statistical profiles for the object. |
COMPRESSION |
CHAR (1) |
|
- B = Both value and row compression is activated
- N = No compression is activated; A row format that does not compression is used
- R = Row compression is activated; A row format that supports compression might is 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 is in set integrity pending state or to objects the were processed by a set INTE Grity 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. |
Avgcompressedrowsize |
SMALLINT |
|
Average length (in bytes) of compressed rows in this table; -1 If statistics is not collected. |
Avgrowcompressionratio |
REAL |
|
For compressed rows in the table, this is the average compression ratio by row; That's, the average uncompressed row length divided by the average compressed row length; -1 If statistics is not collected. |
Avgrowsize |
SMALLINT |
|
Average length (in bytes) of both compressed and uncompressed rows in this table; -1 If statistics is not collected. |
Pctrowscompressed |
REAL |
|
Compressed rows as a percentage of the total number of rows in the table; -1 If statistics is not collected. |
Logindexbuild |
VARCHAR (3) |
Y |
Level of logging so is to be performed during create, recreate, or reorganize index operations on the table.
- OFF = Index build operations on the table would be logged minimally
- On = Index build operations on the table would be logged completely
- Null value = value of the logindexbuild database configuration parameter'll be used to determine whether or not index build oper Ations is 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 column S. |
Encoding_scheme |
CHAR (1) |
|
- A = CCSID ASCII was specified
- U = CCSID UNICODE was specified
- Blank = CCSID clause is 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 of the user data row in the table, but does does include the space that's consumed by Dictionary overhead; -1 If statistics is not collected. |
Last_regen_time |
TIMESTAMP |
|
Time at which a 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.
|