INTENDED USE:
To rank all or selected applications 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 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, Data Range, and Zone or Zone by
Hour.
INQUIRY ID:
SNTLD0 - Application w/in zone
SNTLD1 - Application w/in hour
DATA SOURCE (File/Timespan):
SNTPSY - Days
DATA ELEMENTS USED:
DURATION, PLU, PSYAVTTM, PSYAVHTM, PSYAVNTM, PSYNRTRE,
RANGE, PSYTRESC, PSYTRSMN, PSYPCNTM, PSYTOTSN, PSTTOTRC,
PSYTOTTR, PSYAVCHS, PSYAVCHR, PSYAVCHT, PSYAVPIU, TIME,
NETWRKID, SYSID, DATA, ZONE, RANKELEM, RANKLBL, DATE,
CURRENT, 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 (Derived vars & data select) */;
RETAIN DATEA DATEB;
LENGTH DATEA DATEB 4.;
DATEA = MIN(DATEA,STARTTS);
DATEB=MAX(DATEB,ENDTS);
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;
/* 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 (PSYPCNTM) */;
LENGTH PSYPCNTM $6;
FORMAT PSYPCNTM $CHAR6.;
LABEL PSYPCNTM="% Responses With Network Time";
PSYPCNTM = ' %';
PCTTNETM=(100.0-PSYPCNON);
SUBSTR(PSYPCNTM,1,5)=PUT(PCTTNETM,5.2);
IF PCTTNETM = . THEN SUBSTR(PSYPCNTM,6,1)=' ';
;
/* Data Element Derivation (DURATION, elapsed time) */;
FORMAT DURATION TIME5.2;
LABEL DURATION="ENDTS - STARTTS";
DURATION = ENDTS-STARTTS;
;
/* Data Element Derivation (PSYTRSMN) */;
FORMAT PSYTRSMN SCALE4.;
LABEL PSYTRSMN="Transactions Per Minute";
PSYTRSMN = .;
DURMINS=(DURATION/60);
IF DURMINS GT 0 THEN PSYTRSMN=PSYTRESC/DURMINS;
;
/* Data Element Derivation (PSYTOTSN) */;
FORMAT PSYTOTSN 4.;
LABEL PSYTOTSN="Total Characters Sent";
PSYTOTSN = SUM(PSYNRFMS,PSYNRNFS);
;
/* Data Element Derivation (PSYTOTRC) */;
FORMAT PSYTOTRC 4.;
LABEL PSYTOTRC="Total Characters Received";
PSYTOTRC = SUM(PSYNRFMR,PSYNRNFR);
;
/* Data Element Derivation (PSYTOTTR) */;
FORMAT PSYTOTTR 4.;
LABEL PSYTOTTR="Total Characters Transmitted";
PSYTOTTR = SUM(PSYNRFMR,PSYNRNFR,PSYNRFMS,PSYNRNFS);
;
/* Data Element Derivation (PSYAVCHS) */;
FORMAT PSYAVCHS 4.;
LABEL PSYAVCHS="AVERAGE CHARACTERS SENT";
PSYAVCHS = .;
PSYNRFSR=SUM(PSYNRFMS,PSYNRNFS);
IF PSYTRESC GT 0 THEN PSYAVCHS=PSYNRFSR/PSYTRESC;
;
/* Data Element Derivation (PSYAVCHR) */;
FORMAT PSYAVCHR 4.;
LABEL PSYAVCHR="AVERAGE CHARACTERS RECEIVED";
PSYAVCHR = .;
PSYNRFRE=SUM(PSYNRFMR,PSYNRNFR);
IF PSYTRESC NE 0 THEN PSYAVCHR=PSYNRFRE/PSYTRESC;
;
/* Data Element Derivation (PSYAVCHT) */;
FORMAT PSYAVCHT 4.;
LABEL PSYAVCHT="AVERAGE TOTAL CHARACTERS TRANSMITTED";
PSYAVCHT = .;
PSYTOCTR=SUM(PSYNRFMR,PSYNRNFR,PSYNRFMS,PSYNRNFS);
IF PSYTRESC NE 0 THEN PSYAVCHT=PSYTOCTR/PSYTRESC;
;
/* Data Element Derivation (PSYAVPIU) */;
FORMAT PSYAVPIU SCALE4.;
LABEL PSYAVPIU="AVERAGE PIUS PER/RESPONSE";
PSYAVPIU = .;
PSYNRPIU=SUM(PSYNRPFS,PSYNRPFR);
IF PSYTRESC GT 0 THEN PSYAVPIU=PSYNRPIU/PSYTRESC;
;
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 (SNTLD0) DAILY NPM APPLICATION 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 -------------| |ELAPSED(HH:MM) / ||---- 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 | ================= ===== ===== ===== ====== ======= ===== ===== ====== ===== ===== ===== ===== ===== ===== ====== 0:43 TSO0046 4.87 0.94 3.92 2 0.0-5.0 10 0 100.0% 7K 211 7K 710 21 732 3 0:58 DISOSS20 3.70 3.70 0.00 101 0.0-5.0 283 4 0.00% 261K 55K 317K 924 196 1K 3 1:15 TSO0025 3.27 1.57 1.69 9 0.0-5.0 67 0 100.0% 57K 1K 59K 862 24 887 2 0:55 TSO0020 3.22 1.65 1.57 10 0.0-5.0 78 1 100.0% 87K 1K 89K 1K 20 1K 2 0:54 TSO0024 2.74 1.07 1.67 6 0.0-5.0 51 0 100.0% 46K 927 47K 914 18 932 2 0:59 TSO0038 2.72 1.44 1.28 29 0.0-5.0 216 3 100.0% 177K 4K 181K 822 19 841 2 0:55 TSO0022 2.50 0.78 1.72 0 0.0-5.0 6 0 100.0% 8K 91 8K 1K 15 1K 2 1:02 CHRSDC1 2.50 1.70 0.80 7 0.0-5.0 59 0 100.0% 61K 1K 62K 1K 20 1K 2 1:07 TSO0005 2.34 1.07 1.27 4 0.0-5.0 27 0 100.0% 23K 732 23K 853 27 880 2 1:07 VTP03 1.92 0.82 1.09 134 0.0-5.0 3K 48 74.13% 1M 64K 1M 591 19 611 2 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=PSYAVTTM=AVERAGE TOTAL RESPONSE TIME RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=PSY
Figure 3-
|
Copyright © 2014 CA.
All rights reserved.
|
|