This is the most detail analyses of your system activities offered by Remote Analyst.  It includes over 90 different charts and reports.  Below are the selection criteria:

  • From & To: Date and time period the analyses should cover
  • Email to: List of people who should receive the analyses
  • Audit Volumes: List of volumes used for TMF activities. By default, RA preselects all volumes with “AUDIT” in their name
  • Allow: If a Measurement is started when Processes are already running, and their files are already open, MEASURE may record the DISCOPEN or FILE entities BEFORE recording the PROCESS entities; this effect can be significant on a busy system with many entities under measurement. This parameter allows one to specify by how many seconds a DISCOPEN or FILE entity recording can precede its opening PROCESS entity recording, in order to allow it still to be matched to its opening PROCESS.

Too small a value may result in DISCOPENs or FILEs not being matched to their opening Processes; too large a value may result in DISCOPENs or FILEs being matched to the wrong PROCESS if there is significant transient processing and Process IDs (s) are “re-used”.

Values range from 0.00 to 99.99 seconds; the default value is 5 seconds.

Example: ALLOW 15

  • Exclude: Several charts and reports exclude “low-activity” entities from their output, in order to minimize the amount of data presented; this parameter lets the user set the exclusion threshold. The “unit of measure” varies from report to report, but it is typically a percentage utilization (e.g. CPU Busy), a percentage of some global total (e.g. of total logical disc file I/O’s), or a rate of events per second (e.g. logical I/O’s per second). Reports exclude entities whose activity is below (less than) the threshold. Each report shows its EXCLUDE value and “unit of measure” at the bottom of every page.

Values range from 0.00 to 99.99; the default is 0.1.

Example: EXCLUDE 0.01

  • Flag: Some reports flag “transient” entities with an asterisk. Examples of transient entities include: processes that lived for less than the report “window”, and files that were open for less than the opening process’s life. This parameter allows the user to specify the percentage of the window or life for which the entity must have existed before it is considered “transient”; the entity is flagged if it lived for less than this percentage of the window or opening process’s life.

Values range from 1 to 99 percent; the default value is 90 percent.

Example: FLAG 95

  • IO Factor: Some reports attempt to apportion Disk Process CPU time to the files/partitions accessed, or to the programs accessing the files/partitions.

This parameter specifies how much more CPU-costly a Physical I/O (Driver Call Minus Cache Hit) is than a Cache Hit. Values range from 0.0 to 99.9; the default value is 2.0.

Example: IOFACTOR 2.5″;

  • Msgs: The “Program Overview” chart and the “Application Program Profiles” report show program resource consumptions and wait times per “unit of measurement”. One MESSAGE RECEIVED is often a good unit of measurement for “server” processes.

Other processes (e.g. batch processes), however, may receive only process-creation messages such as the STARTUP message, a PARAM message and one or more ASSIGN messages. A MESSAGE RECEIVED is not usually an appropriate unit of measurement for such processes.

MINMSGS allows the user to specify the minimum number of messages a process must receive in order for “Program Overview” and “Application Program Profiles” to show program resource consumptions and wait times PER MESSAGE RECEIVED. If the average number of messages received by processes run from a given program file is below MINMSGS, “Program Overview” and “Application Program Profiles” will instead show program resource consumptions and wait times PER SECOND of the average “lifetime” of one of these processes.

Values range from 1 to 9999; the default value is 10.

Example: MINMSGS 15

  • Needle: The “Low Selectivity SQL Table Access” report is intended to show the openers of files (NonStop SQL Tables) whose accesses exhibit low selectivity; that is, relatively small values for the records used to records accessed ratio.

Use this parameter to specify the selectivity threshold; the unit of measure is records used as a percentage of records accessed. “Low Selectivity SQL Table Access” will only show opens that exhibit selectivity equal to or less than this percentage.

Values range from 0.0001 to 99.9999 percent; the default value is 1.0000 percent (one record used for every one hundred records accessed).

Example: NEEDLE 0.0001 (one in a million!)

  • Max rows: maximum number of rows to be included per Excel sheet.
  • Include Macro Generated Reports – For many of its charts, DPA can produce a complete set of detail data. These are then placed as hidden data in the workbook.  You will then have the option on these specific reports (marked with a flower icon) to click on a displayed graph entry and see the detail data behind it and as it relates to the graph item you clicked.  One caveat is that generation of this much data, more than doubles the amount of time required to generate the DPA report, and also doubles the size of the workbook.  By default, this option is set to No (no hidden data will be produced).  You may set this to Yes, should you require the second level of details, and do not mind the extra report generation time, and workbook size.

 Next, select from a list of Reports & Charts to be include in the analyses.  Given that these are rather detail analytic, it is recommended that you include only those you are interested.  It will allow for quicker delivery of analyses.

Note that each report or chart requires metrics for certain Entities to be available for the selected date/time period.  During the generation process, DPA will look for these data, and if unavailable will still create the work-sheet but will write “No data to report”.  Again to save time, click on the button labeled “Verify Entity Availability”.  It checks for available data for the selected date & time period, and then only displays the list of reports and charts for which data is available.