Interval Analysis

 Product  Previous  Next

Performance Intelligence > Products > PIReporter for zOS > PIReporter for CICS > View and Models > Interval Analysis

Interval summary from data warehouse

The Interval summary from data warehouse model allows you to create Usage summary reports based on different summary keys for specific time intervals. The information is retreived from TMON CICS TI (Interval) records.

Parameters:

 
Database Selection
Connection Type
The database connection technology that will be used. If ODBC is selected the application will connect via an ODBC System DSN that is taken from the "Database Name" parameter. If ADO String is selected, the application will connect to the server defined in the "Computer Network Address" parameter, the database defined in the "Database Name" parameter using the "User ID" and "Password" parameters for access authorization.
Values can be selected from the list of allowed values.
Predefined Values:
  • ODBC (ODBC) - This value is selected by default
  • ADO String (NULL)
Database Name
If the "Connection Type" parameter is set to ODBC - The name of the Database DSN that will be queried. This allows you to have multiple databases with different information in them. For example - by default the Setup program installs a history database for your data (TCHIST) and a sample database to experiment with (containing fictional data) TCSAMP.
If the "Connection Type" parameter is set to ADO String - The name of the database in SQL Server
Values can be selected from the list or typed.
Predefined Values:
  • TCHIST (TCHIST) - This value is selected by default
  • TCSamp (TCSamp)
User ID
The User ID used to establish a connection to the database, if "ADO String" is selected in the "Connection Type" parameter. (This will be used for authorization by SQL over the TCP/IP transport)
Values can be selected from the list or typed.
Predefined Values:
  • B33UIDB_USER (B33UIDB_USER) - This value is selected by default
  • sa (sa)
Password
The Password used to establish a connection to the database, if "ADO String" is selected in the "Connection Type" parameter. (This will be used for authorization by SQL over the TCP/IP transport)
Values can be selected from the list or typed.
Predefined Values:
  • Default (B33UIDB_USER) - This value is selected by default
Server Name/Address
The name or network address (IP Value) of the machine where SQL Server is installed, if "Ado String" is selected for the "Connection Type" parameter.
Values can be selected from the list or typed.
Predefined Values:
  • 127.0.0.1 (127.0.0.1) - This value is selected by default
 
Date Selection
The Interval Summary from Data Warehouse model offers date selection based on the Date (LMRKDATE) and time (TIMEINTVL, ENDINTVL) fields and works with selection windows.
A selection window is an intersection of date and time coordinates. Think of the time as a two dimensional grid with the dates on the X axis and the hours of the day on the Y axis. Imagine that your database contains information for the entire year and you want to view all the information collected between July 4 and October 14 during peak work hours (9:00AM to 2:30PM)
From Date - Period 1
The start date for the date selection window. The Job Start Date (LMRKDATE) field will be compared to the value you provide in this parameter.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
Predefined Values:
  • First Day (NULL)
  • Today (Today)
  • Yesterday (Yesterday) - This value is selected by default
  • Start of This Work Week (StartOfThisWorkWeek)
  • Start of Previous Work Week (StartOfPrevWorkWeek)
  • End of Previous Work Week (EndOfPrevWorkWeek)
  • Start of This Month (StartOfThisMonth)
  • Start of Previous Month (StartOfPrevMonth)
  • End of Previous Month (EndOfPrevMonth)
  • Start of This Quarter (StartOfThisQuarter)
  • Start of Previous Quarter (StartOfPrevQuarter)
  • End of Previous Quarter (EndOfPrevQuarter)
  • Start of This Year (StartOfThisYear)
  • Start of Previous Year (StartOfPrevYear)
  • End of Previous Year (EndOfPrevYear)
  • Sunday (Sunday)
  • Monday (Monday)
  • Tuesday (Tuesday)
  • Wednesday (Wednesday)
  • Thursday (Thursday)
  • Friday (Friday)
  • Saturday (Saturday)
To Date - Period 1
The end date for the date selection window. The Job Start Date (LMRKDATE) field will be compared to the value you provide for this parameter.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
Predefined Values:
  • Last Day (NULL)
  • Today (Today)
  • Yesterday (Yesterday) - This value is selected by default
  • Start of This Work Week (StartOfThisWorkWeek)
  • Start of Previous Work Week (StartOfPrevWorkWeek)
  • End of Previous Work Week (EndOfPrevWorkWeek)
  • Start of This Month (StartOfThisMonth)
  • Start of Previous Month (StartOfPrevMonth)
  • End of Previous Month (EndOfPrevMonth)
  • Start of This Quarter (StartOfThisQuarter)
  • Start of Previous Quarter (StartOfPrevQuarter)
  • End of Previous Quarter (EndOfPrevQuarter)
  • Start of This Year (StartOfThisYear)
  • Start of Previous Year (StartOfPrevYear)
  • End of Previous Year (EndOfPrevYear)
  • Sunday (Sunday)
  • Monday (Monday)
  • Tuesday (Tuesday)
  • Wednesday (Wednesday)
  • Thursday (Thursday)
  • Friday (Friday)
  • Saturday (Saturday)
