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:
SNTLD4 - Link w/in zone
SNTLD5 - Link w/in hour
DATA SOURCE (File/Timespan):
SNTNPL - Days
DATA ELEMENTS USED:
DURATION, SLULINK, NPLAVTTM, NPLAVHTM, NPLAVNTM, NPLNRTRE,
RANGE, NPLTRESC, NPLTRSMN, NPLPCNTM, NPLTOTSN, NPLTOTRC,
NPLTOTTR, NPLAVCHS, NPLAVCHR, NPLAVCHT, NPLAVPIU, DATE,
NETWRKID, SYSID, DATA, ZONE, RANKELEM, RANKLBL, CURRENT,
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(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 (RANGE) */;
LENGTH RANGE $7;
FORMAT RANGE $CHAR7.;
LABEL RANGE="LOW-HI TOTAL RESPONSE THRESHOLD";
RANGE = ' ';
SUBSTR(RANGE,1,3)=PUT(NPMLOTOT,3.1);
SUBSTR(RANGE,4,1)='-';
SUBSTR(RANGE,5,3)=PUT(NPMHITOT,3.1);
;
/* 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 (NPLPCNTM) */;
LENGTH NPLPCNTM $6;
FORMAT NPLPCNTM $CHAR6.;
LABEL NPLPCNTM="% Responses With Network Time";
NPLPCNTM = ' %';
PCTTNETM=(100.0-NPLPCNON);
SUBSTR(NPLPCNTM,1,5)=PUT(PCTTNETM,5.2);
IF PCTTNETM = . THEN SUBSTR(NPLPCNTM,6,1)=' ';
;
/* Data Element Derivation (DURATION, elapsed time) */;
FORMAT DURATION TIME5.2;
LABEL DURATION="ENDTS - STARTTS";
DURATION = ENDTS-STARTTS;
;
/* Data Element Derivation (NPLTRSMN) */;
FORMAT NPLTRSMN SCALE4.;
LABEL NPLTRSMN="TRANSACTIONS PER MINUTE";
NPLTRSMN = .;
DURMINS=(DURATION/60);
IF DURMINS GT 0 THEN NPLTRSMN=NPLTRESC/DURMINS;
;
/* Data Element Derivation (NPLTOTSN) */;
FORMAT NPLTOTSN 4.;
LABEL NPLTOTSN="TOTAL CHARACTERS SENT";
NPLTOTSN = SUM(NPLNRFMS,NPLNRNFS);
;
/* Data Element Derivation (NPLTOTRC) */;
FORMAT NPLTOTRC 4.;
LABEL NPLTOTRC="TOTAL CHARACTERS RECEIVED";
NPLTOTRC = SUM(NPLNRFMR,NPLNRNFR);
;
/* Data Element Derivation (NPLTOTTR) */;
FORMAT NPLTOTTR 4.;
LABEL NPLTOTTR="TOTAL CHARACTERS TRANSMITTED";
NPLTOTTR = SUM(NPLNRFMR,NPLNRNFR,NPLNRFMS,NPLNRNFS);
;
/* Data Element Derivation (NPLAVCHS) */;
FORMAT NPLAVCHS 4.;
LABEL NPLAVCHS="AVERAGE CHARACTERS SENT";
NPLAVCHS = .;
NPLNRFSR=SUM(NPLNRFMS,NPLNRNFS);
IF NPLTRESC GT 0 THEN NPLAVCHS=NPLNRFSR/NPLTRESC;
;
/* Data Element Derivation (NPLAVCHR) */;
FORMAT NPLAVCHR 4.;
LABEL NPLAVCHR="AVERAGE CHARACTERS RECEIVED";
NPLAVCHR = .;
NPLNRFRE=SUM(NPLNRFMR,NPLNRNFR);
IF NPLTRESC NE 0 THEN NPLAVCHR=NPLNRFRE/NPLTRESC;
;
/* Data Element Derivation (NPLAVCHT) */;
FORMAT NPLAVCHT 4.;
LABEL NPLAVCHT="AVERAGE TOTAL CHARACTERS TRANSMITTED";
NPLAVCHT = .;
NPLTOCTR=SUM(NPLNRFMR,NPLNRNFR,NPLNRFMS,NPLNRNFS);
IF NPLTRESC NE 0 THEN NPLAVCHT=NPLTOCTR/NPLTRESC;
;
/* Data Element Derivation (NPLAVPIU) */;
FORMAT NPLAVPIU SCALE4.;
LABEL NPLAVPIU="AVERAGE PIUS PER/RESPONSE";
NPLAVPIU = .;
NPLNRPIU=SUM(NPLNRPFS,NPLNRPFR);
IF NPLTRESC GT 0 THEN NPLAVPIU=NPLNRPIU/NPLTRESC;
;
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 (SNTLD4) DAILY NPM LINK RANKING BY ZONE FIRST 10 LINKS BY DESCENDING AVERAGE TOTAL RESPONSE TIME NETWORK ID: NETWORK1 SYSTEM ID: SYS1 DATA RANGE: 04OCTyy-04OCTyy ZONE: 1 |-IDENTIFICATION--||------------------ RESPONSE INFORMATION ------------------| |------------- WORKLOAD INFORMATION -------------| |ELAPSED(HH:MM) / ||---- AVG TIME ----| NOT IN TOTAL RATE % WITH| |--- TOTAL CHARS ---|----- AVG CHARS ----| PIUS /| | LINK NAME ||TOTAL HOST NET | RANGE RANGE RESPS / MIN NET TM| |SENT RECVD TRANS| SENT RECVD TRANS| RESP | ================= ===== ===== ===== ====== ======= ===== ===== ====== ===== ===== ===== ===== ===== ===== ====== 0:43 L12131 5.70 5.70 0.00 83 0.0-5.0 153 3 0.00% 7K 13K 20K 48 88 137 2 0:58 L12031 4.86 2.98 1.89 14 0.0-5.0 224 3 99.55% 361K 15K 377K 1K 70 1K 2 1:07 L12023 3.66 1.87 1.78 29 0.0-5.0 145 2 100.0% 198K 8K 206K 1K 59 1K 2 0:17 L12141 3.55 3.55 0.00 16 0.0-5.0 36 2 0.00% 35K 3K 39K 987 107 1K 2 1:04 L12046 3.46 2.12 1.34 30 0.0-5.0 184 2 90.22% 195K 11K 206K 1K 59 1K 2 0:01 L12027 3.09 3.09 0.00 2 0.0-5.0 5 4 0.00% 3K 102 3K 679 20 699 5 1:35 L2A178 2.81 1.39 1.43 58 0.0-5.0 460 4 100.0% 440K 11K 451K 957 24 981 3 0:22 L12189 2.53 1.37 1.17 4 0.0-5.0 42 1 16.67% 46K 1K 47K 1K 24 1K 4 0:43 L12163 2.40 2.40 0.00 2 0.0-5.0 11 0 0.00% 77K 1K 78K 7K 99 7K 7 1:07 L2A001 2.27 0.83 1.44 81 0.0-5.0 1K 22 90.84% 1M 32K 1M 679 20 700 2 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=NPLAVTTM=AVERAGE TOTAL RESPONSE TIME RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NPL
Figure 3-
|
Copyright © 2014 CA.
All rights reserved.
|
|