SAP ABAP Class CL_DB6_ADMIN_CMD (DB6: Inteface to ADMIN_CMD)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)
Properties
Class CL_DB6_ADMIN_CMD  
Short Description DB6: Inteface to ADMIN_CMD    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package STU6   DB6: Performance-Monitor (UNIX/Windows) 
Created 20051212   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ABAP Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
2 DB6CC Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
3 DB6SY Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_DB6_ADMIN_CMD has no interface implemented.
Friends
Class CL_DB6_ADMIN_CMD has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 ACCESS_NO Constant Public Type reference (TYPE) I 0 20051212
2 ACCESS_READ Constant Public Type reference (TYPE) I 1 20051212
3 ACCESS_WRITE Constant Public Type reference (TYPE) I 2 20051212
4 BACKUP_TARGET_DEVICE Constant Public Type reference (TYPE) I 1 20051221
5 BACKUP_TARGET_SNAPSHOT Constant Public Type reference (TYPE) I 5 20080206
6 BACKUP_TARGET_TSM Constant Public Type reference (TYPE) I 2 20051221
7 BACKUP_TARGET_VENDORLIB Constant Public Type reference (TYPE) I 3 20051221
8 BACKUP_TARGET_XBSA Constant Public Type reference (TYPE) I 4 20051221
9 BACKUP_TYPE_FULL Constant Public Type reference (TYPE) I 1 20051221
10 BACKUP_TYPE_INCREMENTAL Constant Public Type reference (TYPE) I 2 20051221
11 BACKUP_TYPE_INCREMENTAL_DELTA Constant Public Type reference (TYPE) I 3 20051221
12 DB2RUNSTATS_ALLOW_READ Constant Public Type reference (TYPE) DB6CC_HEX4 '00000200' 20051216
13 DB2RUNSTATS_ALL_COLUMNS Constant Public Type reference (TYPE) DB6CC_HEX4 '00000001' 20051216
14 DB2RUNSTATS_ALL_DBPARTITIONS Constant Public Type reference (TYPE) DB6CC_HEX4 '00000400' 20051216
15 DB2RUNSTATS_ALL_INDEXES Constant Public Type reference (TYPE) DB6CC_HEX4 '00000004' 20051216
16 DB2RUNSTATS_DISTRIBUTION Constant Public Type reference (TYPE) DB6CC_HEX4 '00000008' 20051216
17 DB2RUNSTATS_EXT_INDEX Constant Public Type reference (TYPE) DB6CC_HEX4 '00000010' 20051216
18 DB2RUNSTATS_EXT_INDEX_SAMPLED Constant Public Type reference (TYPE) DB6CC_HEX4 '00000020' 20051216
19 DB2RUNSTATS_INDEX_SYSTEM Constant Public Type reference (TYPE) DB6CC_HEX4 '00008000' 20120615
20 DB2RUNSTATS_KEY_COLUMNS Constant Public Type reference (TYPE) DB6CC_HEX4 '00000002' 20051216
21 DB2RUNSTATS_SAMPLING_REPEAT Constant Public Type reference (TYPE) DB6CC_HEX4 '00004000' 20051216
22 DB2RUNSTATS_SAMPLING_SYSTEM Constant Public Type reference (TYPE) DB6CC_HEX4 '00002000' 20051216
23 DB2RUNSTATS_SET_PROFILE Constant Public Type reference (TYPE) DB6CC_HEX4 '00000080' 20051216
24 DB2RUNSTATS_SET_PROFILE_ONLY Constant Public Type reference (TYPE) DB6CC_HEX4 '00000100' 20051216
25 DB2RUNSTATS_UPDATE_PROFILE Constant Public Type reference (TYPE) DB6CC_HEX4 '00000800' 20051216
26 DB2RUNSTATS_UPDA_PROFILE_ONLY Constant Public Type reference (TYPE) DB6CC_HEX4 '00001000' 20051216
27 DB2RUNSTATS_USE_PROFILE Constant Public Type reference (TYPE) DB6CC_HEX4 '00000040' 20051216
28 DICTIONARY_KEEP Constant Public Type reference (TYPE) I 1 20051212
29 DICTIONARY_NOT_SET Constant Public Type reference (TYPE) I 0 20051213
30 DICTIONARY_RESET Constant Public Type reference (TYPE) I 2 20051212
31 FILETYPE_DEL Constant Public Type reference (TYPE) STRING 'DEL' DB6: General identifier 20051220
32 FILETYPE_IXF Constant Public Type reference (TYPE) STRING 'IXF' DB6: General identifier 20051220
33 FILETYPE_WSF Constant Public Type reference (TYPE) STRING 'WSF' DB6: General identifier 20051220
34 INDEX_CLEANUP_ONLY_ALL Constant Public Type reference (TYPE) I 1 20051212
35 INDEX_CLEANUP_ONLY_PAGES Constant Public Type reference (TYPE) I 2 20051212
36 INDEX_CONVERT Constant Public Type reference (TYPE) I 3 20051212
37 INPLACE_PAUSE Constant Public Type reference (TYPE) DB6IDENT DB6CC_INPLACE_OPTION_PAUSE DB6: General identifier 20051212
38 INPLACE_RESUME Constant Public Type reference (TYPE) DB6IDENT DB6CC_INPLACE_OPTION_RESUME DB6: General identifier 20051212
39 INPLACE_START Constant Public Type reference (TYPE) DB6IDENT DB6CC_INPLACE_OPTION_START DB6: General identifier 20051212
40 INPLACE_STOP Constant Public Type reference (TYPE) DB6IDENT DB6CC_INPLACE_OPTION_STOP DB6: General identifier 20051212
41 NUMFREQVALUES_NOT_SET Constant Public Type reference (TYPE) I -1 20051216
42 NUMQUANTILES_NOT_SET Constant Public Type reference (TYPE) I -1 20051216
43 REORG_INDEXES_ALL Constant Public Type reference (TYPE) STRING DB6CC_REORG_TYPE_INDEXESALL 20051212
44 REORG_TABLE_INPLACE Constant Public Type reference (TYPE) STRING DB6CC_REORG_TYPE_TABLEINPLACE 20051212
45 REORG_TABLE_MDC_RECLAIM Constant Public Type reference (TYPE) STRING 'MDCRECLAIM' 20090626
46 REORG_TABLE_OFFLINE Constant Public Type reference (TYPE) STRING DB6CC_REORG_TYPE_TABLEOFFLINE 20051212
Methods
# Method Level Visibility Method type Description Created on
1 BACKUP Static method Public Method 20051221
2 DESCRIBE Static method Public Method 20060111
3 DESCRIBE_AND_GET_WA Static method Public Method 20060112
4 DESCRIBE_TABLE Static method Public Method 20080429
5 EXECUTE_CMD Static method Public Method execute single admin command 20051220
6 EXECUTE_CMDS Static method Public Method execute list of admin command 20051220
7 EXPORT Static method Public Method export data 20051220
8 GET_PARTITIONS Static method Private Method 20061023
9 GET_STMM_TUNING_PARTITION Static method Public Method retrieve STMM tuning database partition 20060317
10 REORG Static method Public Method 20051212
11 RUNSTATS Static method Public Method 20051216
12 RUNSTATS_DBSTATC Static method Public Method 20051216
13 RUNSTATS_PROFILE Static method Public Method 20070402
14 SSV_BACKUP Static method Private Method 20080211
15 UPDATE_DB_CFG Static method Public Method update the db cfg 20061025
Events
Class CL_DB6_ADMIN_CMD has no event.
Types
Class CL_DB6_ADMIN_CMD has no local type.
Method Signatures

