Skip to Content
avatar image
Former Member

check Database Growth

Dear Gurus

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 14, 2007 at 11:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 15, 2007 at 06:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded