Re: something using up DASD

["M. Lazarus" <mlazarus@xxxxxxxx>]

Jim,

At 10/13/03 01:58 PM, you wrote:
> Since we upgraded our operating system from V4R5 to V5R2.........our DASD
> used keeps on climbing.  Can anyone tell me where to look for files that the
> system maybe using that can be cleared?  Is there something running that we
> do not need to be running that is using up disk space?  This is on an
> ISeries 730, we have 154.6G of DASD and currently 92.2575 % is used up.

 Do you have any SQLRPG jobs running?  There seems to be a bug in the 
optimizer that doesn't allow the pgm do reuse the ODP (for SQLRPG pgms 
created on older releasees), so a new ODP keeps on getting created for each 
iteration of the SQL statements.  This is especially problematic if the 
optimizer decides that a copy of the file is the most efficient way of 
processing the file.

 There is at least one APAR open addressing it, but IBM won't commit to 
fixing it quickly.  This bug has actually delayed upgrading our production 
box from 5.1 to 5.2 and is wreaking havoc with our planning.

 -mark

 -mark