CLRPFM with a 2 membered large file (1 viewing) (1) Guest
Favoured: 0
|
|
|
TOPIC: CLRPFM with a 2 membered large file
|
|
|
|
CLRPFM with a 2 membered large file 1 Year, 4 Months ago
|
|
|
Are there logical views over that file/member?
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
CLRPFM with a 2 membered large file 1 Year, 4 Months ago
|
Karma: 0
|
|
Yes, there are severel logical files over both members, even I have a logical file which accesses both members.
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
CLRPFM with a 2 membered large file 1 Year, 4 Months ago
|
|
|
My guess is that the system maint. on the logicals is why it takes so long.
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
CLRPFM with a 2 membered large file 1 Year, 4 Months ago
|
Karma: 0
|
|
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.
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
CLRPFM with a 2 membered large file 1 Year, 3 Months ago
|
Karma: 0
|
|
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.
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
CLRPFM with a 2 membered large file 1 Year, 3 Months ago
|
Karma: 0
|
|
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. <p>Has anybody experienced a similar issue? Is there any solution or workaround?
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
|
