Ansicht
Dokumentation
GET_TABLE_SIZE_INFO_DB2 -
rdisp/max_wprun_time - Maximum work process run time SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
Functionality
This function module provides information on the size of a given table and the indexes defined on it.
Table information is taken from the DB2 catalog:
- NAME: Table name
- CREATOR: Authorization ID under which the table was created
- CARDF: Number of entries in the table
- NPAGES: Number of pages on which rows of the table appear
- PGSIZE: Size of pages in KB
- STATSTIME: Timestamp of the last RUNSTATS run
The fields CARDF and NPAGES are maintained in the DB2 catalog using the RUNSTATS utility. For both fields, the initial value is -1.
In addition, a table is returned which shows the size of the indexspaces in KB for each index defined on the table. The sizes are determined using OS/390 utilities during the update of transaction DB02. The parameter LISTTIME displays the date and time of the last analysis.
The parameter INDEXES_NOT_FOUND provides the number of indexes for which size information could not be determined. This can occur when, for example, an index is created after the last update of transaction DB02.
Example
Notes
Further information
Parameters
CREATORINDEXES_NOT_FOUND
INDEX_SIZE_LIST
TABLE_INFO
TABLE_NAME
Exceptions
TABLE_NOT_FOUNDFunction Group
S390BAL_S_LOG - Application Log: Log header data CL_GUI_FRONTEND_SERVICES - Frontend Services
This documentation is copyright by SAP AG.
Length: 1648 Date: 20240523 Time: 112229 sap01-206 ( 32 ms )