Table/Structure Field list used by SAP ABAP Function Module CCDSNU_CALL_DSNACCOR (Calls DSNACCOR (DB2 V7 Stored Procedure), all parameters may be changed)
SAP ABAP Function Module 
CCDSNU_CALL_DSNACCOR (Calls DSNACCOR (DB2 V7 Stored Procedure), all parameters may be changed) is using
-
Class (4)
-
Data Element (5)
-
Table/Structure Field (89)
-
Function Module (9)
-
Class Method (2)
-
Table (13)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
DB2ACCOR - SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | |
| 2 | Table/Structure Field |
DB2ACCOR - RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | |
| 3 | Table/Structure Field |
DB2ACCOR - RINUMLEVEL | REORG Index: Change to number of index tree levels absolute | |
| 4 | Table/Structure Field |
DB2ACCOR - RIPSEUDODE | REORG Index: Pseudo deletes in percent | |
| 5 | Table/Structure Field |
DB2ACCOR - RTACTIVEPAGES | REORG TS/IX: Number of active pages | |
| 6 | Table/Structure Field |
DB2ACCOR - RTINDREF | REORG TS: Indirect references (overflow records) in percent | |
| 7 | Table/Structure Field |
DB2ACCOR - RTINSDELUP | REORG TS/IX: Changed rows in percent | |
| 8 | Table/Structure Field |
DB2ACCOR - RTINSDELUPABS | REO.:Changed rows (insert, delete or update) absolute number | |
| 9 | Table/Structure Field |
DB2ACCOR - RTLOBPCT | REORG TS: Disorganized LOBs in percent | |
| 10 | Table/Structure Field |
DB2ACCOR - RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | |
| 11 | Table/Structure Field |
DB2ACCOR - RTUNCLUST | REORG TS: Unclustered inserts in percent | |
| 12 | Table/Structure Field |
DB2ACCOR - CHKLVL | Degree of checking before invocation of stored procedure | |
| 13 | Table/Structure Field |
DB2ACCOR - SIINSDELP | RUNSTATS TS/IX: Changed rows in percent | |
| 14 | Table/Structure Field |
DB2ACCOR - SIMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | |
| 15 | Table/Structure Field |
DB2ACCOR - STATSSCHEM | Schema name to qualify tables (statistics, catalog, created) | |
| 16 | Table/Structure Field |
DB2ACCOR - STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | |
| 17 | Table/Structure Field |
DB2ACCOR - STINSDELP | RUNSTATS TS/IX: Changed rows in percent | |
| 18 | Table/Structure Field |
DB2ACCOR - STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | |
| 19 | Table/Structure Field |
DB2ACCOR - UNUSED | DB2ACCOR-UNUSED | |
| 20 | Table/Structure Field |
DB2ACCOR - XSBYTES | Number of bytes that did not fit in the IFI return area | |
| 21 | Table/Structure Field |
DB2ACCOR - CATLGSCHEM | Schema name to qualify tables (statistics, catalog, created) | |
| 22 | Table/Structure Field |
DB2ACCOR - RIINSDEL | REORG TS/IX: Changed rows in percent | |
| 23 | Table/Structure Field |
DB2ACCOR - CRITERIA | Where clause for the Control Center stored procedures | |
| 24 | Table/Structure Field |
DB2ACCOR - ERRORMSG | Area of the CC stored procedures output values | |
| 25 | Table/Structure Field |
DB2ACCOR - EXTENTS | Number of allowable dataset extents | |
| 26 | Table/Structure Field |
DB2ACCOR - FCCHGPCT | Full/Inc. Copy: Changed rows in percent | |
| 27 | Table/Structure Field |
DB2ACCOR - FCDAYSCOPY | Full Copy: Number of days since last COPY | |
| 28 | Table/Structure Field |
DB2ACCOR - FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) | |
| 29 | Table/Structure Field |
DB2ACCOR - FCUPDPGS | Full/Inc. Copy: Updated pages in percent of preformatted pag | |
| 30 | Table/Structure Field |
DB2ACCOR - ICCHGPCT | Full/Inc. Copy: Changed rows in percent | |
| 31 | Table/Structure Field |
DB2ACCOR - ICTYPE | Types of image copies to be considered for recommendation | |
| 32 | Table/Structure Field |
DB2ACCOR - IFCRESCODE | Reason code for the IFI call | |
| 33 | Table/Structure Field |
DB2ACCOR - RILEAFLIM | REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent | |
| 34 | Table/Structure Field |
DB2ACCOR - RIAPPINS | REORG Index: Appended rows (with greater key) in percent | |
| 35 | Table/Structure Field |
DB2ACCOR - RETURNCODE | Return code of stored procedure | |
| 36 | Table/Structure Field |
DB2ACCOR - QUERYTYPE | Type of the Stored Procedure to run | |
| 37 | Table/Structure Field |
DB2ACCOR - OBJECTTYPE | Types of objects who are considered for recommendation | |
| 38 | Table/Structure Field |
DB2ACCOR - L_STATEMNT | Last statement executed by DSNACCAV stored procedures | |
| 39 | Table/Structure Field |
DB2ACCOR - LOCALSCHEM | Schema name to qualify tables (statistics, catalog, created) | |
| 40 | Table/Structure Field |
DB2ACCOR - IFCRETCODE | Return code for the IFI call | |
| 41 | Table/Structure Field |
DB2ACCOR - ICUPDPGS | Full/Inc. Copy: Updated pages in percent of preformatted pag | |
| 42 | Table/Structure Field |
DB2CCDAILY - TSPART | Partition number | |
| 43 | Table/Structure Field |
DB2CCDAILY - TSNAM | Name of the tablespace | |
| 44 | Table/Structure Field |
DB2CCDAILY - TIME_ANA | Time of the last check | |
| 45 | Table/Structure Field |
DB2CCDAILY - DBNAM | Database name | |
| 46 | Table/Structure Field |
DB2CCDAILY - RUNSTREC | RUNSTATS Recommendation: YES or NO | |
| 47 | Table/Structure Field |
DB2CCDAILY - RTINSDELUPABS | REO.:Changed rows (insert, delete or update) absolute number | |
| 48 | Table/Structure Field |
DB2CCDAILY - RTACTIVEPAGES | REORG TS/IX: Number of active pages | |
| 49 | Table/Structure Field |
DB2CCDAILY - REORGREC | REORG Recommendation: YES or NO | |
| 50 | Table/Structure Field |
DB2CCDAILY - IXNAME | Name of a DB2 for OS/390 index | |
| 51 | Table/Structure Field |
DB2CCDAILY - EXTENTS | Extentlimit was exceeded: YES or NO | |
| 52 | Table/Structure Field |
DB2CCDAILY - EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | |
| 53 | Table/Structure Field |
DB2CCDAILY - DATE_ANA | Date of the last check | |
| 54 | Table/Structure Field |
DB2CCDAILY - CREATOR | DB2 creator name | |
| 55 | Table/Structure Field |
DB2CCDAILY - COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | |
| 56 | Table/Structure Field |
DB2CCDAILY - OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | |
| 57 | Table/Structure Field |
DB2CCHOUR - OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | |
| 58 | Table/Structure Field |
DB2CCHOUR - TSPART | Partition number | |
| 59 | Table/Structure Field |
DB2CCHOUR - TSNAM | Name of the tablespace | |
| 60 | Table/Structure Field |
DB2CCHOUR - TIME_ANA | Time of the last check | |
| 61 | Table/Structure Field |
DB2CCHOUR - RUNSTREC | RUNSTATS Recommendation: YES or NO | |
| 62 | Table/Structure Field |
DB2CCHOUR - REORGREC | REORG Recommendation: YES or NO | |
| 63 | Table/Structure Field |
DB2CCHOUR - EXTENTS | Extentlimit was exceeded: YES or NO | |
| 64 | Table/Structure Field |
DB2CCHOUR - DBNAM | Database name | |
| 65 | Table/Structure Field |
DB2CCHOUR - DATE_ANA | Date of the last check | |
| 66 | Table/Structure Field |
DB2CCHOUR - CREATOR | DB2 creator name | |
| 67 | Table/Structure Field |
DB2CCHOUR - COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | |
| 68 | Table/Structure Field |
DB2CCOUT - EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | |
| 69 | Table/Structure Field |
DB2CCOUT - TSNAME | Name of the tablespace | |
| 70 | Table/Structure Field |
DB2CCOUT - RUNSTREC | RUNSTATS Recommendation: YES or NO | |
| 71 | Table/Structure Field |
DB2CCOUT - RTUNCLUST | REORG TS: Unclustered inserts in percent | |
| 72 | Table/Structure Field |
DB2CCOUT - RTINDREF | REORG TS: Indirect references (overflow records) in percent | |
| 73 | Table/Structure Field |
DB2CCOUT - REORGTIME | Timestamp of last REORG | |
| 74 | Table/Structure Field |
DB2CCOUT - REORGREC | REORG Recommendation: YES or NO | |
| 75 | Table/Structure Field |
DB2CCOUT - PARTI | Data set number or partition number | |
| 76 | Table/Structure Field |
DB2CCOUT - OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | |
| 77 | Table/Structure Field |
DB2CCOUT - OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | |
| 78 | Table/Structure Field |
DB2CCOUT - EXTENT_NO | Number of physical extents in TS, IS or partition | |
| 79 | Table/Structure Field |
DB2CCOUT - EXTENTS | Extentlimit was exceeded: YES or NO | |
| 80 | Table/Structure Field |
DB2CCOUT - DBNAME | Database name | |
| 81 | Table/Structure Field |
DB2CCOUT - COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | |
| 82 | Table/Structure Field |
DB2MISC - SUBKEY | DB2MISC-SUBKEY | |
| 83 | Table/Structure Field |
DB2MISC - THEKEY | DB2MISC-THEKEY | |
| 84 | Table/Structure Field |
DB2MISC - THEVALUE | DB2MISC-THEVALUE | |
| 85 | Table/Structure Field |
DB2TDUMMY - DB2REL | DB2 release | |
| 86 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 87 | Table/Structure Field |
STU3COTABS - COMMTEXT1 | Text of logical command for DB2/390 or OS/390 | |
| 88 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 89 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server |
