Re: Monitoring IFS objects for deletion at V5R4

On 06-Sep-2011 11:40 , rob@xxxxxxxxx wrote:

What's a few GB among friends?
SELECT sum(ODOBSZ)
FROM routines/dskdtl
WHERE odobnm like 'ZAUD%'

SUM ( ODOBSZ )
250,664,271,872

Anyone referring to the above should keep in mind that use of ODOBSZ has been deprecated for many years and OS releases. The ODOBSZ column text has long suggested that for "Object size: 9,999,999,999=Use ODSIZU*ODBPUN"; the general recommendation is to use that expression irrespective of the value of ODOBSZ. Using ODOBSZ is especially undesirable for the object type *JRNRCV, like for the database *FILE, both being object types which can match or exceed 10GB; i.e. SUM(ODOBSZ) may provide undesirable results if objects of those types are included in the aggregate. Thus more appropriately:

select sum(odsizu*odbpun) from qtemp/qadspobj

Or perhaps:

with
szgb (ss) as ( select dec( dec( sum( odsizu*odbpun ), 13 )
/ (1024**3), 9, 3 )
from qtemp/qadspobj )
select char( repeat(' ', 12-length(strip(ss,b)) )
concat ss concat 'GB', 14) as "Total Size"
from szgb

Regards, Chuck