Transaction Analysis

 Product  Previous  Next

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

Transaction summary from data warehouse

The Transaction summary from data warehouse model allows you to create transaction summary reports based on different summary keys for specific time intervals. The information is retreived from TMON CICS TA 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
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)
Interval
Define the collection interval that will be reported. This is useful If multiple people in the organization are interested in different time intervals (for example - all day vs. 8am - 5pm) and different time collections are defined.
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 5 values for this parameter.
Predefined Values:
  • Default - All Day (0) - 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
Transaction ID
The name(s) of the transaction(s) that will be selected. The TATRNID field will be compared to the value(s) you provide for this parameter. A Logical OR is performed between the values defined for this parameter and the values defined for the Transaction Selection Pattern 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
Transaction Selection Pattern
A Set of selection patterns that will be used to compare the TATRNID field for selection.
  • Patterns can be separated with a comma, e.g. - Pattern1,Pattern2
  • Use * to define a set of 0 or more "any" characters in the pattern.
  • Use ? to to define a place holder for exactly 1 "any" character in the pattern.
e.g. - XYZ* will match all the transactions that start with the letters XYZ including XYZ, but XYZ? will match every 4 letters transaction that starts with XYZ, but will not match the job name XYZ.
A Logical OR is performed between the values defined for this parameter and the values defined for the Transaction ID parameter.
Values can be selected from the list or typed.
Exclude Transactions
A set of selection patterns that will be used to reject rows when comperd to the TATRNID field.
The values for this parameter use the same pattern convention as the "Transaction Selection Pattern" parameter.
e.g. - If you want to select all the transactions that start with ZZ but exclude the transactions ZZ123 and all the transactions that start with ZZ6, you will enter ZZ* in the "Transaction Selection Pattern" parameter and ZZ123,ZZ6* in the "Exclude Transactions" parameter.
Values can be selected from the list or typed.
Program ID
The name(s) of the program(s) that will be selected. The TAPGM1 field will be compared to the value(s) you provide for this parameter. A Logical OR is performed between the values defined for this parameter and the values defined for the Programs Selection Pattern 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
Program Selection Pattern
A set of selection patterns that will be used to compare the TAPGM1 field for selection. Syntax is identical to the syntax used for the Transaction Selection Pattern parameter.
Values can be selected from the list or typed.
Exclude Programs
A set of selection patterns that will be used to reject rows when compared to the TAPGM1 field. Syntax is identical to the syntax used for the Transaction Selection Pattern parameter.
Values can be selected from the list or typed.
 
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 Transactions select Transaction ID followed by Transaction Start - Month, but for Transactions within Months select Transaction Start - Month followed by Transaction ID).
You can select up to 4 values for this parameter.
Fields you can select:
  • NULL (NULL)
  • Transaction Start - Date (LMRKDATE)
  • System ID (TASYSID)
  • Transaction ID (TATRNID)
  • Program Name (TAPGM1)
  • Transaction Start - Month (MONTH)
  • Transaction Start - Day of Week (DAY)
  • Transaction Start - Week of Year (WEEK)
  • Transaction Start - Quarter of Year (QTR)
  • Interval (IntervalTitle)
  • Classification (Classifier)
