CA MICS Analyzer Option for IMS (IMS) Queries › IMSDAT – IMS Daily Top 10 Workloads › Query Defaults

Query Defaults

• IMSIAU DAYS timespan file: Cycle 01
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  CPCID

  CPCID = TRIM(CPUMOD) || '-' || TRIM(CPCMODID) || '-Serial: ' || SUBSTR(CPCSEQNB,12,5) ;
  

Modifications

The following modifications can be made to the query:

• You can adjust the TOPnn value to something other than the default of 10. You can add filter statements to select only a single SYSID or IMSID, or select only specific production IMS regions.
• You can increase the cycles input to create charts for multiple days, but comment out the user code in the IMSAPU file input step that restricts processing to yesterday’s data.
• Apply a format to the IMSAPU variable to convert it from the 12 character workload identifier to a more meaningful workload description.

Note: If you change the TOPnn value (default TOP 10), modify the query chart title to reflect the changed value.