Kontakt

Ansicht
Dokumentation

RSDB4060 - iSeries: DB02 (Main Screen)

RSDB4060 - iSeries: DB02 (Main Screen)

ROGBILLS - Synchronize billing plans   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

Description

This program represents the main part of transaction DB02 for SAP Systems 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 ABAP Dictionary.

  • Display results of the comparison of the SAP kernel with the ABAP Dictionary (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 which tables 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.

Requirements

This program is only used in SAP Systems running on IBM iseries.

File statistics information is only available if the ABAP report programs RSDB4090 and RSDB4T6M are executed regularily.

Technical information

  • 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 using parameter UNIQUE_IND_CHECK = 'X'.
  • The consistency check for all objects is performed by function module DD_DB_CONSISTENCY_CHECK with all parameters equal to space. The function module sends a pop-up window giving you the choice of displaying existing check results or performing a new analysis.
  • The SAP kernel <-> DDIC check calls transaction SICK.
  • 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 more information, see the IBM documentation.
  • Detailed object analysis is performed by submitting report RSDB4DOA.
  • Deleted row analysis is performed by submitting RSDB4DLT.





ROGBILLS - Synchronize billing plans   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 4649 Date: 20240601 Time: 173253     sap01-206 ( 50 ms )