SAP Program RSDB4TSC - Database Performance: Table Scans

Description
This program displays the table scan activity on DB2/400.
The first screen displays a summary by table name of those tablesagainst which table scans have been applied. You can select a table todetermine which statements are causing the the table scan (secondscreen).
The data displayed is collected by the function moduleST04_DB4_GET_TSC_INFO.

Use
RSDB4TSC is used in transaction ST04, Detail Analysis.

Precondition
This program is only used in SAP systems running on IBM iSeries.

Output
Display the table scan activity on DB2/400.

Database Files Accessed
SQ1000_DB4, SQ3000_DB4, SQTEXT_DB4