on 08-14-2007 9:29 PM
Dear Gurus
I'm searching a program that show me the Database Growth month in 46C with AS/400 and DB2/400.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.