zOs/SQL/REOTSPRF
---------+---------+---------+---------+---------+---------+---------+---------+
with p as
(
select
case when REORGUNCLUSTINS > TOTALROWS * 0.1 then 'u' else ' ' end
||case when REORGNEARINDREF+REORGFARINDREF >TOTALROWS * 0.1
then 'i' else ' ' end
|| case when REORGDeletes > TOTALROWS * 0.25 then 'd' else ' ' end
|| case when SPACE > DATASIZE / 512.0 then 's' else ' ' end
|| case when reorgMassDelete > 0 then 'm' else ' ' end
|| case when reorgClusterSens> 0 then 'c' else ' ' end prfOrig,
case when REORGUNCLUSTINS > TOTALROWS * 0.1 then 'u' else ' ' end
||case when REORGNEARINDREF+REORGFARINDREF >TOTALROWS * 0.1
then 'i' else ' ' end
|| case when REORGDeletes > TOTALROWS * 0.25 then 'd' else ' ' end
|| case when SPACE > DATASIZE / 512.0 then 's' else ' ' end
|| case when reorgMassDelete > 0 then 'm' else ' ' end
|| case when reorgClusterSens> 0
and REORGUNCLUSTINS > TOTALROWS * 0.1 then 'c' else ' ' end
prfFix ,
case when dataSize >= 0 and dataSize
< real(nActive) * pgSize * 0.1024 * pctLoad * swdatasize
then 'ds0' else ' ' end dsN,
s.*
from s100447.VReoTs s
where crTb like 'OA1P.T%'
)
select smallint(importance) imp, substr(reason, 1, 8) reason,
min(dsN) || '-' || max(dsN) dsN,
prfOrig, prfFix,
count(distinct strip(db) ||'.' || strip(ts)) ts,
count(*) parts
from p
group by importance, substr(reason, 1, 8), prfFix, prfOrig,
case when importance <= 0 then dsN else '' end
order by 1, 2, 3, 4, 5
;;;;
---------+---------+---------+---------+---------+---------+---------+---------+
IMP REASON DSN PRFORIG PRFFIX TS PARTS
---------+---------+---------+---------+---------+---------+---------+---------+
-1 no - ts ds0-ds0 s s 3 3
-1 no - ts ds0-ds0 s c s 1 1
0 no - reo - 155 1203
0 no - reo - c 417 1739
0 no - reo - mc m 2 2
0 no - reo - s s 254 935
0 no - reo - s c s 485 1834
0 no - reo - smc sm 1 1
0 no - reo - d d 4 4
0 no - reo - d c d 29 43
0 no - reo - d mc d m 3 3
0 no - reo - ds ds 3 12
0 no - reo - ds c ds 34 88
0 no - reo - dsmc dsm 2 2
0 no - reo ds0-ds0 s s 2126 21825
0 no - reo ds0-ds0 s c s 2566 8364
0 no - reo ds0-ds0 sm sm 1 1
0 no - reo ds0-ds0 smc sm 22 22
0 no - reo ds0-ds0 ds ds 70 181
0 no - reo ds0-ds0 ds c ds 472 1532
0 no - reo ds0-ds0 dsm dsm 10 10
0 no - reo ds0-ds0 dsmc dsm 81 134
0 no - reo ds0-ds0 i s c i s 4 7
0 no - reo ds0-ds0 ids c ids 1 1
0 no - reo ds0-ds0 u s u s 2 2
0 no - reo ds0-ds0 u s c u s c 8 20
0 no - reo ds0-ds0 u ds u ds 7 9
0 no - reo ds0-ds0 u ds c u ds c 22 31
0 no - reo ds0-ds0 u dsmc u dsmc 1 1
3 clusterR - 3 27
3 clusterR - c 13 85
3 clusterR -ds0 s s 2 107
3 clusterR -ds0 s c s 8 45
3 lastBuil - 11 20
3 lastBuil - c 2 6
3 lastBuil - d d 9 26
3 lastBuil - d c d 1 1
3 lastBuil - u u 1 1
3 lastBuil -ds0 s s 76 835
3 lastBuil -ds0 s c s 17 26
3 lastBuil -ds0 ds ds 23 929
3 lastBuil -ds0 ds c ds 2 8
3 lastBuil ds0-ds0 sm sm 4 4
5 nearIndR - ds c ds 1 1
5 nearIndR -ds0 s c s 4 4
5 nearIndR ds0-ds0 i s i s 1 1
5 nearIndR ds0-ds0 i s c i s 2 2
5 pagesave - 1 5
5 pagesave - c 1 1
5 pagesave - mc m 1 1
5 pagesave - d d 2 2
5 pagesave ds0-ds0 ds ds 1 6
5 rtsMissi - 397 937
5 rtsNull - 4 4
5 rtsRowsN - 6 6
5 unclust - u u 3 6
5 unclust - u c u c 2 2
5 unclust -ds0 u s c u s c 5 5
5 unclust ds0-ds0 u s u s 2 6
5 unclust ds0-ds0 u sm u sm 1 1
5 unclust ds0-ds0 u smc u smc 1 1
5 unclust ds0-ds0 u ds u ds 7 107
5 unclust ds0-ds0 u ds c u ds c 8 8
DSNE610I NUMBER OF ROWS DISPLAYED IS 63