Method BACKUP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing BACKUP_TARGET Call by reference Type reference (TYPE) I 20051221
2 Importing BACKUP_TYPE Call by reference Type reference (TYPE) I 20051221
3 Importing BUFFER_SIZE Call by reference Type reference (TYPE) I 20051221
4 Returning COMMAND Value transfer Type reference (TYPE) STRING 20051221
5 Importing COMPRESS Call by reference Type reference (TYPE) ABAP_BOOL 20051221
6 Importing COMPRESS_EXCLUDE_LIB Call by reference Type reference (TYPE) ABAP_BOOL 20051221
7 Importing COMPRESS_LIB Call by reference Type reference (TYPE) STRING 20051221
8 Importing COMPRESS_OPTIONS Call by reference Type reference (TYPE) STRING 20051221
9 Importing DEDUP_DEVICE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20110725
10 Importing DEVICE_TAB Call by reference Type reference (TYPE) DB6_STRING_TAB DB6: List of single CLP commands 20051221
11 Importing INCLUDE_LOGS Call by reference Type reference (TYPE) ABAP_BOOL 20051221
12 Importing NUMBER_BUFFERS Call by reference Type reference (TYPE) I 20051221
13 Importing OPTIONS Call by reference Type reference (TYPE) STRING 20051221
14 Importing PARALLELISM Call by reference Type reference (TYPE) I 20051221
15 Importing PARTITION Call by reference Type reference (TYPE) I DB6CC_PARTITION_UNDEFINED 20051221
16 Importing PRIORITY Call by reference Type reference (TYPE) I 20051221
17 Importing SESSIONS Call by reference Type reference (TYPE) I 20051221
18 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS Logical name for a database connection 20051222
19 Importing TABLESPACES Call by reference Type reference (TYPE) DB6_STRING_TAB DB6: List of single CLP commands 20051221
20 Importing TESTMODE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20051221
21 Importing VENDORLIB Call by reference Type reference (TYPE) STRING 20051221
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20051221

