SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | DB2 for AS/400(BC-DB-DB4) SAP BC
RSDB4IDA SAP ABAP Report - Database Performance: Index Advised
RSDB4IDA 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 index advised 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 RSDB4IDA into the relevant SAP transactions such as SE38 or SE80
ABAP code to call this SAP report using the submit statement
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.
SUBMIT RSDB4IDA. "Basic submit
SUBMIT RSDB4IDA AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB4IDA VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: Database Performance: Index Advised
Text Symbol: 001 = No Index Advised info available
Text Symbol: 002 = No detail info found
Text Symbol: 003 = Since Database Start
Text Symbol: 004 = Reset
Text Symbol: 005 = Since Reset
Text Symbol: C25 = Last successful dump
Text Symbol: C26 = Last successful merge
Text Symbol: C27 = Last time merge started
Text Symbol: C28 = Last time merge skipped
Text Symbol: C29 = Oldest data from
Text Symbol: C30 = DB2/400 database monitor information:
Text Symbol: C31 = Database start
Text Symbol: C32 = Last reset
Text Symbol: C33 = Total database processing time (s)
Text Symbol: C34 = Last merge of database monitor tables
Text Symbol: T01 = DB2/400 Index Advised
Text Symbol: T02 = DB2/400 Index Advised Detail
Text Symbol: Y01 = ERROR in generating fieldcatalog
Text Symbol: Y02 = Table/structure does not exist.
INCLUDES used within this REPORT RSDB4IDA
No INCLUDES are used within this REPORT code!
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
ST04_DB4_GET_IDA_INFO CALL FUNCTION 'ST04_DB4_GET_IDA_INFO' EXPORTING resetflag = p_reset_flag TABLES tables_for_details = i_tab_list ida_0200 = p_ida_0200 EXCEPTIONS no_data_found = 1 no_tables_for_detail_specified = 2 no_detail_data_found = 3 OTHERS = 4.
ST04_DB4_GET_IDA_INFO CALL FUNCTION 'ST04_DB4_GET_IDA_INFO' EXPORTING resetflag = p_reset_flag TABLES ida_0100 = p_ida_0100 ida_0300 = p_ida_0300 EXCEPTIONS no_data_found = 1 OTHERS = 4.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name RSDB4IDA or its description.