SYSCAT.NICKNAMES catalog view

Each row represents a nickname.

Table 1. SYSCAT.NICKNAMES Catalog View
Column Name Data Type Nullable Description
TABSCHEMA VARCHAR (128)   Schema name of the nickname.
TABNAME VARCHAR (128)   Unqualified name of the nickname.
OWNER VARCHAR (128)   Authorization ID of the owner of the table, view, alias, or nickname.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
STATUS CHAR (1)   Status of the object.
  • C = Set integrity pending
  • N = Normal
  • X = Inoperative
CREATE_TIME TIMESTAMP   Time at which the object was created.
STATS_TIME TIMESTAMP Y Time at which any change was last made to recorded statistics for this object. The null value 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 in the table; -1 if statistics are not collected.
NPAGES BIGINT   Total number of pages on which the rows of the nickname exist; -1 if statistics are not gathered.
FPAGES BIGINT   Total number of pages; -1 if statistics are not gathered.
OVERFLOW BIGINT   Total number of overflow records; -1 if statistics are not gathered.
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 = Nickname participates in data replication, including replication of LONG VARCHAR and LONG VARGRAPHIC columns
  • N = Nickname does not participate in data replication
  • Y = Nickname participates in data replication
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
PARTITION_MODE CHAR (1)   Reserved for future use.
STATISTICS_PROFILE CLOB (10M) Y RUNSTATS command used to register a statistical profile for the object.
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
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.
REMOTE_TABLE VARCHAR (128) Y Unqualified name of the specific data source object (such as a table or a view) for which the nickname was created.
REMOTE_SCHEMA VARCHAR (128) Y Schema name of the specific data source object (such as a table or a view) for which the nickname was created.
SERVERNAME VARCHAR (128) Y Name of the data source that contains the table or view for which the nickname was created.
REMOTE_TYPE CHAR (1) Y Type of object at the data source.
  • A = Alias
  • N = Nickname
  • S = Materialized query table
  • T = Table (untyped)
  • V = View (untyped)
CACHINGALLOWED VARCHAR (1)  
  • N = Caching is not allowed
  • Y = Caching is allowed
DEFINER1 VARCHAR (128)   Authorization ID of the owner of the table, view, alias, or nickname.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.
Note:
  1. The DEFINER column is included for backwards compatibility. See OWNER.