Method DESCRIBE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning DESCRIPTION Value transfer Type reference (TYPE) DB6CLP_DESCRIBE_TAB 20060111
2 Importing SQL_STMT Call by reference Type reference (TYPE) CLIKE 20060111
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20060111
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20060111

Method DESCRIBE_AND_GET_WA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning DATA_REF_TAB Value transfer Type reference (TYPE) DBA_DATA_REF_TAB DBA Cockpit: Table of data object references 20060112
2 Importing SQL_STMT Call by reference Type reference (TYPE) STRING 20060112
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20060112
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20060112

Method DESCRIBE_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning DESCRIPTION Value transfer Type reference (TYPE) DB6CLP_DESCRIBE_TABLE_TAB DB6: Result Set of ADMIN_CMD DESCRIBE TABLE 20080429
2 Importing SQL_STMT Call by reference Type reference (TYPE) CLIKE 20080429
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20080429
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20080429

Method EXECUTE_CMD Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COMMAND Call by reference Type reference (TYPE) STRING 20051220
2 Importing PARTITION Call by reference Type reference (TYPE) I DB6CC_PARTITION_UNDEFINED 20060116
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20051220
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20051220

Method EXECUTE_CMDS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COMMANDS Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051220
2 Importing PARTITION Call by reference Type reference (TYPE) I 20060116
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS Logical name for a database connection 20051222
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20051220

Method EXPORT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning COMMAND Value transfer Type reference (TYPE) STRING 20051220
2 Importing FILENAME Call by reference Type reference (TYPE) STRING DB6: File Path 20051220
3 Importing FILETYPE Call by reference Type reference (TYPE) STRING DB6: General identifier 20051220
4 Importing LOBFILE Call by reference Type reference (TYPE) STRING 20051221
5 Importing LOBFILES Call by reference Type reference (TYPE) DB6_STRING_TAB 20051220
6 Importing LOBPATH Call by reference Type reference (TYPE) STRING 20051221
7 Importing LOBPATHS Call by reference Type reference (TYPE) DB6_STRING_TAB 20051220
8 Importing MODIFIED_BY Call by reference Type reference (TYPE) STRING 20051221
9 Importing MSGFILE Call by reference Type reference (TYPE) STRING DB6: File Path 20051220
10 Importing SELECT_STMT Call by reference Type reference (TYPE) STRING 20051220
11 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS Logical name for a database connection 20051222
12 Importing TESTMODE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20051220
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD Exceptions 20051220

Method GET_PARTITIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning PARTITIONS Value transfer Type reference (TYPE) PARTITION_LIST 20061023
2 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20061023
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20061023

Method GET_STMM_TUNING_PARTITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting CURRENT_PART Value transfer Type reference (TYPE) I Natural number 20060317
2 Exporting PREFERED_PART Call by reference Type reference (TYPE) I DB6: Partition Name for Listbox Element 20060317
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20060317
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20060317

