SAP ABAP Table DB2TBDETL (Detailed Information on a Table from the DB2 Catalog)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	INTTAB	Structure
Structure	DB2TBDETL	Table Relationship Diagram
Short Description	Detailed Information on a Table from the DB2 Catalog

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	NAME	☐	DB2TABNAME	CHAR18	CHAR	18	0	DB2 table name
2	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
3	TYPE	☐	DB2TBTYPE	DB2TBTYPE	CHAR	1	0	Type of object
4	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
5	TSNAME	☐	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
6	COLCOUNT	☐	DB2COLCNT	DB2SINT	INT2	5	0	Number of columns in the table or view
7	NPAGES	☐	DB2NPAGES		INT4	10	0	Number of pages on which rows of the table appear
8	KEYCOLUMNS	☐	DB2KEYCOLS	DB2SINT	INT2	5	0	Number of columns in the table's primary key
9	RECLENGTH	☐	DB2RECLENS	DB2SINT	INT2	5	0	Maximum length (in bytes) of any record in the table
10	STATUS	☐	DB2TBSTATU	DB2TBSTATU	CHAR	1	0	Status of the table
11	CREATEDTS	☐	DB2CREADTS	DB2TMSTMP	CHAR	26	0	Time when the CREATE statement was executed
12	ALTEREDTS	☐	DB2ALTEDTS	DB2TMSTMP	CHAR	26	0	Time of most recent ALTER statement on the object
13	PCTROWCOMP	☐	DB2PCTRCMP	DB2SINT	INT2	5	0	Percentage of rows compressed within the total no. of rows
14	STATSTIME	☐	DB2STATSTM	DB2TMSTMP	CHAR	26	0	Date and time of last RUNSTATS
15	CARDF	☐	DB2CARDF	FLOATING	FLTP	16	16	Total number of rows in the table
16	SIZE	☐	DB2TBSIZE	DEC13	DEC	13	0	Size of the table in KB

History

Last changed by/on	SAP	20130604
SAP Release Created in	700