Fonction SAP UPDATE_STATS_DB2 -

Paramètre Reférence Type Long. Valeur par déf. Facultatif Description
SIGNI DBSTATC-SIGNI b 1 3 X
TABLE_NAME DD02L-TABNAME C 30

Paramètre Reférence Type Long. Description
JCL_RC SYST-SUBRC I 4

Exception Description
ERROR
NOT_FOUND

Functionality
This function module does:
1.) Perform RUNSTATS on a table.
2.) Run a LISTCAT job for each index in order to get the size of theindexspace.
3.) Insert the results into the SAP tables DBSTATTDB2, DBSTATHDB2,DBSTATIDB2 and DBSTAIHDB2.
The signi parameter controls the level of accuracy of the RUNSTATS job.Three different values are possible:
1: high accuracy
2: medium accuracy
3: low accuracy
The levels differ in the percentage of rows to sample when collectingnon-indexed column statistics. To maintain the percentages, choose'Runstats' on the 'Profile parameter' screen in transaction DB2J.