Method REORG Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing ACCESS_MODE Call by reference Type reference (TYPE) I 20051212
2 Returning COMMAND Value transfer Type reference (TYPE) STRING 20051216
3 Importing DATA_PARTITION Call by reference Type reference (TYPE) STRING DBA: Simple List of Strings 20111201
4 Importing DICTIONARY_OPTION Call by reference Type reference (TYPE) I 20051212
5 Importing INDEXSCAN Call by reference Type reference (TYPE) ABAP_BOOL 20051212
6 Importing INDEX_OPERATION_MODE Call by reference Type reference (TYPE) I 20051212
7 Importing INDNAME Call by reference Type reference (TYPE) STRING 20051212
8 Importing INDSCHEMA Call by reference Type reference (TYPE) STRING 20051212
9 Importing INPLACE_OPTION Call by reference Type reference (TYPE) DB6IDENT DB6CC_INPLACE_OPTION_START DB6: General identifier 20051212
10 Importing LONGLOBDATA Call by reference Type reference (TYPE) ABAP_BOOL 20051212
11 Importing NO_TRUNCATE Call by reference Type reference (TYPE) ABAP_BOOL 20051212
12 Importing PARTITION Call by reference Type reference (TYPE) I DB6CC_PARTITION_UNDEFINED 20051212
13 Importing REORGTYPE Call by reference Type reference (TYPE) STRING 20051212
14 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS Logical name for a database connection 20051222
15 Importing TABNAME Call by reference Type reference (TYPE) STRING 20051212
16 Importing TABSCHEMA Call by reference Type reference (TYPE) STRING 20051212
17 Importing TESTMODE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20051219
18 Importing USE_TEMPSPACE Call by reference Type reference (TYPE) ABAP_BOOL 20051212
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: Exceptions of ADMIN_CMD 20051212

Method RUNSTATS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning COMMAND Value transfer Type reference (TYPE) STRING 20051216
2 Importing DEFAULT_FREQVALUE Call by reference Type reference (TYPE) I 20051216
3 Importing DEFAULT_QUANTILE Call by reference Type reference (TYPE) I 20051216
4 Importing INDEXES Call by reference Type reference (TYPE) DB6IDXLIST DB6: Index List 20051216
5 Importing PARALLELISM Call by reference Type reference (TYPE) I 20051216
6 Importing PRIORITY Call by reference Type reference (TYPE) I 20051216
7 Importing RUNSTATS_FLAGS Call by reference Type reference (TYPE) DB6CC_HEX4 20051216
8 Importing SAMPLING_RATE Call by reference Type reference (TYPE) F 20051216
9 Importing SAMPLING_RATE_IDX Call by reference Type reference (TYPE) F 20120615
10 Importing SAMPLING_SEED Call by reference Type reference (TYPE) I 20051216
11 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS Logical name for a database connection 20051222
12 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20051216
13 Importing TABSCHEMA Call by reference Type reference (TYPE) CLIKE 20051216
14 Importing TESTMODE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20051219
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20051216

Method RUNSTATS_DBSTATC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing ADMSTAT Call by reference Type reference (TYPE) DB6ADMSTAT DB6: View of DBSTATC for RFC access 20051216
2 Returning COMMAND Value transfer Type reference (TYPE) STRING 20051219
3 Importing INDEX_LIST Call by reference Type reference (TYPE) DB6TABIDXLIST DB6: Table - Index List 20051216
4 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20051222
5 Importing TABLE_LIST Call by reference Type reference (TYPE) DB6TABLIST DB6: Table List 20051216
6 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20051216
7 Importing TABSCHEMA Call by reference Type reference (TYPE) CLIKE 20051216
8 Importing TESTMODE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20051219
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20051216

Method RUNSTATS_PROFILE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning COMMAND Value transfer Type reference (TYPE) STRING 20070402
2 Importing PARALLELISM Call by reference Type reference (TYPE) I 20070402
3 Importing PRIORITY Call by reference Type reference (TYPE) I 20070402
4 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS Logical name for a database connection 20070402
5 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20070402
6 Importing TABSCHEMA Call by reference Type reference (TYPE) CLIKE 20070402
7 Importing TESTMODE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20070402
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD-Ausnahmen 20070402

Method SSV_BACKUP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COMMAND Call by reference Type reference (TYPE) STRING 20080211
2 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20080211
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD Exceptions 20080211

Method UPDATE_DB_CFG Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COMMAND Value transfer Type reference (TYPE) STRING 20061025
2 Importing COMPATIBILITY_MODE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20061025
3 Importing PARAM_VALUE_TAB Call by reference Type reference (TYPE) DB6PARAM_DESCR_TAB DB6: Paramater Value Table 20061025
4 Importing PARTITION Call by reference Type reference (TYPE) I DB6CC_PARTITION_UNDEFINED 20061025
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20061025
# Exception Resumable Description Created on
1 CX_DB6_ADMINCMD DB6: ADMINCMD Exceptions 20061025
History
Last changed by/on SAP  20130531 
SAP Release Created in 710