History report


The Data Optimizer History report provides a view of the history information that Data Optimizer has collected.

The History report identifies how many samples have been stored by Data Optimizer for the entity and the date and time of the last sample. For each sample, the report includes the following information:

  • Number of direct (random) requests
  • Number of sequential requests
  • Number of I/Os for the DATA and INDEX component
  • Transition count, which is the number of times that a program transitioned from direct to sequential processing or from sequential processing to direct

Two History key formats are available: DSNPGM and FULLKEY. The History key in effect when the sample is taken determines the format of the data presented in the History report.

  • For the DSNPGM key, the report includes the program name and data set name combination that were to access the data.
  • For the FULL key, the report includes the job name, step name, procstep name, program name, and DD name used to access the data. This key is the default.

Sample JCL for the History report and detailed instructions about how to modify the JCL to create the report are in the BSS.SAMPLIB member DAPUHSTJ. The REXX EXEC that creates the report is in the BSS.ISPEXEC member DAPUHSTR.

The following figure shows an example of the History report with the History key set to FULL.

Data Optimizer History Report executed on: 23 Aug 2006 at 14:20:05.

Job Name  =  PPMRNDR                                                         
Step Name =  VSAMRAND                                                        
Proc Name =  SAS                                                             
DD Name   =  KSDS                                                            
Sample  4 taken on 04/21/2006 at 09:10:17.                                   

SAMPLE  TRANSITIONS DIRECT      SEQUENTIAL  DATA I/Os INDEX I/Os
------- ----------- ----------- ----------- ----------- -----------          
01 LSR         1     3000000         0         207         7          
02 LSR         1     3000000         0         207         7          
03 LSR         1     3000000         0         202         7          
04 LSR         1     3000000         0         202         7          

Data Optimizer History Report Summary                  
Number of records read:  58                            
Number of Data Optimizer history records processed:  58


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Batch Optimizer (Advanced and Standard) 2.9