Enabling and Disabling Statistics

The purge process updates the statistics of the following tables before deleting entries from them:

• PSPRCSRQST

• PSPRCSQUE

• PSPRCSPARMS

• PS_MESSAGE_LOG

• PS_MESSAGE_LOGPARM

• PS_PRCSRQSTDIST

  Note:

  Not applicable to DB2.

• PS_CDM_LIST

• PS_CDM_AUTH

• PS_CDM_FILE_LIST

The option to enable or disable updating statistics is set in the process scheduler configuration file (psprcs.cfg). Access the process scheduler configuration file using PSADMIN.

See Understanding the Sections in PSPRCS.CFG File Based on Operating Systems.

To enable or disable statistics:

1. In the section [Process Scheduler], check the value for Update Table Stats on Purge. Enter 1 to enable updating of statistics.

   ; Set to run statistics for the Process Request and Report Manager
   ; tables when the Process Scheduler Server purge
   ;  0        Disable updating of the table statistics
   ;  1        Enable updating of the table statistics
   Update Table Stats on Purge=1

2. In the section [PSTOOLS], check the value for DbFlags. Enter 0 (Default) to issue the command to update table statistics to the database.

   ; ;-------------------------------------------------------------
   ; DbFlags Bitfield
   ;
   ; Bit       Flag
   ; ---       ----
   ; 1         - Ignore metaSQL to update database statistics(shared with COBOL)
   ; 2         - not yet allocated
   ; 4         - Disable Second DB Connection
   ; 8         - Disable Persistent Secondary DB Connection
   ; 16        - not yet allocated
   ; 32        - not yet allocated
   ; 64        - not yet allocated
   ; 128       - not yet allocated
   ; 256       - not yet allocated
   DbFlags=0

   Note:

   If DBFlags = 1 the purge process will not update statistics regardless of the Update Table Stats on Purge setting.