cancel
Showing results for 
Search instead for 
Did you mean: 

check Database Growth

Former Member
0 Kudos

Dear Gurus

I'm searching a program that show me the Database Growth month in 46C with AS/400 and DB2/400.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

On our system we have a scheduled job that runs the CL command RTVDSKINF each day. This collects info on disk usage. You can specify an ASP if needed.

We then have a separate scheduled job to produce output as follows:

PRTDSKINF RPTTYPE(OBJ) OBJ(ALL) MINSIZE(5000)

This gives a report on object with a minimum size of 5000. The minsize keyword is optional, and is specified in thousands of bytes. SO the above would get you a list of objects approximately 5 MEG in size or larger (5000000 bytes). You would set such a limit to exclude extremely small files from the list.

You can also get info on folders and libraries, if you have additional needs.

PRTDSKINF RPTTYPE(*FLR)

PRTDSKINF RPTTYPE(*LIB)

Good luck

Brian

Former Member
0 Kudos

hi Luis

You can always use DB02 to see the DB total DB size as well as see the tables with the largest growth..and other related info...

Or from AS400...you can use the "GO DISKTASKS" and collect the info about the various libraries on the system.

Thanks

Abhi