SQL - SYSIBM.SYSTABLESPACE - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSTABLESPACE

Contains one row for each table space.

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


© Copyright IBM Corp.