INTENDED USE:
To rank all or selected links in ascending or descending
order based on response times or character traffic
volumes. The user chooses the number of links 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 links having high traffic
volume or response time.
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, SLULINK, Data Range, and Zone or Zone by
Hour.
INQUIRY ID:
SNTLD8 - Link w/in zone
SNTLD9 - Link w/in hour
DATA SOURCE (File/Timespan):
SNTNLL01 - Days
DATA ELEMENTS USED:
DURATION, SLULINK, NLLAVTTM, NLLTRESC, NLLTRSMN, NLLTOTSN,
NLLTSTRC, NLLTOTTR, NLLTCTMN, NLLAVCHS, NLLAVCHR, CURRENT,
NLLAVCHT, NLLNRPIS, NLLNRPIR, NLLNRPIT, NLLAVLMN, RANKLBL,
NLLAVPIU, NETWRKID, SYSID, DATA, ZONE, DATE, TIME, IQ,
RANKELEM
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(Derive vars & data select) */;
RETAIN DATEA DATEB;
LENGTH DATEA DATEB 4.;
IF SLULINK NE ' ' 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.);
CALL SYMPUT('S',DATA);
%GLOBAL S;
DROP DATEA DATEB;
END;
IF SLULINK NE ' '; /*DROP LOCALLY ATTACHED*/
/* Data Summarization */
%MACRO NEGATE;
DATA=SYMGET('S');
%MEND NEGATE;
;
/* 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 (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 (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 (NLLTRSMN) */;
FORMAT NLLTRSMN SCALE4.;
LABEL NLLTRSMN="TRANSACTIONS PER MINUTE";
NLLTRSMN = .;
DURMINS=(DURATION/60);
IF DURMINS GT 0 THEN NLLTRSMN = NLLTRESC/DURMINS;
;
/* Data Element Derivation (NLLTOTSN) */;
FORMAT NLLTOTSN SCALE4.;
LABEL NLLTOTSN="TOTAL CHARACTERS SENT";
NLLTOTSN = SUM(NLLNRCBS,NLLNRTBS);
;
/* Data Element Derivation (NLLTOTRC) */;
FORMAT NLLTOTRC SCALE4.;
LABEL NLLTOTRC="TOTAL CHARACTERS RECEIVED";
NLLTOTRC = SUM(NLLNRCBR,NLLNRTBR);
;
/* Data Element Derivation (NLLTOTTR) */;
FORMAT NLLTOTTR SCALE4.;
LABEL NLLTOTTR="TOTAL CHARACTERS TRANSMITTED";
NLLTOTTR = SUM(NLLNRCBR,NLLNRTBR,NLLNRCBS,NLLNRTBS);
;
/* Data Element Derivation (NLLTCTMN) */;
FORMAT NLLTCTMN SCALE4.;
LABEL NLLTCTMN="AVG CHARACTERS TRANSMITTED PER MINUTE";
NLLTCTMN = .;
IF DURATION GT 0 THEN NLLTCTMN =
SUM(NLLNRCBR,NLLNRTBR,NLLNRCBS,NLLNRTBS) / (DURATION/60);
;
/* Data Element Derivation (NLLAVCHS) */;
FORMAT NLLAVCHS SCALE4.;
LABEL NLLAVCHS="AVERAGE CHARACTERS SENT";
NLLAVCHS = .;
NLLNRFSR=SUM(NLLNRCBS,NLLNRTBS);
IF NLLTRESC GT 0 THEN NLLAVCHS=NLLNRFSR/NLLTRESC;
;
/* Data Element Derivation (NLLAVCHR) */;
FORMAT NLLAVCHR SCALE4.;
LABEL NLLAVCHR="AVERAGE CHARACTERS RECEIVED";
NLLAVCHR = .;
NLLNRFRE=SUM(NLLNRCBR,NLLNRTBR);
IF NLLTRESC NE 0 THEN NLLAVCHR=NLLNRFRE/NLLTRESC;
;
/* Data Element Derivation (NLLAVCHT) */;
FORMAT NLLAVCHT SCALE4.;
LABEL NLLAVCHT="AVERAGE TOTAL CHARACTERS TRANSMITTED";
NLLAVCHT = .;
NLLTOCTR=SUM(NLLNRCBS,NLLNRTBS,NLLNRCBR,NLLNRTBR);
IF NLLTRESC NE 0 THEN NLLAVCHT=NLLTOCTR/NLLTRESC;
;
/* Data Element Derivation (NLLNRPIS) */;
FORMAT NLLNRPIS SCALE4.;
LABEL NLLNRPIS="TOTAL PIUs SENT";
NLLNRPIS = SUM(NLLNRTPS,NLLNRCPS);
;
/* Data Element Derivation (NLLNRPIR) */;
FORMAT NLLNRPIR SCALE4.;
LABEL NLLNRPIR="TOTAL PIUs RECEIVED";
NLLNRPIR = SUM(NLLNRTPR,NLLNRCPR);
;
/* Data Element Derivation (NLLNRPIT) */;
FORMAT NLLNRPIT SCALE4.;
LABEL NLLNRPIT="TOTAL PIUs TRANSMITTED";
NLLNRPIT = SUM(NLLNRTPR,NLLNRTPS,NLLNRCPR,NLLNRCPS);
;
/* Data Element Derivation (NLLAVPIU) */;
FORMAT NLLAVPIU SCALE4.;
LABEL NLLAVPIU="AVERAGE PIUS PER/RESPONSE";
NLLAVPIU = .;
NLLNRPIU=SUM(NLLNRTPR,NLLNRTPS,NLLNRCPR,NLLNRCPS);
IF NLLTRESC GT 0 THEN NLLAVPIU=NLLNRPIU/NLLTRESC;
;
/* Data Element Derivation (NLLAVPMN) */;
FORMAT NLLAVPMN SCALE4.;
LABEL NLLAVPMN="AVG PIUs TRANSMITTED PER MINUTE";
NLLAVPMN = .;
TOTPIUS=SUM(NLLNRTPR,NLLNRTPS,NLLNRCPR,NLLNRCPS);
DURMINS=(DURATION/60);
IF DURMINS GT 0 THEN NLLAVPMN=TOTPIUS/DURMINS;
;
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 (SNTLD8) DAILY LINK RANKING BY ZONE FIRST 10 LINKS BY DESCENDING AVERAGE TOTAL RESPONSE TIME NETWORK ID: NETWORK1 SYSTEM ID: SYSA DATA RANGE: 22JULyy-01APRyy ZONE: 2 |-IDENTIFICATION--||- RESP INFORMATION -|------------------------------ WORKLOAD INFORMATION --------------------------------| |DURATION(HH:MM) /||AVG TOTAL RATE |------- TOTAL CHARS ------|----- AVG CHARS -----|---- TOTAL PIUS ---|--- PIUS PER --| | LINK NAME ||RESP RESPS / MIN |SENT RECVD TRANS / MIM| SENT RECVD TRANS |SENT RECVD TRANS| / MIN / RESP | ================= ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ====== 5:00 L063V378 1.67 4 0 63 1K 1K 5 15 421 437 21 21 42 0 10 0:00 L141016 1.65 2 2 0 0 0 0 0 0 0 0 0 0 0 0 5:01 L491V874 1.37 7 0 177 4K 5K 17 25 709 734 59 59 118 0 16 5:01 L071V039 0.49 12 0 186 4K 5K 17 15 413 428 62 62 124 0 10 5:00 L083V198 0.31 8 0 42 1K 1K 4 5 147 152 14 14 28 0 3 0:45 N002NPAL . 0 0 2 18K 18K 413 0 0 0 1 48 49 1 0 0:30 N003NPAL . 0 0 0 3K 3K 101 0 0 0 0 21 21 0 0 0:45 N004NPAL . 0 0 2 23K 23K 532 0 0 0 1 56 57 1 0 0:45 N005NPAL . 0 0 0 22K 22K 495 0 0 0 0 143 143 3 0 0:45 N006NPAL . 0 0 0 5K 5K 120 0 0 0 0 38 38 0 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=NLLAVTTM=AVERAGE TOTAL RESPONSE TIME RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NLL
2 (SNTLD8) DAILY LINK RANKING BY ZONE FIRST 10 LINKS BY DESCENDING AVERAGE TOTAL RESPONSE TIME NETWORK ID: NETWORK1 SYSTEM ID: SYSB DATA RANGE: 22JULyy-01APRyy ZONE: 1 |-IDENTIFICATION--||- RESP INFORMATION -|------------------------------ WORKLOAD INFORMATION --------------------------------| |DURATION(HH:MM) /||AVG TOTAL RATE |------- TOTAL CHARS ------|----- AVG CHARS -----|---- TOTAL PIUS ---|--- PIUS PER --| | LINK NAME ||RESP RESPS / MIN |SENT RECVD TRANS / MIM| SENT RECVD TRANS |SENT RECVD TRANS| / MIN / RESP | ================= ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ===== ====== 67:02 CC000067 7.73 60 0 46K 2K 49K 12 782 43 826 169 243 412 0 6 50:55 CC000002 3.97 1K 0 161K 9K 170K 55 109 6 115 874 1K 1K 0 1 10:36 CC000096 2.97 547 0 30K 2K 32K 51 55 4 60 107 126 233 0 0 12:58 CC000035 2.78 685 0 0 0 0 0 0 0 0 0 0 0 0 0 46:10 0C14 2.76 1K 0 196K 23K 219K 79 195 22 217 766 1K 2K 0 2 16:28 0A15 2.68 386 0 137K 75K 212K 214 355 194 550 606 1K 1K 1 4 77:42 0A16 2.48 1K 0 440K 14K 455K 97 307 10 317 1K 1K 2K 0 1 1:45 0A26 2.44 278 2 0 0 0 0 0 0 0 0 0 0 0 0 17:23 0A19 2.39 908 0 35K 5K 40K 39 38 6 45 93 146 239 0 0 20:27 0C10 2.33 424 0 54K 14 54K 44 127 0 127 131 131 262 0 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=NLLAVTTM=AVERAGE TOTAL RESPONSE TIME RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NLL
Figure 3-
|
Copyright © 2014 CA.
All rights reserved.
|
|