Re: QADBIFLD

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

DANGER!! DANGER!! Leave it (them) alone. They are part of the system
catalog of all physical & logical files on the system, constantly updated
by the system. SQL views over these things are to be found in QSYS2.

At 12:16 AM 3/21/02 -0500, you wrote:
>This has probably come up before & possibly even I brought it up.
>Seems to me there are objects in QSYS like this one that manage to amass a
>large number of deleted records of significant size.
>
>What I desire is
>
>1. Some IBM menu option that I ought to run periodically to clean up these
>QSYS objects, like I have in my application management to clean up
>application objects.  It would be even better if GO CLEANUP or WRKSYSVAL
>could set some standard for cleaning them up regularly.
>
>2. Reminder what the heck this is for ... is there some way to adjust values
>of what it includes ... I am having trouble believing that any object needs
>to be that large ... to make it smaller, is that an application design issue?
>
>Our QADBIFLD in QSYS is currently
>188,890 good records
>22,407 deleted records
>record length 4,876
>meaning 110 meg bytes wasted by deleted records
>and 1 gig bytes total size of the file
>Am I estimating that math right?
>Our entire 400 is only 12 gig
>
>MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.