RSDB4IDC is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program displays the index create activity on DB2/400...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
If you would like to execute this report or see the full code listing simply enter RSDB4IDC into the relevant SAP transactions such as SE38 or SE80
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
Title: Database Performance: Index Creates
Text Symbol: Y02 = Table/structure does not exist.
Text Symbol: Y01 = ERROR in generating fieldcatalog
Text Symbol: T02 = DB2/400 Index Creates Detail
Text Symbol: T01 = DB2/400 Index Creates
Text Symbol: C34 = Last merge of database monitor tables
Text Symbol: C33 = Total database processing time (s)
Text Symbol: C32 = Last reset
Text Symbol: C31 = Database start
Text Symbol: C30 = DB2/400 database monitor information:
Text Symbol: C29 = Oldest data from
Text Symbol: C28 = Last time merge skipped
Text Symbol: C27 = Last time merge started
Text Symbol: C26 = Last successful merge
Text Symbol: C25 = Last successful dump
Text Symbol: 007 = Since Reset
Text Symbol: 006 = Reset
Text Symbol: 005 = Since Database Start
Text Symbol: 004 = No tables for details specified
Text Symbol: 003 = Unknown error
Text Symbol: 002 = Can not find detail data
Text Symbol: 001 = No index created info available
No INCLUDES are used within this REPORT code!
No SAP DATABASE tables are accessed within this REPORT code!
ST04_DB4_GET_IDC_INFO CALL FUNCTION 'ST04_DB4_GET_IDC_INFO' EXPORTING resetflag = p_reset_flag TABLES idc_0100 = p_idc_0100 EXCEPTIONS no_data_found = 1 OTHERS = 2.
ST04_DB4_GET_IDC_INFO CALL FUNCTION 'ST04_DB4_GET_IDC_INFO' EXPORTING resetflag = p_reset_flag TABLES tables_for_details = i_tab_list idc_0200 = p_idc_0200 EXCEPTIONS no_table_for_detail_specified = 1 no_detail_data_found = 2 OTHERS = 3.
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
RSDB4IDC - Database Performance: Index Creates RSDB4IDC - Database Performance: Index Creates RSDB4IDA - Database Performance: Index Advised RSDB4IDA - Database Performance: Index Advised RSDB4GEN - iSeries: Generate EXEC SQL Reports Used in CCMS RSDB4GEN - iSeries: Generate EXEC SQL Reports Used in CCMS