IBM Books

Administration Guide


OBJCAT.TABLES

Contains one row for each table, view, or alias that is created. All of the catalog tables and views have entries in the OBJCAT.TABLES catalog view.

Table 115. OBJCAT.TABLES Catalog View
Column Name Data Type Nullable Description
TABSCHEMA CHAR(8)
Qualified name of the table, view, or alias.
TABNAME VARCHAR(18)
DEFINER CHAR(8)
User who created the table, view, or alias.
TYPE CHAR(1)
The type of object:
  A=Alias
  S=Summary table
  T=Table
  V=View
STATUS CHAR(1)
The type of object:
  N=Normal table, view or alias
  C=Check pending on table
  X=Inoperative view
BASE_TABSCHEMA CHAR(8) Yes If TYPE=A, these columns identify the table, view, or alias that is referenced by this alias; otherwise they are null.
BASE_TABNAME VARCHAR(18) Yes
ROWTYPESCHEMA CHAR(8) Yes These columns identify the structured type used to define the table. Values are null if the table is not defined using a structured type.
ROWTYPENAME VARCHAR(18) Yes
CREATE_TIME TIMESTAMP
The timestamp indicating when the object was created.
STATS_TIME TIMESTAMP Yes Last time when any change was made to recorded statistics for this table. Null if no statistics available.
COLCOUNT SMALLINT
Number of columns in table.
TABLEID SMALLINT
Internal table identifier.
TBSPACEID SMALLINT
Internal identifier of primary table space for this table.
CARD INTEGER
Total number of rows in the table; -1 if statistics are not gathered or the row describes a view or alias.
NPAGES INTEGER
Total number of pages on which the rows of the table exist; -1 if statistics are not gathered or the row describes a view or alias; -2 for a subtable.
FPAGES INTEGER
Total number of pages; -1 if statistics are not gathered or the row describes a view or alias; -2 for a subtable.
OVERFLOW INTEGER
Total number of overflow records in the table; -1 if statistics are not gathered or the row describes a view or alias; -2 for a subtable.
TBSPACE VARCHAR(18) Yes Name of 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 and views.
INDEX_TBSPACE VARCHAR(18) Yes Name of table space that holds all indexes created on this table. Null for aliases and views, 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(18) Yes Name of table space that holds all long data (LONG or LOB column types) for this table. Null for aliases and views, 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 Yes Number of parent tables of this table (the number of referential constraints in which this table is a dependent).
CHILDREN SMALLINT Yes Number of dependent tables of this table (the number of referential constraints in which this table is a parent).
SELFREFS SMALLINT Yes Number of self-referencing referential constraints for this table (the number of referential constraints in which this table is both a parent and a dependent).
KEYCOLUMNS SMALLINT Yes Number of columns in the primary key of the table.
KEYINDEXID SMALLINT Yes Index ID of the primary index. This field is null or 0 if there is no primary key.
KEYUNIQUE SMALLINT
Number of unique constraints (other than primary key) defined on this table.
CHECKCOUNT SMALLINT
Number of check constraints defined on this table.
DATACAPTURE CHAR(1)
  Y=Table participates in data
         replication
  N=Does not participate

CONST_CHECKED CHAR(32)
Byte 1 represents foreign key constraints. Byte 2 represents check constraints. Byte 3 represents constraint Datalink_Reconcile_Pending. Byte 4 represents constraint Datalink_Reconcile_Not_Possible. Byte 5 represents summary table. Other bytes are reserved. Encodes constraint information on checking. Values:
  Y=Checked by system
  U=Checked by user
  N=Not checked (pending)
PMAP_ID SMALLINT Yes Identifier of the partitioning map used by this table. Null for aliases and views.
PARTITION_MODE CHAR(1)
Mode used for tables in a partitioned database.

H
hash on the partitioning key

R
table replicated across database partitions

Blank for aliases, views and tables in single partition nodegroups with no partitioning key defined.

LOG_ATTRIBUTE CHAR(1)
  0=Default logging
  1=Table created not
         logged initially

PCTFREE SMALLINT
Percentage of each page to be reserved for future inserts. Can be changed by ALTER TABLE.
REMARKS VARCHAR(254) Yes User-provided comment.


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

[ DB2 List of Books | Search the DB2 Books ]