And one of the first things I thought of was "I bet there's some new SQL
service to list out the temporary storage". SYSTMPSTG does show some
promise. This is also mentioned in
http://ibmsystemsmag.com/Blogs/i-can/Archive/72-improved-temporary-storage-tracking-part-1-/
http://ibmsystemsmag.com/Blogs/i-can/Archive/72-improved-temporary-storage-tracking-part-2/
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajqviewsystmpstg.htm?lang=en-us
It's even on that pretty chart!
I have 14 buckets for *ENDED jobs.
select bucket_number, jobname, job_user_name,
job_number,
cast(bucket_current_size as dec(6, 0)) as current,
cast(bucket_peak_size as dec(9, 0)) as peak
from qsys2.systmpstg
where job_status='*ENDED'
order by bucket_current_size desc
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
BUCKET_NUMBER JOBNAME JOB_USER_NAME JOB_NUMBER CURRENT PEAK
66,260 QTOEJVA QSECOFR 312996 163,840 136,597,504
66,259 GDL1922 CRAIGS 318011 118,784 42,504,192
65,980 GDL1922 CRAIGS 320707 94,208 40,394,752
66,133 GDL1922 CRAIGS 836198 94,208 50,339,840
66,297 GDL1832 DARREN 814905 94,208 120,090,624
66,500 GDL1922 CRAIGS 843600 94,208 50,745,344
67,044 GDL1922 CRAIGS 833485 94,208 73,281,536
66,245 GDL1832 DARREN 550752 24,576 25,812,992
66,216 DSP010000 ROB 896991 16,384 129,626,112
66,965 QPADEV0009 ROB 896990 16,384 5,165,056
66,982 GDL177A1 TROYM 812449 16,384 3,993,600
66,370 ROBS3 ROB 393396 12,288 10,747,904
66,003 QUMECIMOM QSECOFR 307329 8,192 4,136,960
66,252 RCV_RQS MIMIXOWN 411237 4,096 29,253,632
But that only adds up to 851,968 bytes. So, not much by 'ended' jobs.
Let's really dive in.
select bucket_number, global_bucket_name,
jobname, job_user_name, job_number,
cast(bucket_current_size as dec(11, 0)) as current,
cast(bucket_peak_size as dec(11, 0)) as peak
from qsys2.systmpstg
order by bucket_current_size desc
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11....+...
BUCKET_NUMBER GLOBAL_BUCKET_NAME JOBNAME JOB_USER_NAME
JOB_NUMBER CURRENT PEAK
8 *DATABASE Segment Cache - - -
60,830,412,800 61,003,911,168
1 *MACHINE - - -
24,563,613,696 24,756,285,440
11 *DATABASE DS SQE LOB - - -
4,303,945,728 4,307,095,552
66,542 - QYPSJSVR QYPSJSVR
312389 2,675,363,840 2,676,277,248
9 *DATABASE SQE Heap - - -
1,858,883,584 1,858,883,584
66,020 - Q1ACPDST QBRMS 307346
1,316,442,112 1,316,741,120
4,099 *IPC - - -
977,068,032 1,010,655,232
66,421 - ADMIN2 QLWISVR
312635 456,323,072 456,323,072
66,510 - QZRCSRVS QUSER 959417
422,780,928 422,780,928
66,418 - ADMIN4 QWEBADMIN
312173 345,468,928 349,016,064
66,277 - HTTP QNOTES
930055 314,920,960 314,920,960
66,352 - HTTP QNOTES
929917 310,136,832 310,136,832
66,529 - ADMIN5 QLWISVR
312175 263,696,384 263,696,384
66,518 - ADMIN1 QLWISVR
312172 256,245,760 256,245,760
66,532 - ADMIN3 QLWISVR
312323 245,542,912 245,542,912
66,468 - DOTS QNOTES
930062 239,984,640 239,984,640
66,291 - DOTS QNOTES
929923 239,460,352 239,460,352
66,467 - SMDREAL QNOTES
930059 231,813,120 232,124,416
66,484 - SMDREAL QNOTES
929920 220,106,752 220,303,360
Ok, one bucket of temporary storage almost equal to the minimum load
source size for 7.2. What is this? I could guess but I'd rather not.
Rob Berendt
midrange.com
