Control Center Operations Guide for VSE

UPDATE STATISTICS

This function provides you with the capability of issuing the UPDATE STATISTICS or UPDATE ALL STATISTICS commands in a background DBSU job.

When you select Option 5, Update Statistics, on the Table Utility main menu, the Update Statistics Submit screen is displayed (Figure 53).

Figure 53. Update Statistics Submit Screen

+--------------------------------------------------------------------------------+
|     mm/dd/yyyy                 CONTROL CENTER                         hh:mm:ss |
|*---------------------- UPDATE STATISTICS SUBMIT SCREEN ----------------------* |
||                                                                             | |
||********************      VSE/POWER JOB PARAMETERS      *******************  | |
||                                                                             | |
|| JOBNAME   => ________  CLASS   => A   PRI => 3  DISP    => D (D,H,L,K)      | |
||                                                                             | |
|| FROM      => VS52____  DUETIME => ____ (HHMM)    DUEDATE => ______          | |
||                                                                             | |
|| DUEDAY    => __________________________________________                     | |
||                                                                             | |
|| LST CLASS => A                                                              | |
||                                                                             | |
|| OTHER     => ______________________________________________________________ | |
||                                                                             | |
|| **************************      JOB OPTIONS      ************************** | |
||                                                                             | |
|| UPDATE ALL STATISTICS => 2 (1=YES/2=NO)                                     | |
||                                                                             | |
||                                                                             | |
|*------------------------------------------------------------------ SQC64 ----* |
|                                                                                |
|PRESS ENTER TO PROCESS                                                          |
|ENTER F1=HELP F3=EXIT F12=CANCEL                                                |
+--------------------------------------------------------------------------------+

Update Statistics Submit Screen Required Parameters

The first parameter, JOBNAME, is the only one that is required. For a detailed description of the job submission parameters, see job submission parameters.

Update Statistics Submit Screen Optional Parameters

UPDATE ALL STATISTICS

Specifies whether ALL should be added to the UPDATE STATISTICS command. 1 indicates YES, 2 indicates NO. When this parameter is set to NO, the statistics are reset for the first column in each index. When set to YES, the statistics are reset for all columns in all indexes. The statistics include such things as the number of rows in a table and the number of unique values in an index column. They are used by SQL to optimize retrievals. Since this is can be a lengthy and resource consuming process, it is recommended that you do not reset all of the statistics during normal work hours.

Note:

You should update all statistics on a periodic basis for tables that are subject to frequent change.

After entering the desired submit parameters, press ENTER to submit the job to VSE/POWER.