SAP ABAP Table DB2CCOUTTS (Output List of Tablespace of CC/390 Stored Procedures)

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	DB2CCOUTTS	Table Relationship Diagram
Short Description	Output List of Tablespace of CC/390 Stored Procedures

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	☐	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
2	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
3	BPOOL	☐	DB2BPNAME	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
4	LOCKRULE	☐	DB2LRULE	DB2LRULE	CHAR	1	0	Lock size of the tablespace
5	LOCKMAX	☐	DB2LMAX	DB2LMAX	INT4	10	0	Maximum number of locks per user before escalating
6	CLOSERULE	☐	DB2CRULE	DB2CRULE	CHAR	1	0	Data sets for closure when limit of open data sets reached
7	ENCODING	☐	DB2ENCODE	DB2ENCODE	CHAR	1	0	Default encoding scheme of the tablespace
8	LOCKPART	☐	DB2LPART	DB2LPART	CHAR	1	0	Lockpart for the tablespace
9	MAXROWS	☐	DB2MROW	DB2MROW	INT2	5	0	Maximum number of rows that DB2 will place on a data page
10	PARTITIONS	☐	DB2PART	DB2PART	INT2	5	0	Number of partitions of the tablespace or indexspace
11	TYPE	☐	DB2TYPE	DB2TYPE	CHAR	1	0	Tablespace type
12	SEGSIZE	☐	DB2SSIZE	DB2SSIZE	INT2	5	0	Number of pages in each segment of a segmented tablespace
13	SPACE	☐	DB2SPACE	DB2SPACE	INT4	10	0	Number of KB of DASD Storage Allocated to Tablespace
14	NTABLES	☐	DB2NTAB	DB2NTAB	INT2	5	0	Number of tables defined in the tablespace
15	STATUS	☐	DB2STATS	DB2STATS	CHAR	1	0	Availability status of tablespace
16	STATSTIME	☐	DB2STATSTM	DB2TMSTMP	CHAR	26	0	Date and time of last RUNSTATS
17	ERASERULE	☐	DB2ERULE	DB2ERULE	CHAR	1	0	Datasets are to be erased when dropped
18	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
19	DSETPASS	☐	DB2DPASS	DB2DPASS	CHAR	8	0	The password for the datasets of the tablespace
20	LOG	☐	DB2LOG	DB2LOG	CHAR	1	0	Whether the changes to a tablespace are to be logged
21	DSSIZE	☐	DB2DSIZE	DB2DSIZE	INT4	10	0	Maximum size of a dataset in KBytes
22	PARTNR	☐	DB2PARTNRS	DB2SINT	INT2	5	0	Partition number
23	OPERATION	☐	DB2STATSTM	DB2TMSTMP	CHAR	26	0	Date and time of last RUNSTATS
24	NDAYS	☐	DB2DAYS	DB2DAYS	INT4	10	0	Number of days since last invocation
25	PERCOFFPOS	☐	DB2OFFPOS	DB2OFFPOS	INT2	5	0	Different of far and near optimal position in page
26	PERCINDREF	☐	DB2INDREF	DB2INDREF	INT2	5	0	Different of far and near relocated position in page
27	PERCDROP	☐	DB2CDROP	DB2CDROP	INT2	5	0	Percentage of space occupied by rows of dropped tables
28	EXTENTS	☐	DB2EXTENT	DB2EXTENT	INT4	10	0	Number of extents of a tablespace
29	REASON	☐	DB2REASON	DB2REASON	CHAR	18	0	Reason running utility is recommended

History

Last changed by/on	SAP	20070813
SAP Release Created in	710