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
There is no transaction reference to this program  
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