SAP ABAP Class CL_DB2_MAINT_EXCEPT (DB2 z/OS Exceptions for Maintenance Jobs)
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
Properties
Class CL_DB2_MAINT_EXCEPT  
Short Description DB2 z/OS Exceptions for Maintenance Jobs    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package STU2   CCMS for DB2 for OS/390 
Created 20110510   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
Class CL_DB2_MAINT_EXCEPT has no forward declaration.
Interfaces
Class CL_DB2_MAINT_EXCEPT has no interface implemented.
Friends
Class CL_DB2_MAINT_EXCEPT has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 C_CONV_EX Constant Public Type reference (TYPE) DB2CHAR04 'CONV' Constant for DB2 Conversions 20110526
2 C_COPY_EX Constant Public Type reference (TYPE) DB2CHAR04 'COPY' Constant for Copy Utility 20110526
3 C_REORGRUNSTATS_EX Constant Public Type reference (TYPE) DB2CHAR04 'YES ' Constant for Core Utilities 20110526
4 C_REORG_EX Constant Public Type reference (TYPE) DB2CHAR04 'REOR' Constant for REORG Utility 20110526
5 C_RUNSTATS_EX Constant Public Type reference (TYPE) DB2CHAR04 'RUNS' Constant for Runstats Utility 20110526
6 EXCEPTION_TABLE Static Attribute Public Type reference (TYPE) DB2_T_CCEXCPT Table with structure like DSNACC.EXCEPT_TBL 20110527
Methods
# Method Level Visibility Method type Description Created on
1 CREATE_EXCEPTION_TABLE Static method Private Method create DB2 exception table EXCEPT_TBL 20111117
2 GET_CONV_EXCEPTIONS Static method Public Method fetches conversion details for conversions (lob/char) 20110510
3 GET_COPY_EXCEPTIONS Static method Public Method fetches conversion details for copy utility 20110510
4 GET_OBJECT_EXCEPTIONS Static method Public Method fetches conversion details per object from DB2 table 20110510
5 GET_REO_EXCEPTIONS Static method Private Method fetches conversion details for reorg 20111110
6 GET_REO_IDX_EXCEPTIONS Static method Public Method fetches conversion details for reorg of indexes 20110510
7 GET_REO_TSP_EXCEPTIONS Static method Public Method fetches conversion details for reorg of tablespaces 20110707
8 GET_RST_IDX_EXCEPTIONS Static method Public Method fetches conversion details for runstats for indexes 20110510
9 GET_RST_TSP_EXCEPTIONS Static method Public Method fetches conversion details for runstats for tablespace 20110707
10 READ_DB_EXCEPT_IXSP Static method Private Method finds string within querytype field per indexspace 20111117
11 READ_DB_EXCEPT_TSP Static method Private Method finds string within querytype field per tablespace 20111117
12 SET_OBJECT_EXCEPTIONS Static method Public Method saves exceptions per object to DB2 table 20110510
Events
Class CL_DB2_MAINT_EXCEPT has no event.
Types
Class CL_DB2_MAINT_EXCEPT has no local type.
Method Signatures

Method CREATE_EXCEPTION_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20111117
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20111117

Method GET_CONV_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EXCEPT_OBJECTS Call by reference Type reference (TYPE) DB2_T_TSIX 20111110
2 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110511
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20110517

Method GET_COPY_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EXCEPT_OBJECTS Call by reference Type reference (TYPE) DB2_T_TSIX Database and Tablespace Info 20111110
2 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110511
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20110517

Method GET_OBJECT_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) DB2DBNAME Database name 20110526
2 Exporting OBJEXCEPTIONS Call by reference Type reference (TYPE) DB2_OBJ_EXCEPTIONS DB2 z/OS Objects to be excluded for maintenance jobs 20110511
3 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110511
4 Importing SPACENAME Call by reference Type reference (TYPE) DB2TSIXNM Tablespace/indexspace name 20110526
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20110513

Method GET_REO_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DB_EXCEPT Call by reference Type reference (TYPE) DB2_T_CCEXCPT table to represent DSNACC.EXCEPT_TBL content 20111110
2 Returning EXCEPT_OBJECTS Value transfer Type reference (TYPE) DB2_T_REORG_EXCEPTION Table type to DB2_REORG_EXCEPTION, list of partitions 20111110

Method GET_REO_EXCEPTIONS on class CL_DB2_MAINT_EXCEPT has no exception.

Method GET_REO_IDX_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EXCEPT_OBJECTS Call by reference Type reference (TYPE) DB2_T_REORG_EXCEPTION Table type to DB2_REORG_EXCEPTION, list of partitions 20111110
2 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110511
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20110707

Method GET_REO_TSP_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EXCEPT_OBJECTS Call by reference Type reference (TYPE) DB2_T_REORG_EXCEPTION Table type to DB2_REORG_EXCEPTION, list of partitions 20111110
2 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110707
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20110825

Method GET_RST_IDX_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EXCEPT_OBJECTS Call by reference Type reference (TYPE) DB2_T_TSIX Tabletype to DB2_TSP, TSNAME and DBNAME 20111110
2 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110511
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20110517

Method GET_RST_TSP_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EXCEPT_OBJECTS Call by reference Type reference (TYPE) DB2_T_TSIX Tabletype to DB2_TSP, TSNAME and DBNAME 20111110
2 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110707
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20110707

Method READ_DB_EXCEPT_IXSP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20111117
2 Returning RESULT_IXSP_TAB Value transfer Type reference (TYPE) DB2_T_CCEXCPT table to represent DSNACC.EXCEPT_TBL content 20111117
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20111117

Method READ_DB_EXCEPT_TSP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20111117
2 Returning RESULT_TSP_TAB Value transfer Type reference (TYPE) DB2_T_CCEXCPT contains data from DSNACC.EXCEPT_TBL 20111117
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20111117

Method SET_OBJECT_EXCEPTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) DB2DBNAME Database name 20110526
2 Importing OBJEXCEPTIONS Value transfer Type reference (TYPE) DB2_OBJ_EXCEPTIONS DB2 z/OS Objects to be excluded for maintenance jobs 20110511
3 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110511
4 Importing SPACENAME Call by reference Type reference (TYPE) DB2TSIXNM Tablespace/indexspace name 20110526
# Exception Resumable Description Created on
1 CX_DB2_ROOT DB2: root class regarding exceptions 20120110
2 CX_SQL_EXCEPTION Exception Class for SQL Error 20110517
History
Last changed by/on SAP  20130531 
SAP Release Created in 732