Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

When to RGZPFM?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    When to RGZPFM?

    We've incorporated a number of Jim's TAAtools into our production environment. His RGZLIB works very effectively, and has a number of useful parameters. We run it once a month in a scheduled cleanup job. Old guys rule!

    Comment


    • #17
      When to RGZPFM?

      Sloan also had a tool called RGZPF... The prompt is for library and % deleted records in the file. This is a great tool, as programers will continue to add files and forget to add them to the "hard coded" cleanup/purge programs. It also eliminates the "hard coding" of files that may not have many deleted records, but may have 60+ logicals, and the RGZ will lock the file for many hours. In the case of not having enough time, I took the "Jim Sloan" DLTDEPLGL utility and modified it. Now it will delete the dependant logicals, do my RGZ, then read the outfile again to (SBMJOB) re-create my logicals in a multi thread JOBQ. This finishes must faster, as RGZPFM rebuilds the access paths in a single thread fashion.

      Comment


      • #18
        When to RGZPFM?

        Thanks Thull for the info..we do have TAATOOLS and sounds like your approach will work here.

        Comment


        • #19
          When to RGZPFM?

          Just wondering if anyone has an automated process for reorganizing physical files? For example, reorg when the % of deleted records is ??% of the 'live' records. I'm interested in pursuing something like this, but I'm not sure what the correct/most efficient calculation would be. Thanks.

          Comment


          • #20
            When to RGZPFM?

            Remember if you have an n way iSeries to ensure to use SMP if you have it installed by using CHGQRYA DEGREE(*MAX), this will allocate all possible resources to the RGZPFM process. Please beware, this will consume multiple processors and perform significant I/O so plan accordingly, it will definately speed up the RGZPFM process. Let me know how you get on ! Regards, TheiSpecialist.com

            Comment

            Working...
            X