SAP ABAP Program SAPLS_CCDSNU_DB2 (SAPLS_CCDSNU_DB2)
Basic Data
| Program | SAPLS_CCDSNU_DB2 | |
| Program Type | F | Function group |
Attributes
| Status | ||
| Application | S | Basis |
| Authorization Group | ||
| Logical database | D$S | Processing without database |
| Selection screen | ||
| Editor lock | Fixed point arithmetic | |
| Unicode checks active | Start using variant |
Function Group
| Include | Function Module | Short Description | Mode |
|---|---|---|---|
| 01 |  CCDSNU_CALL_DSNACCOR |
Calls DSNACCOR (DB2 V7 Stored Procedure), all parameters may be changed | |
| 02 | DSNU_RUNSTATS_TABLESPACE_DB2 |
||
| 03 | DSNU_REBUILD_INDEX_DB2 |
||
| 04 | CCDSNU_DSNACCOR_RUNSTATS |
Call StoProc DSNACCOR for RUNSTATS info | |
| 05 | CCDSNU_GET_STOGROUP |
Returns the STOGROUP for CCMS database tables | |
| 06 | CCDSNU_CHECK_EXCEPT_TABLE_DB2 |
Fills DSNACCOR exception table, if needed | |
| 07 | CCDSNU_DSNACCOR_REORG |
Call StoProc DSNACCOR for REORG info | |
| 08 | CCDSNU_DSNACCOR_BACKUP |
Call StoProc DSNACCOR for image COPY info | |
| 09 | CCDSNU_DSNACCOR_RESTRICT |
Call StoProc DSNACCOR for restricted states info | |
| 10 | CCDSNU_CHECK_TEMP_DATABASE_DB2 |
creates DB2 database for declared temporary tables, if needed | |
| 11 | CCDSNU_GET_TEMPL_PROTECT_CHG |
Get Version No of UtilityTemplates and set status flags | |
| 12 | CCDSNU_CHECK_UTILITY_TEMPLATES |
check template utilities | |
| 13 | CCDSNU_GET_EXCEPTIONS |
Creates DSNACCOR exception table, if needed | |
| 14 | CCDSNU_CALL_DSNACCMO |
Calls DSNACCMO (DB2 V7 Stored Procedure) for utility schedule | |
| 15 | CCDSNU_CHECK_MO_INPUT_TABLE |
Fills DSNACCMO input tables | |
| 16 | CCDSNU_CHECK_MAPPINGTABLE_DB2 |
Creates mapping tables for REORG, if needed | |
| 17 | CCDSNU_CALL_DSNACCSS |
Calls DSNACCSS to retrieve the DB2 subsystem name | R |
| 18 | CCDSNU_CALL_DSNACCSI |
Calls DSNACCSI to retrieve the DB2 system's host name | R |
| 19 | CCDSNU_DROP_MULTICONNECTION |
Removes connection in DBCON for multiconnect if necessary | |
| 20 | CCDSNU_DISPLAY_DSNACCMO |
DSNACCMO: Display result sets in DB13 | |
| 21 | CCDSNU_CALL_DSNACCDL |
Calls Stored Procedure DSNACCDL as LISTCAT replacement | |
| 22 | CCDSNU_CALL_DSNACCOX |
Calls DB2 stored procedure DSNACCOX | |
| 23 | CCDSNU_CHECK_MULTICONNECTION |
Creates connection in DBCON for multiconnect if necessary | |
| 24 | CCDSNU_CALL_DSNUTILS |
Calls DSNUTILS (DB2 Stored Procedure) for single utility execution | |
| 25 | CCDSNU_DISPLAY_DSNUTILS |
DSNUTILS: Display result sets in DB13 | R |
| 26 | CCDSNU_DSNACCOR_OR_DSNACCOX |
Returns, which DB2 stored procedure has to be used | |
| 27 | CCDSNU_JCL_GET_RESULT |
Asynch. JCL Job submission: Get Job results | |
| 28 | CCDSNU_JCL_GET_STATUS |
Asynch. JCL Job submission: Check Job status | |
| 29 | CCDSNU_JCL_SUBMIT_ASYNCH |
Asynch. JCL Job submission: Job submission | |
| 30 | CCDSNU_JCL_SUBMIT_SYNCH |
Synch. JCL Job submission | |
| 31 | CCDSNU_SET_TEMPL_PROTECT_CHG |
Set Version No of Utility Templates from given status flags | |
| 32 | CCDSNU_UPLOAD_JOB |
Upload via Stored Procedure DSNACCDS as FTP replacement | |
| 33 | CCDSNU_CHK_TEMPL_PROTECT_CHG |
Confirm switch to "protect" necessary? | |
| 34 | CCDSNU_CALL_DSNACCMN |
Calls DSNACCMN to submit a DB2 command | |
| 35 | CCDSNU_CALL_WLM_REFRESH |
Calls the DB2 stored procedure WLM_REFRESH | |
| 36 | CCDSNU_VERIFY_TSOUSER |
DB2-z/OS: Verify the (default) TSO-User | |
| 37 | CCDSNU_DISCONN_MULTICONNECTION |
Disconnect & delete connection from DBCON created by CHECK_MULTICONNECTION | |
| 38 | CCDSNU_GET_RUNSTATS_ALERTS |
get RUNSTATS recommendations | |
| 39 | CCDSNU_GET_REORGTS_ALERTS |
get REORGTS recommendations | |
| 40 | CCDSNU_GET_REORGIX_ALERTS |
get REORGIX recommendations | |
| 41 | CCDSNU_GET_RESTRICTED_ALERTS |
get RESTRICTED recommendations | |
Transaction Code
Screens
| # | Screen | Short Description |
|---|---|---|
| 1 | 0200 | CCDSNU_DISPLAY_ALERTS: Show alerts |
| 2 | 0300 | Screen for list display of DSNACCMO results |
| 3 | 0310 | DSNACCMO: Overview of in- and output parameters |
| 4 | 0311 | DSNACCMO: Overview of in- and output parameters |
| 5 | 0320 | DSNUTILS: Overview of in- and output parameters |
| 6 | 0321 | DSNUTILS: Overview of in- and output parameters |
GUI Status
| # | GUI Status | Short Description |
|---|---|---|
| 1 | 0200 | In- and Output of DSNACCMO |
GUI Title
| # | GUI Title | Short Description |
|---|---|---|
| 1 | DAY_ | Result set of collecting method RSDBA_COLLECT_DAILY |
| 2 | HOUR | Result set of collecting method RSDBA_COLLECT_HOURLY |
| 3 | IN1_ | DSNACCMO input table1 containing the objects for utility run |
| 4 | IN2_ | DSNACCMO input table 2 containing the utility statements |
| 5 | OUT_ | DSNACCMO output table containing the utility output |
| 6 | PARM | DSNACCMO input and output parameters |
| 7 | REOI | Indexes requiring REORG |
| 8 | REOT | Tablespaces requiring REORG |
| 9 | RSTR | Tablespaces/Indexspaces in restricted state |
| 10 | STAT | RUNSTATS recommendations |
| 11 | UOUT | DSNUTILS output table containing the utility output |
| 12 | UPAR | DSNUTILS input and output parameters |
History
| Last changed by/on | SAP | 20000128 |
| SAP Release Created in |
