Service level analysis graph
This topic describes how to use only CA records only to create PRL graph report.
Member | CMRPRL7 |
|---|---|
Objective | to graphically represent service levels as defined by CMRSOPT and collected by BMC AMI Ops Monitor for CICS |
Data | Service Level Analysis records (Type CA) from the CMRSTATS file Each record contains 18 service level counts. This data is collected only if LTX= is set to more than 0 in CMRSOPT. |
Scenario | BMC AMI OpsM for CICS produces service level records according to what is set in the LTX SMF parameter in CMRSOPT. CMRSOPT has 17 default service levels defined, ranging from half a second to 90 seconds. In addition, an extra service level is kept, recording response times greater than 90 seconds. The ranges of values in the various service levels can be changed through the customization macro CMRSOPT and CMRSOPT administrative view. A different recording frequency can be specified on the Service Level Analysis field of the PERFORMANCE REPORTER Statistics File Recording Frequencies screen. Note that the transaction counts only involve transactions that run at terminals and are, therefore, not biased by fast asynchronous transactions. The control statements shown in Service level analysis PRL statements show how service levels can be represented. The example in Service level analysis PRL statements is not intended to cover instances where there has been no activity whatsoever. Thus, the WHERE clause presumes that this time frame is idle when there has been no activity in the first three LTX values. If this assumption is incorrect for your site, repeat the OR clause with LTX004, LTX005, and so on as far as is necessary. The LTX fields in the FOR loop in the above example are represented by as many asterisks (*) as needed by substringing field BB. If there are more than 50 asterisks (*), the plus (+) is added. If you have a lot of asterisks (*) in your report, increase the frequency of CA records on the file by reducing the interval between records through transaction FIC2 or by dividing the transaction count by a scaling factor. Each line containing the LTX values and their graphical representation is then printed. Ideally, the chart shows a high percentage of transactions appearing in the first service level, with the frequency rapidly diminishing as the higher service level buckets are reached. Any activity above the ninth or tenth service level slot, with a response time of seven seconds or more, is cause for concern. At this point, the time and date from the 6E records can be noted for a detailed analysis. |
SET REPORTID = 'PRL7'
SET TITLE = 'S E R V I C E L E V E L A N A L Y S I S'
SET WIDTH = '86'
SET LINES = '43'
DEFINE NUMTRAN EDIT Z,ZZZ,ZZ9
DEFINE NUMSTAR EDIT 99999999999999
SET BB = '|***************************************************+'
SET GRAPHS = '|....5....10...15...20...25...30...35...40...45...50'
SET GRAPH = ' '
READ:
SELECT TYPE CA RECORDS FROM CMRSTATS
WHERE CMRDATE = '09/17/2007'
AND LTX001 > 0
OR LTX002 > 0
OR LTX003 > 0
USING CMRDATE -
CMRTIME
PRINT ' '
PRINT CMRDATE CMRTIME ' ' GRAPHS
PRINT ' RESPONSE COUNT | (SCALE = 1 : 5 (ROUNDED))'
FOR &IX = 001 TO 018
COMPUTE NUMSTAR = LTX(&IX) / 5
COMPUTE NUMSTAR = NUMSTAR + 1
IF LTIM(&IX) = 0 THEN SET LTIM(&IX) = ' 100.000'
IF NUMSTAR > 51 THEN BEGIN
COMPUTE NUMSTAR = 52
END;
SET STARS = BB(1:&NUMSTAR)
COMPUTE NUMTRAN = LTX(&IX)
PRINT LTIM(&IX) NUMTRAN STARS
NEXT &IX
GOTO READ
REPORT
END
As shown in the report in the following figure, the CMRDATE and CMRTIME field contents are reported when the REPORT statement is processed. The headings, RESPONSE, COUNT, and the scale are printed when the PRINT statement is processed. Enclosing a character string in single quotation marks defines the characters to be printed. To print the value of the variable, specify a defined variable, not enclosed in single quotation marks, with PRINT.
Service level analysis output
TIME: 12:10:56
DATE: 09/17/1999
PAGE: 1
RECORDED RECORDED
DATE TIME
-------- --------
09/17/1999 15:59:00 |....5....10...15...20...25...30...35...40...45...50
RESPONSE COUNT | (SCALE = 1 : 5 (ROUNDED))
0.500 4,687 |**************************************************+
1.000 281 |**************************************************+
1.500 153 |*******************************
2.000 123 |*************************
2.500 36 |*******
3.000 5 |*
4.000 2 |
5.000 2 |
6.000 2 |
7.000 4 |*
8.000 2 |
9.000 2 |*
10.000 3 |**
20.000 12 |
30.000 0 |
60.000 0 |
90.000 0 |
34359.738 0 |
Related topic