By using sapdba -check , -analyze , or -next (see SAPDBA Command Mode ), you can display information about all relevant parts and parameters of the database (tablespaces, fragmentation, data files, extents, directories, freespace, redo log files, SGA parameters, init.ora parameters, etc.) or database analyses. The information is stored in a corresponding log in the SAPCHECK directory.

You can use the Scheduler in the MS ResourceKit (MICROSOFT) to schedule the creation of a check/analysis log, or enter the following command in the command line (example for using sapdba -check ):

The database must be active at the specified time. If the database is usually shut down, you can also schedule database startups and shutdowns. To do this use sapdba -startup or
sapdba -shutdown (see SAPDBA Command Mode)

The check.bat file should have the following contents:

To check any of the background statements that have been set, enter at in the command line.

Information about the tables and tablespaces can also be displayed online by selecting the menu items Tablespace administration ® Freespace and fragmentation of all tablespaces (see SAPDBA: Tablespace Administration ) or Reorganization ® Check extents and fragmentation (see SAPDBA: Reorganization).