INTENDED USE:
To rank all or selected NetView performance classes in
ascending or descending order based on response times or
character traffic volumes. The user chooses the number of
performance classes ranked, the order of ranking, and the
variable used to rank on. The report provides both
response and workload information that can be used to
identify performance classes having high traffic volume or
response times.
FORMAT:
A 17 column report approximately 132 characters wide. It
is best suited for hardcopy review but can be reviewed
online. The information is summarized and presented by
NETWRKID, SYSID, PERFCLSS, Data Range, and Zone or Zone by
Hour.
INQUIRY ID:
SNTLDC - PCLASS w/in zone
SNTLDD - PCLASS w/in hour
DATA SOURCE (File/Timespan):
NVSNSA/NVSRTM - Days
DATA ELEMENTS USED:
DURATION, SNTACT4, RTMAVTTM, OBJECTIV, RTMNRRNR, RTMTRSMN,
RTMPCOBS, RTMPCOBT, RTMTRESC, SAMPLES, NSATOTSN, NSATOTRC,
NSATOTTR, NSAACVHS, NSAAVCHR, NSAAVCHT, NSAAVPIU, SYSID,
NETWRKID, DATA, ZONE, RANKELEM, RANKLBL, CURRENT, DATE,
TIME, IQ
CALCULATIONS:
/* Data Element Derivation (DATE) */;
FORMAT DATE DATE7.;
LABEL DATE="Date Selection Field";
DATE = DATEPART(ENDTS);
;
/* Data Element Derivation (TIME) */;
FORMAT TIME TIME11.2;
LABEL TIME="Time Selection Field";
TIME = TIMEPART(ENDTS);
;
/* Data Element Derivation (DATA) */;
LENGTH DATA $15;
FORMAT DATA $CHAR15.;
LABEL DATA="DATA RANGE";
DATA = ' ';
/* SAS System Statements (Load DATA Variable) */;
RETAIN DATEA DATEB;
LENGTH DATEA DATEB 4.;
IF SESTYPE =:'LU-LU' THEN DO;
DATEA = MIN(DATEA,STARTTS);
DATEB = MAX(DATEB,ENDTS);
END;
IF _EOF_ THEN DO;
DATEA=DATEPART(DATEA);
DATEB=DATEPART(DATEB);
SUBSTR(DATA,1,7)=PUT(DATEA,DATE7.);
SUBSTR(DATA,8,1)='-';
SUBSTR(DATA,9,7)=PUT(DATEB,DATE7.);
DROP DATEA DATEB;
CALL SYMPUT('S',DATA);
%GLOBAL S;
END;
IF SESTYPE =:'LU-LU';
/* Data Summarization */
%MACRO NEGATE;
DATA=SYMGET('S');
%MEND NEGATE;
;
/* Data Element Derivation (IQ, &I) */;
LENGTH IQ $8;
FORMAT IQ $CHAR8.;
LABEL IQ="INQUIRE NAME";
IQ = ' ';
SUBSTR(IQ,1,1)='(';
SUBSTR(IQ,2,6)=SYMGET('INQINAME');
SUBSTR(IQ,8,1)=')';
CALL SYMPUT('I',PUT(IQ,$CHAR8.));
%GLOBAL I;
;
/* Data Element Derivation (CURRENT, &C) */;
FORMAT CURRENT WEEKDATE15.;
LABEL CURRENT="CURRENT DATE";
CURRENT = TODAY();
C=PUT(CURRENT,WEEKDATE15.);
C=COMPRESS(C) ;
CALL SYMPUT('C',PUT(C,$CHAR12.));
%GLOBAL C;
;
/* Data Element Derivation (OBJECTIV) */;
LENGTH OBJECTIV $12;
FORMAT OBJECTIV $CHAR12.;
LABEL OBJECTIV="X PERCENT OF RESPONSE WITHIN XX SECONDS";
OBJECTIV = ' . ';
IF RTMPCOBJ GE 0 OR RTMROBTM GE 0 THEN DO;
SUBSTR(OBJECTIV,1,3)=PUT(RTMPCOBJ,3.);
SUBSTR(OBJECTIV,4,4)='% < ';
SUBSTR(OBJECTIV,8,5)=PUT(RTMROBTM,4.1);
END;
;
/* Data Element Derivation (RANKELEM) */;
FORMAT RANKELEM 8.;
LABEL RANKELEM="&RL";
RANKELEM = &RANKELEM;
;
/* Data Element Derivation (RANKLBL) */;
LENGTH RANKLBL $40;
FORMAT RANKLBL $CHAR40.;
LABEL RANKLBL="LABEL OF RANKING ELEMENT";
RANKLBL = SYMGET('RL');
;
/* Data Element Derivation (RTMPCOBS) */;
LENGTH RTMPCOBS $4;
FORMAT RTMPCOBS $CHAR4.;
LABEL RTMPCOBS="% MET OF SAMPLED";
RTMPCOBS = ' . ';
IF RTMPCOBM GE 0 THEN DO;
SUBSTR(RTMPCOBS,1,3)=PUT(RTMPCOBM,3.);
SUBSTR(RTMPCOBS,4,1)='%';
END;
;
/* Data Element Derivation (RTMPCOBT) */;
LENGTH RTMPCOBT $4;
FORMAT RTMPCOBT $CHAR4.;
LABEL RTMPCOBT="% MET OF TOTAL";
RTMPCOBT = ' . ';
IF RTMPCTR4 GE 0 THEN DO;
SUBSTR(RTMPCOBT,1,3)=PUT(RTMPCTR4,3.);
SUBSTR(RTMPCOBT,4,1)='%';
END;
;
/* Data Element Derivation (RTMTRSMN) */;
FORMAT RTMTRSMN SCALE4.;
LABEL RTMTRSMN="TRANSACTIONS PER MINUTE";
RTMTRSMN = .;
DURMINS=(DURATION/60);
IF DURMINS GT 0 THEN
RTMTRSMN=RTMTRESC/DURMINS;
;
/* Data Element Derivation (NSATOTSN) */;
FORMAT NSATOTSN SCALE4.;
LABEL NSATOTSN="TOTAL CHARACTERS SENT";
NSATOTSN = SUM(NSANRCBS,NSANRTBS);
;
/* Data Element Derivation (NSATOTRC) */;
FORMAT NSATOTRC SCALE4.;
LABEL NSATOTRC="TOTAL CHARACTERS RECEIVED";
NSATOTRC = SUM(NSANRCBR,NSANRTBR);
;
/* Data Element Derivation (NSATOTTR) */;
FORMAT NSATOTTR SCALE4.;
LABEL NSATOTTR="TOTAL CHARACTERS TRANSMITTED";
NSATOTTR = SUM(NSANRCBR,NSANRTBR,NSANRCBS,NSANRTBS);
;
/* Data Element Derivation (NSAAVCHS) */;
FORMAT NSAAVCHS SCALE4.;
LABEL NSAAVCHS="AVERAGE CHARACTERS SENT";
NSAAVCHS = .;
NSANRFSR=SUM(NSANRCBS,NSANRTBS);
IF RTMTRESC GT 0 THEN NSAAVCHS=NSANRFSR/RTMTRESC;
;
/* Data Element Derivation (NSAAVCHR) */;
FORMAT NSAAVCHR SCALE4.;
LABEL NSAAVCHR="AVERAGE CHARACTERS RECEIVED";
NSAAVCHR = .;
NSANRFRE=SUM(NSANRCBR,NSANRTBR);
IF RTMTRESC NE 0 THEN NSAAVCHR=NSANRFRE/RTMTRESC;
;
/* Data Element Derivation (NSAAVCHT) */;
FORMAT NSAAVCHT SCALE4.;
LABEL NSAAVCHT="AVERAGE TOTAL CHARACTERS TRANSMITTED";
NSAAVCHT = .;
NSATOCTR=SUM(NSANRCBS,NSANRTBS,NSANRCBR,NSANRTBR);
IF RTMTRESC NE 0 THEN NSAAVCHT=NSATOCTR/RTMTRESC;
;
/* Data Element Derivation (NSAAVPIU) */;
FORMAT NSAAVPIU SCALE4.;
LABEL NSAAVPIU="AVERAGE PIUS PER/RESPONSE";
NSAAVPIU = .;
NSANRPIU=SUM(NSANRTPR,NSANRTPS,NSANRCPR,NSANRCPS);
IF RTMTRESC GT 0 THEN NSAAVPIU=NSANRPIU/RTMTRESC;
;
/* Data Element Derivation (RTMNRRNR) */;
FORMAT RTMNRRNR SCALE4.;
LABEL RTMNRRNR="NUMBER OF RESPONSES NOT IN RANGE";
RTMNRRNR = .;
RTMNRRNR=(RTMTRESC-RTMNRROM);
;
USAGE CONSIDERATIONS:
All cycles are summarized together as a data range rather
than reporting by individual cycle or by year, month, day,
and hour as other CA MICS reports do.
1 (SNTLDC) DAILY PERFORMANCE CLASS RANKING BY ZONE FIRST 10 PERFORMANCE CLASSES BY DESCENDING AVERAGE TOTAL RESPONSE TIME NETWORK ID: NETWORK1 SYSTEM ID: SYSA DATA RANGE: 23JULyy-01APRyy ZONE: 2 |-IDENTIFICATION--||------------------- RESPONSE INFORMATION --------------------|------------- WORKLOAD INFORMATION -------------| |DURATION(HH:MM) /||AVG RESPONSE MISSED RATE |- % MET OF -|-- TOTAL # --|--- TOTAL CHARS ---|----- AVG CHARS ----| PIUS /| |PERFORMANCE CLASS||RESP OBJECTIVE OBJ / MIN |SAMP TOTAL |RESP SAMPLES|SENT RECVD TRANS| SENT RECVD TRANS| RESP | ================= ===== ============ ===== ===== ==== ==== ===== ===== ===== ===== ===== ===== ===== ===== ====== 0:04 DEFAULT 0.85 85% < 5.0 27 8 100% 100% 33 6 44K 7M 7M 1K 234K 235K 686 0:00 . . 0 0 . . 0 1 4 76 80 0 0 0 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=RTMAVTTM=AVERAGE TOTAL RESPONSE TIME RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NSA/RTM
2 (SNTLDC) DAILY PERFORMANCE CLASS RANKING BY ZONE FIRST 10 PERFORMANCE CLASSES BY DESCENDING AVERAGE TOTAL RESPONSE TIME NETWORK ID: NETWORK1 SYSTEM ID: SYSB DATA RANGE: 23JULyy-01APRyy ZONE: 1 |-IDENTIFICATION--||------------------- RESPONSE INFORMATION --------------------|------------- WORKLOAD INFORMATION -------------| |DURATION(HH:MM) /||AVG RESPONSE MISSED RATE |- % MET OF -|-- TOTAL # --|--- TOTAL CHARS ---|----- AVG CHARS ----| PIUS /| |PERFORMANCE CLASS||RESP OBJECTIVE OBJ / MIN |SAMP TOTAL |RESP SAMPLES|SENT RECVD TRANS| SENT RECVD TRANS| RESP | ================= ===== ============ ===== ===== ==== ==== ===== ===== ===== ===== ===== ===== ===== ===== ====== 0:30 BIMS 31.0 95% < 4.0 5 0 0% 40% 5 2 0 0 0 0 0 0 0 5:23 TIMS 4.21 95% < 4.0 160 0 46% 94% 172 26 58K 56K 114K 339 326 666 3 3:09 RIMS 2.71 95% < 4.0 179 1 78% 99% 193 18 52K 68K 120K 271 353 624 3 92:13 LIMS 2.23 95% < 4.0 4K 0 70% 99% 4K 384 481K 201K 683K 97 40 137 0 12:20 TCC 2.11 95% < 4.0 710 1 72% 98% 754 61 1M 636K 1M 1K 844 2K 8 53:42 BDTSO 1.81 95% < 4.0 12K 3 55% 98% 12K 264 15M 1M 16M 1K 93 1K 9 34:09 SUPER 1.78 95% < 4.0 3K 1 55% 98% 3K 139 1M 26K 1M 358 6 365 1 1:15 PDTSO 1.56 95% < 4.0 181 2 40% 96% 183 5 277K 2K 279K 1K 13 1K 5 1:49 ALLOTH 0.94 95% < 5.0 289 2 82% 100% 298 11 6M 1M 8M 22K 4K 27K 99 2:17 AIMS 0.94 95% < 4.0 151 1 100% 99% 161 10 10K 2K 13K 65 16 81 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=RTMAVTTM=AVERAGE TOTAL RESPONSE TIME RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NSA/RTM
Figure 3-
|
Copyright © 2014 CA.
All rights reserved.
|
|