SAP Function ST04_DB4_GET_IDA_INFO - OS/400: Get Indexes Advised info for ST04 Detail Analysis

Parameter Reference Type Length Default Optional Text
RESETFLAG DB4QQPAR-QRESET C 1 SPACE X Character field of length one

Parameter Reference Length Optional Text
IDA_0100 DB4IDA0100 370 X Overview info about indexes advised performed
IDA_0200 DB4IDA0200 9772 X Detail Indexes Advised info for tables specified
IDA_0300 DB4IDA0300 569 X Indexes Advised definition list
TABLES_FOR_DETAILS DB4TABLST 40 X List of tables for which details are requested

Exception Text
NO_DATA_FOUND No data found about table scans
NO_DETAIL_DATA_FOUND No detail data found for tables specified
NO_TABLES_FOR_DETAIL_SPECIFIED Internal table TABLES_FOR_DETAILS is empty

Functionality
The function module collects data from the mySAP ERP databaseperformance tables about statement where the DB Optimizer advisedindexes.
This data is displayed in transaction ST04, Detail Analysis Menu,Indexes Advised (the report executed is RSDB4IDA).

Use
The table parameters IDA_0100, IDA_0200 and IDA_0300 are used forexporting information only. Data in them handed to the function modulewill be removed.
The table parameter TABLES_FOR_DETAILS is used for importing tables forwhich detailed information about indexes advised on them is requested.
The table parameter IDA_0100 will contain overview information abouttables for which the DB Optimizer advised indexes if the function moduleis called using this parameter (see reference structureDB4IDA0100).
The table parameter IDA_0300 will contain summary information aboutwhich indexes were advised on which tables if the function module iscalled using this parameter (see reference structureDB4IDA0300).
The table parameter TSC_0200 will contain detailed information abouttable scans performed on all tables listed in TABLES_FOR_DETAILS (seereference structure DB4IDA0200).

Example
Exapmles on how to call the function module is to found inRSDB4IDA.