INTENDED USE:
To rank all or selected application and link combinations
in ascending or descending order based on response times
or character traffic volumes. The user chooses the number
of applications 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 applications by link having high traffic volumes
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, PLU, Range, and Zone or Zone by Hour.
INQUIRY ID:
SNTLDQ - Application/Link w/in zone
SNTLDR - Application/Link w/in hour
DATA SOURCE (File/Timespan):
SNTNPL - Days
DATA ELEMENTS USED:
SLULINK, PLU, NPLAVTTM, NPLAVHTM, NPLAVNTM, NPLNRTRE,
RANGE, NPLTRESC, NPLTRSMN, NPLPCNTM, NPLTOTSN, NPLTOTRC,
NPLTOTTR, NPLAVCHS, NPLAVCHR, NPLAVCHT, NPLAVPIU, RANKLBL,
NETWRKID, SYSID, DATA, ZONE, DATE, TIME, CURRENT, 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 (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 4.2;
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 (SNTLDQ) DAILY NPM APPLICATION/LINK RANKING BY ZONE FIRST 10 APPLICATIONS BY DESCENDING AVERAGE TOTAL RESPONSE TIME NETWORK ID: NETWORK1 SYSTEM ID: SYS1 DATA RANGE: 04OCTyy-04OCTyy ZONE: 1 |-IDENTIFICATION--||------------------ RESPONSE INFORMATION ------------------| |------------- WORKLOAD INFORMATION -------------| |LINK NAME / ||---- AVG TIME ----| NOT IN TOTAL RATE % WITH| |--- TOTAL CHARS ---|----- AVG CHARS ----| PIUS /| |APPLICATION NAME ||TOTAL HOST NET | RANGE RANGE RESPS / MIN NET TM| |SENT RECVD TRANS| SENT RECVD TRANS| RESP | ================= ===== ===== ===== ====== ======= ===== ===== ====== ===== ===== ===== ===== ===== ===== ====== L12131 DISOSS20 5.70 5.70 0.00 83 0.0-5.0 153 3.48 0.00% 7K 13K 20K 48 88 137 2.02 L2A001 TSO0046 4.87 0.94 3.92 2 0.0-5.0 10 0.23 100.0% 7K 211 7K 710 21 732 3.80 L12031 CHRSDC2 4.86 2.98 1.89 14 0.0-5.0 224 3.82 99.55% 361K 15K 377K 1K 70 1K 2.04 L12046 CHRSDC2 3.78 2.35 1.44 22 0.0-5.0 123 2.49 100.0% 139K 9K 149K 1K 77 1K 2.72 L12023 CHRSDC2 3.66 1.87 1.78 29 0.0-5.0 145 2.16 100.0% 198K 8K 206K 1K 59 1K 2.65 L12141 DISOSS20 3.55 3.55 0.00 16 0.0-5.0 36 2.11 0.00% 35K 3K 39K 987 107 1K 2.86 L2A178 TSO0025 3.27 1.57 1.69 9 0.0-5.0 67 0.89 100.0% 57K 1K 59K 862 24 887 2.21 L2A178 TSO0020 3.22 1.65 1.57 10 0.0-5.0 78 1.40 100.0% 87K 1K 89K 1K 20 1K 2.19 L12027 ISSA1 3.09 3.09 0.00 2 0.0-5.0 5 4.05 0.00% 3K 102 3K 679 20 699 5.00 L2A178 TSO0024 2.74 1.07 1.67 6 0.0-5.0 51 0.93 100.0% 46K 927 47K 914 18 932 2.16 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.
|
|