SAP Function UPDATE_STATS_DB2 -

Parameter Reference Type Length Default Optional Text
SIGNI DBSTATC-SIGNI b 1 3 X
TABLE_NAME DD02L-TABNAME C 30

Parameter Reference Type Length Text
JCL_RC SYST-SUBRC I 4

Exception Text
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.