Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

CLRPFM with a 2 membered large file

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

  • schwinck@pbssite.com
    replied
    CLRPFM with a 2 membered large file

    Change the logical file that accesses both members to MAINT(*DLY) or MAINT(*REBLD) to delay the access path maintenance until the next time the logical file is opened.

    Leave a comment:


  • CserAndras2
    replied
    CLRPFM with a 2 membered large file

    I have a file with 2 members: one is small (about 500.000 records) the other one is huge (over 50.000.000 records, the size is over 35 GB). When I use CLRPFM command to clear the small member, it takes a lot of time (45 minutes) to complete. The same CLRPFM over the small member performs fast if the other member is also small or empty. Has anybody experienced a similar issue? Is there any solution or workaround?

    Leave a comment:


  • Colin Grierson
    replied
    CLRPFM with a 2 membered large file

    It is the maintenance of the logical that accesses both members that is the problem. When one member is cleared the access path has to be rebuilt. Clearing the small member leaves a 50,000,000 record rebuild.

    Leave a comment:


  • Guest's Avatar
    Guest replied
    CLRPFM with a 2 membered large file

    My guess is that the system maint. on the logicals is why it takes so long.

    Leave a comment:


  • CserAndras2
    replied
    CLRPFM with a 2 membered large file

    Yes, there are severel logical files over both members, even I have a logical file which accesses both members.

    Leave a comment:


  • Guest's Avatar
    Guest started a topic CLRPFM with a 2 membered large file

    CLRPFM with a 2 membered large file

    Are there logical views over that file/member?
Working...
X