object size

[ramesh]

Hi All,

How to find the objects which are more than 200 Mb in AS/400?

[MichaelCatalani]

Re: object size

DSDOBJD to an outfile, then use sql or query to sort the outfile descending by size. ( ODOBSZ field )

[acmfaizer]

Re: object size

If you are to find out all objects in the machine. You may run PRTDSKINF command *LIB. This will produce a report of all libraries which are large in size. You may sort in object levels as well.
Note: In order to generate PRTDSKIN you need peroform RTVDSKINF in SBMJOB.

[FaStOnE]

Re: object size

Or, you could do Something like the following:

SELECT Substring( TabSchema, 1, 15 ) as Library,
       Substring( TabName, 1, 15 )   as Table,  
       Number_Rows, Data_Size                   
FROM QSYS2.SYSTABLESTAT                         
Order by Data_Size Desc

[gcraill]

Re: object size

@Rick - Not on V5R3 ya don't ...

[abercrombieande]

Re: object size

I am not familiar with the different OS versions. Maybe you can do this.

start QSH

Change the AHARTNE2.LIB to your library

find /QSYS.LIB/AHARTNE2.LIB/* -name \*MBR -size +204800