NetView Link Service/Workload Ranking

To rank all or selected links in ascending or descending order based on response times or character traffic volumes.
mics142
The user chooses the number of links ranked, the order of ranking, and the variable used to rank on. The NetView Link Service/Workload Ranking 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
MICS
reports do.

NetView Link Service/Workload Ranking Sample 1

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

NetView Link Service/Workload Ranking Sample 2

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