Measures
The data field(s) you want to aggregate. (for example - CPU Time)
You can select up to 10 values for this parameter.
Fields you can select:
  • NULL (NULL)
  • CPU Time (TACPURTM)
  • DL/I Request Count (TADLIRCT)
  • DL/I Request Time (TADLIWTM)
  • File Request Count (TAFCPRCT)
  • File Request Time (TAFCPRTM)
  • File Request Wait Time (TAFCPWTM)
  • DB2 Non-SQL Request Time (TANSQCTM)
  • DB2 Non-SQL Request Count (TANSQCCT)
  • Response Time (TARSPTM)
  • DB2 SQL Request Time (TASQLCTM)
  • DB2 SQL Request Count (TASQLCCT)
  • Non-DB2 Request Count (TAUDBRCT)
  • Non-DB2 Request Time (TAUDBRTM)
  • Transaction Count (TATRANCT)
  • MAX CPU time (MAXTACPURTM)
  • MIN CPU time (MINTACPURTM)
  • AVG CPU time (AVGTACPURTM)
  • MAX response time (MAXTARSPTM)
  • MIN response time (MINTARSPTM)
  • AVG response time (AVGTARSPTM)
  • MAX Transactions Number per day (MAXTATRANCT)
  • MIN Transactions Number per day (MINTATRANCT)
  • AVG Transactions Number per day (AVGTATRANCT)
  • MAX Bucket Response Time (zrspmax)
  • MIN Bucket Response Time (ZRSPMIN)
  • 0.0-0.5 Sec. Count (ZRSPPER1)
  • 0.5-1.0 Sec. Count (zrspper2)
  • 1.0-2.0 Sec. Count (zrspper3)
  • 2.0-3.0 Sec. Count (zrspper4)
  • 3.0-4.0 Sec. Count (zrspper5)
  • 4.0-5.0 Sec. Count (zrspper6)
  • Over 5.0 Sec. Count (zrspper7)
  • % 0.0-0.5 Sec. (Bucket1Pct)
  • % 0.5-1.0 Sec. (Bucket2Pct)
  • % 1.0-2.0 Sec. (Bucket3Pct)
  • % 2.0-3.0 Sec. (Bucket4Pct)
  • % 3.0-4.0 Sec. (Bucket5Pct)
  • % 4.0-5.0 Sec. (Bucket6Pct)
  • % Over 5.0 Sec. (Bucket7Pct)
  • % Over 1.0 Sec. (BucketO1SPct)
  • % Under 1.0 Sec. (BucketU1SPct)
 
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
  • CPU Time (TACPURTM)
  • DL/I Request Count (TADLIRCT)
  • DL/I Request Wait Time (TADLIWTM)
  • File Request Count (TAFCPRCT)
  • File Request Time (TAFCPRTM)
  • File Request Wait Time (TAFCPWTM)
  • DB2 Non-SQL Request Time (TANSQCTM)
  • DB2 Non-SQL Request Count (TANSQCCT)
  • Response Time (TARSPTM)
  • DB2 SQL Request Time (TASQLCTM)
  • DB2 SQL Request Count (TASQLCCT)
  • Non-DB2 Request Count (TAUDBRCT)
  • Non-DB2 Request Time (TAUDBRTM)
  • Transaction Count (TATRANCT)
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 as output in an Excel file. Possible values are:
  • None - No chart will be created
  • Element Comparison Upper Level - One chart will be created, comparing the measure field values for the first summary level
  • Element Comparison 2 Levels - One chart will be created for the first summary level, and an additional chart will be created comparing the measure fields for the second summary level within each one of the first summary level values.
Assume that you selected 2 Group By fields - System ID and Transaction ID. If you select the Upper Level chart - only one chart will be created - showing all the measures for each one of the Systems selected in your report.
If you select the 2 Levels option - in addition to the chart mentioned above - you will get a chart showing the measures for each transaction within each one of the Systems selected in your report
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 Upper Level - One chart will be created, comparing the measure field values for the first summary level
  • Element Comparison 2 Levels - One chart will be created for the first summary level, and an additional chart will be created comparing the measure fields for the second summary level within each one of the first summary level values.
Assume that you selected 2 Group By fields - System ID and Transaction ID. If you select the Upper Level chart - only one chart will be created - showing all the measures for each one of the Systems selected in your report.
If you select the 2 Levels option - in addition to the chart mentioned above - you will get a chart showing the measures for each transaction within each one of the Systems selected in your report
Values can be selected from the list of allowed values.
Predefined Values:
  • Element Comparison - 2 Levels (Bar)
  • Element Comparison - Upper Level (Bar2)
  • None (NULL) - This value is selected by default
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)