RE: QADBIFLD

Al Mac,

The only way you should deal with this and related files is through the
use of RCLSTG *DBXREF on a dedicated system.  This is one of many files
(try looking for files in IBM libraries beginning with QADB*) which
index all database files on your entire system and their fields.  If you
regularly build and delete libraries which contain large numbers of
database files, then you should expect to find large numbers of deleted
records in the QADB* files.  This particular file lists all of the
fields in all of your database files in all of your libraries; it makes
sense that it would be rather large.  If you examine the related files,
you may find similar percentages of deleted records.

Your file size does not strike me as abnormally large, but it certainly
does represent a large percentage of a small system.  If you need that
100 MB back, you really have no alternative but to dedicate your system
and run the RCLSTG; use the *DBXREF parameter if you only wish to
rebuild the files.

Regards,
Andy Nolen-Parkhouse

> Subject: QADBIFLD
>
> 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)