-
Notifications
You must be signed in to change notification settings - Fork 6
/
ewpfrx_pgfltovr.sql
41 lines (41 loc) · 1.04 KB
/
ewpfrx_pgfltovr.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
/* Page faults overview */
INSERT INTO EWPFR.FLTRATOVR (
SELECT
INTNUM as "Interval",
timestamp('20' || substring(a.CSDTETIM,2,2) ||'-'|| substring(a.CSDTETIM,4,2) ||'-'||substring(a.CSDTETIM,6,2) ||' '|| substring(a.CSDTETIM,8,2) ||':'||substring(a.CSDTETIM,10,2) ||':'||substring(a.CSDTETIM,12,2)) AS "Date-Time",
CASE
WHEN INTSEC = 0
THEN 0
ELSE round(FLTTOTAL/INTSEC ,2)
END AS "Faults Per Second",
FLTTOTAL as "Total Page Faults",
CASE
WHEN INTSEC = 0
THEN 0
ELSE round(PENDFLTTOTAL/INTSEC ,2)
END AS "I/O Pending Faults Per Second",
PENDFLTTOTAL as "I/O Total Pending Faults"
FROM
(
SELECT
QSY.DTETIM AS DTETIM,
QSY.DTECEN AS DTECEN,
QSY.INTNUM,
QSY.INTSEC,
QSY.DTECEN || QSY.DTETIM AS CSDTETIM,
SUM(DOUBLE(QMI.JBTFLT)) AS FLTTOTAL,
SUM(DOUBLE(QMI.JBIPF)) AS PENDFLTTOTAL
FROM
EWPFR.QAPMJOBMIX QMI
INNER JOIN
EWPFR.QAPMSYSTEMX QSY
ON
QMI.INTNUM = QSY.INTNUM
GROUP BY
QSY.INTNUM,
QSY.DTETIM,
QSY.DTECEN,
QSY.INTSEC
) A
ORDER BY
"Date-Time");