SAP Program RSDB4060 - iSeries: DB02 (Main Screen)

Description
This program represents the main part of transaction DB02 for SAPSystems on IBM iSeries.
It is also used in transaction ST04, Detail Analysis Menu,State on disk.
DB02 displays

  • File statistics information (counts and sizes) for tables and indexes in
    • the SAP database library
    • Information about SAP tables, indexes, and views missing from the SAP
      • database library or the ABAP Dictionary
      • Current disk status (available and used disk space)

        • Available functions
        • Refresh file statistics: Performs a new analysis either in the
          • background or online.
          • Consistency check:

            • Display SAP tables with missing primary keys.
            Display all objects missing from the SAP database library or ABAPDictionary.
            Display results of the comparison of the SAP kernel with the ABAPDictionary (transaction SICK).
            • Detailed object analysis: More detailed information about file
              • statistics
              • Deleted row analysis (for all tables): Displays how much space is
                • reserved by deleted rows. You can use this information to decide whichtables to reorganize to free disk space.
                • List damaged files: Checks to see if there are any damaged files
                  • in the SAP database library and displays any that are found.
                  • Missing indexes: Displays all indexes (including primary keys)
                    • missing from the SAP database library or ABAP Dictionary.
                    • Space statistics: Displays size and record count history for
                      • tables per day, week or month.

                      Precondition
                      This program is only used in SAP Systems running on IBM iseries.
                      File statistics information is only available if the ABAP reportprograms RSDB4090 and RSDB4T6M areexecuted regularily.

                      Technical-info

                      • The information displayed on the main screen of DB02 (screen 0110) is
                        • collected by function module DB02_DB4_GET_INFO
                        .
                        • File statistics are refreshed by submitting report
                          • RSDB4090 in the background or online.
                          • Check of tables without primary keys is performed by function module
                            • DD_DB_CONSISTENCY_CHECK usingparameter UNIQUE_IND_CHECK = 'X'.
                            • The consistency check for all objects is performed by function module
                              • DD_DB_CONSISTENCY_CHECK with allparameters equal to space. The function module sends a pop-up windowgiving you the choice of displaying existing check results or performinga new analysis.
                              • The SAP kernel <-> DDIC check calls transaction SICK.

                              • Missing indexes is performed by function module
                                • DD_DB_CONSISTENCY_CHECK with parameterMISSING_IND_DISP = 'X'.
                                • Space statistics are displayed by submitting RSDB4TAM

                                  • .
                                  • Damaged files are checked by calling the API DAMAGEDF which calls (via
                                    • AS4DBCALL) the iSeries API QUSLOBJ with format OBJL0200. For moreinformation, see the IBM documentation.
                                    • Detailed object analysis is performed by submitting report
                                      • RSDB4DOA.
                                      • Deleted row analysis is performed by submitting RSDB4DLT

                                        • .