Month Select - Period 1
This parameter allows you to select only specific month(s) within the date selection window you specified.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
You can select up to 12 values for this parameter.
Predefined Values:
  • All (NULL) - This value is selected by default
Day Select - Period 1
This parameter allows you to select only specific day(s) of the month within the date selection window you specified. (For example - assume that the 2nd and 4th days of every month are critical days - and you want to compare the historical performance data in these dates over the last quarter - you will set the date selection window for the entire quarter and select 2 and 4 in this parameter to limit the day selection to the critical days.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
You can select up to 31 values for this parameter.
Predefined Values:
  • All (NULL) - This value is selected by default
Day Of Week - Period 1
This day allows you to select only specific day(s) of the week. This can be useful to track performance over the workweek vs. weekends.
Values can be selected from the list of allowed values.
You can select up to 7 values for this parameter.
Predefined Values:
  • All (-1) - This value is selected by default
  • Sunday (1)
  • Monday (2)
  • Tuesday (3)
  • Wednesday (4)
  • Thursday (5)
  • Friday (6)
  • Saturday (7)
Time Window Start - Period 1
The start of the time window within the selected date window. The Time Interval (TIMEINTVL) field will be compared to the value you provide for this parameter.
Values can be selected from the list or typed.
Predefined Values:
  • Start of the Day (00:00) - This value is selected by default
Time Window End - Period 1
The end of the time within the selected date window. The End Interval (ENDINTVL) field will be compared to the value you provide for this parameter.
Values can be selected from the list or typed.
Predefined Values:
  • End of the Day (00:00) - This value is selected by default
 
Job Selection
System ID
The Identifier(s) of the system(s) that will be queried. The TASYSID field will be compared to the value(s) you provide for this parameter.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
You can select up to 50 values for this parameter.
Predefined Values:
  • All (ALL) - This value is selected by default
 
Query Fields
Group By
Specify the summary keys for the output. Specify the hierarchy of summary you want to see (For example - for Months within System select System ID followed by Transaction Start - Month, but for Systems within Months select Transaction Start - Month followed by System ID).
You can select up to 4 values for this parameter.
Fields you can select:
  • NULL (NULL)
  • Transaction Start - Date (LMRKDATE)
  • System ID (TISYSID)
  • Time Interval (timeintvl)
  • End Time Interval (endintvl)
  • Transaction Start - Month (MONTH)
  • Transaction Start - Day (DAY)
Measures
The data fields you want to aggregate. (for example - CPU Time)
You can select up to 10 values for this parameter.
Fields you can select:
  • NULL (NULL)
  • 0-1 Sec. Transaction Response Time Counter (TIRPS01)
  • 1-2 Sec. Transaction Response Time Counter (TIRPS12)
  • 2-3 Sec. Transaction Response Time Counter (TIRPS23)
  • 3-4 Sec. Transaction Response Time Counter (TIRPS34)
  • 4-5 Sec. Transaction Response Time Counter (TIRPS45)
  • Over 5 Sec. Transaction Response Time Counter (TIRSPO5)
  • CPU Time (TIAPLCTM)
  • Dispatch Time (TIDSPATM)
  • Dispatch Queue Counter (tidspqct)
  • Dispatch Queue Time (tidspqTM)
  • File Control Wait Counter (tifcpwct)
  • File Control Wait Time (tifcpwTM)
  • Total MRO Requests Count (timrorct)
  • Total MRO Requests Time (TIMRORTM)
  • Total User DB Request Count (TIUDBCCT)
  • Total User DB Request Time (TIUDBCTM)
  • Total User DB Wait Time Count (tiudbwct)
  • Total Wait Time on DB2 Requests (TIDB2WTM)
  • Total Wait Count on DB2 Requests (TIDB2WCT)
  • Transaction Count (TITRNETL)
  • % of 0-1 Sec. Transaction Response Time Counter (TIRSP01PCT)
  • % of 1-2 Sec. Transaction Response Time Counter (TIRSP12PCT)
  • % of 2-3 Sec. Transaction Response Time Counter (TIRSP23PCT)
  • % of 3-4 Sec. Transaction Response Time Counter (TIRSP34PCT)
  • % of 4-5 Sec. Transaction Response Time Counter (TIRSP45PCT)
  • % of Over 5 Sec. Transaction Response Time Counter (TIRSPO5PCT)
 
Sort
Sort report by
Choose Sort Field. The report will be sorted by this field in addition to the sort by the Summary Keys. You can select Sort Field from Display fields selected.
Fields you can select:
  • Summary Keys (NULL) - This value is selected by default
  • 0-1 Sec. Transaction Response Time Counter (TIRPS01)
  • 1-2 Sec. Transaction Response Time Counter (TIRPS12)
  • 2-3 Sec. Transaction Response Time Counter (TIRPS23)
  • 3-4 Sec. Transaction Response Time Counter (TIRPS34)
  • 4-5 Sec. Transaction Response Time Counter (TIRPS45)
  • Over 5 Sec. Transaction Response Time Counter (TIRSPO5)
  • CPU Time (TIAPLCTM)
  • Dispatch Time (TIDSPATM)
  • Dispatch Queue Counter (tidspqct)
  • Dispatch Queue Time (tidspqtm)
  • File Control Wait Counter (tifcpwct)
  • File Control Wait Time (tifcpwtm)
  • Total MRO Requests Count (timrorct)
  • Total MRO Requests Time (TIMRORTM)
  • Total User DB Request Count (TIUDBCCT)
  • Total User DB Request Time (TIUDBCTM)
  • Total User DB Wait Time (tiudbwct)
  • Total Wait Time on DB2 Requests (TIDB2WTM)
  • Total Wait Time on DB2 Requests (TIDB2WCT)
Sort Order
Define the report's default sort order - ascending or descending.
Values can be selected from the list of allowed values.
Predefined Values:
  • Ascending (A) - This value is selected by default
  • Descending (D)
Key 1 Sort Order
Define the sort order for summary key 1.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (NULL) - This value is selected by default
  • Ascending (A)
  • Descending (D)
Key 2 Sort Order
Define the sort order for summary key 2.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (NULL) - This value is selected by default
  • Ascending (A)
  • Descending (D)
Key 3 Sort Order
Define the sort order for summary key 3.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (NULL) - This value is selected by default
  • Ascending (A)
  • Descending (D)
Key 4 Sort Order
Define the sort order for summary key 4.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (NULL) - This value is selected by default
  • Ascending (A)
  • Descending (D)
 
Excel Graph Options
Chart Type
Select what kinds of charts will be created in an Excel file. Possible values are:
  • None - No chart will be created
  • Element Comparison - Charts comparing the measures of the first and second summary level will be created. There will be one chart comparing the values of the first summary level field, and for each of these values - a chart comparing the values of the second summary level field within it.
  • Element Breakdown - Charts displaying a pie with information breakdown will be created for the first summary level, and an additional chart will be created showing the breakdown of the measure fields for the second summary level within each one of the first summary level values.
The selection of using comparison or breakdown charts is based on the measures you use. If for example you selected the measures - Transactions 0 - 1 seconds, Transactions 1 - 2 seconds, ..., Transaction over 5 Seconds - it makes sense to show a break down chart. However, if the measures you selected are not related and are not a breakdown of a larger value - select the chart comparison option.
Values can be selected from the list of allowed values.
Predefined Values:
  • Element Comparison - 2 Levels (TwoLevels)
  • Element Comparison - Upper Level (UpperLevel)
  • None (NULL) - This value is selected by default
 
Chart Options
Chart Type
Select what kinds of charts will be created as output. Possible values are:
  • None - No chart will be created
  • Element Comparison - Charts comparing the measures of the first and second summary level will be created. There will be one chart comparing the values of the first summary level field, and for each of these values - a chart comparing the values of the second summary level field within it.
  • Element Breakdown - Charts displaying a pie with information breakdown will be created for the first summary level, and an additional chart will be created showing the breakdown of the measure fields for the second summary level within each one of the first summary level values.
The selection of using comparison or breakdown charts is based on the measures you use. If for example you selected the measures - Transactions 0 - 1 seconds, Transactions 1 - 2 seconds, ..., Transaction over 5 Seconds - it makes sense to show a break down chart. However, if the measures you selected are not related and are not a breakdown of a larger value - select the chart comparison option.
Values can be selected from the list of allowed values.
Predefined Values:
  • Element Comparison (Bar) - This value is selected by default
  • Element Break Down (Pie)
  • None (NULL)
Y Axis Format
Define if the Y Axis values are displayed as a numeric value (the default) or as accumalated time values.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (Default) - This value is selected by default
  • Time (Time)
Legend Style
Selects the style of the legend that will be displayed in the chart. You can select between displaying the Serie names, Their Values or an automatic mode (Default) where the Values are displayed if only one measure field is selected, or the serie names otherwise.
Values can be selected from the list of allowed values.
Predefined Values:
  • Automatic (Automatic) - This value is selected by default
  • Series (Series)
  • First Serie Values (Values)