SAP ABAP Table DB2ACCOR (Parameters of Control Center stored procedure DSNACCOR)

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	DB2ACCOR	Table Relationship Diagram
Short Description	Parameters of Control Center stored procedure DSNACCOR

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	QUERYTYPE	☐	DB2CCQUERY	CHAR40	CHAR	40	0	Type of the Stored Procedure to run
2	OBJECTTYPE	☐	DB2CCOTYPE	CHAR3	CHAR	3	0	Types of objects who are considered for recommendation
3	ICTYPE	☐	DB2CCICTYP	CHAR1	CHAR	1	0	Types of image copies to be considered for recommendation
4	STATSSCHEM	☐	DB2CCSCHEM	CHAR128	CHAR	128	0	Schema name to qualify tables (statistics, catalog, created)
5	CATLGSCHEM	☐	DB2CCSCHEM	CHAR128	CHAR	128	0	Schema name to qualify tables (statistics, catalog, created)
6	LOCALSCHEM	☐	DB2CCSCHEM	CHAR128	CHAR	128	0	Schema name to qualify tables (statistics, catalog, created)
7	CHKLVL	☐	DB2CCCHECK		INT4	10	0	Degree of checking before invocation of stored procedure
8	CRITERIA	☐	DB2CCWHERE	CHAR4096	CHAR	4096	0	Where clause for the Control Center stored procedures
9	UNUSED	☐			CHAR	80	0
10	FCUPDPGS	☐	DB2CCUPDPG		INT4	10	0	Full/Inc. Copy: Updated pages in percent of preformatted pag
11	FCCHGPCT	☐	DB2CCCCHGS		INT4	10	0	Full/Inc. Copy: Changed rows in percent
12	FCDAYSCOPY	☐	DB2CCCDAYS		INT4	10	0	Full Copy: Number of days since last COPY
13	ICUPDPGS	☐	DB2CCUPDPG		INT4	10	0	Full/Inc. Copy: Updated pages in percent of preformatted pag
14	ICCHGPCT	☐	DB2CCCCHGS		INT4	10	0	Full/Inc. Copy: Changed rows in percent
15	FCINDEXSIZ	☐	DB2CCISIZE		INT4	10	0	Full Copy: Minimum size of index in pages (NACTIVE)
16	RTINSDELUP	☐	DB2CCRCHGS		INT4	10	0	REORG TS/IX: Changed rows in percent
17	RTUNCLUST	☐	DB2CCUNCLU		INT4	10	0	REORG TS: Unclustered inserts in percent
18	RTLOBPCT	☐	DB2CCLOB		INT4	10	0	REORG TS: Disorganized LOBs in percent
19	RTMASSDEL	☐	DB2CCRMASS		INT4	10	0	REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
20	RTINDREF	☐	DB2CCIND		INT4	10	0	REORG TS: Indirect references (overflow records) in percent
21	RIINSDEL	☐	DB2CCRCHGS		INT4	10	0	REORG TS/IX: Changed rows in percent
22	RIAPPINS	☐	DB2CCAPP		INT4	10	0	REORG Index: Appended rows (with greater key) in percent
23	RIPSEUDODE	☐	DB2CCPSEUD		INT4	10	0	REORG Index: Pseudo deletes in percent
24	RIMASSDEL	☐	DB2CCRMASS		INT4	10	0	REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
25	RILEAFLIM	☐	DB2CCLEAF		INT4	10	0	REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent
26	RINUMLEVEL	☐	DB2CCLEVEL		INT4	10	0	REORG Index: Change to number of index tree levels absolute
27	STINSDELP	☐	DB2CCSCHGS		INT4	10	0	RUNSTATS TS/IX: Changed rows in percent
28	STINSDELA	☐	DB2CCCHGA	FLTP	FLTP	16	16	RUN.:Changed rows (insert, delete or update) absolute number
29	STMASSDEL	☐	DB2CCSMASS		INT4	10	0	RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
30	SIINSDELP	☐	DB2CCSCHGS		INT4	10	0	RUNSTATS TS/IX: Changed rows in percent
31	SIINSDELA	☐	DB2CCCHGA	FLTP	FLTP	16	16	RUN.:Changed rows (insert, delete or update) absolute number
32	SIMASSDEL	☐	DB2CCSMASS		INT4	10	0	RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
33	EXTENTS	☐	DB2CCEXT		INT4	10	0	Number of allowable dataset extents
34	L_STATEMNT	☐	DB2CCLST		CHAR	8012	0	Last statement executed by DSNACCAV stored procedures
35	RETURNCODE	☐	DB2CCRETURN		INT4	10	0	Return code of stored procedure
36	ERRORMSG	☐	DB2CCMTXT		CHAR	1331	0	Area of the CC stored procedures output values
37	IFCRETCODE	☐	DB2CCIRET		INT4	10	0	Return code for the IFI call
38	IFCRESCODE	☐	DB2CCIRES		INT4	10	0	Reason code for the IFI call
39	XSBYTES	☐	DB2CCXSB		INT4	10	0	Number of bytes that did not fit in the IFI return area
40	RTINSDELUPABS	☐	DB2CCRCHGA		INT4	10	0	REO.:Changed rows (insert, delete or update) absolute number
41	RTACTIVEPAGES	☐	DB2CCRROWS		INT4	10	0	REORG TS/IX: Number of active pages

History

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