Ansicht
Dokumentation

GET_DB4_SPACE_STATISTICS - Get the Space Statistics of an OS/400

The function module db02_db4_get_space_info computes the space statistics of an AS/400 system.

You get information about the size of tables (in kB) and number of records. This is provided in three views:

1. A n average overview for those tables, for which any change of size or record number happened during the

last period of time. The average values are based on a choosable time scales (daily, weekly, monthly).

This information is gathered in the internal table SUM.

2. A detail view for a special choosen table of the average overview. Here you get further information about

the changes of size and row numbers in three choosable time scales (daily, weekly, monthly).

This information is stored in the parameter HISTORY.

3.You can list those tables changing more than a specified amount of change in size (DELTA_SIZE).

The list of tables fullfilling this condition is represented by the internal table CHANGE.

All data is imported from MONI.

Parameters:

a) Import-Parameters:

TABNAM: name of the table, for which more detail space statistics will be delivered.

SCAIL: time scale for determining the representation of the detail space statistics.

There are three possible values: (D: daily, W: weekly, M: monthly view).

DELTA_SIZE : Only those tables and indexes with a change in size at least of DELTA_SIZE (in kB) have an entry in the internal table CHANGE.

b) Tables:

SUM: represents the historical overview for those tables, for which any change of size or record number happened.

HISTORY: represents the detail view for a special choosen table of the historical overview.

Here you get further information about the changes of size and row numbers in three choosable time scales (daily, weekly, monthly).

CHANGE: contains tables that have changed more than specified with DELTA_SIZE.

Parameters

CHANGE
CURRSYST
DELTA_SIZE
HISTORY
SCAIL
SUM
TABNAM

STU4_TCC

ROGBILLS - Synchronize billing plans rdisp/max_wprun_time - Maximum work process run time
This documentation is copyright by SAP AG.

Length: 2838 Date: 20240523 Time: 120527 sap01-206 ( 50 ms )