Hi all,
I'm new here posting question for the first time.
I'm working on an I V6R1 and currently planning a reorganize on a huge file (>500GB). It is a log file, PF with 1 member, 1 LF (1 member as well).
I tried restored a copy of the file to another library and perform reorg with LOCK *EXCL. The process took 12 hours and it's not a time frame that allowed (for downtime).
I'm aware that I can use LOCK *SHRUPD, which in case RGZPFM cannot obtain an exclusive lock, it will not purge the deleted record. So can I confirm that, even with *SHRUPD, it still need to have exclusive lock to the file (for a small amount of time)?
1. My question is that how can I know how short is the time frame? Is there any way to estimate that or else how should I handle that (this file log transaction record thus I can't tell when will it be used)?
2. Beside that, if the REORG can obtain exclusive lock and proceed to purge the deleted record, and at this moment if any program try to access the PF will hit error?
Another additional question is, in what situation I need to specify RBDACCPTH *YES, *NO or **OPTIMIZE? what are their impact?
Thank you.
I'm new here posting question for the first time.
I'm working on an I V6R1 and currently planning a reorganize on a huge file (>500GB). It is a log file, PF with 1 member, 1 LF (1 member as well).
I tried restored a copy of the file to another library and perform reorg with LOCK *EXCL. The process took 12 hours and it's not a time frame that allowed (for downtime).
I'm aware that I can use LOCK *SHRUPD, which in case RGZPFM cannot obtain an exclusive lock, it will not purge the deleted record. So can I confirm that, even with *SHRUPD, it still need to have exclusive lock to the file (for a small amount of time)?
1. My question is that how can I know how short is the time frame? Is there any way to estimate that or else how should I handle that (this file log transaction record thus I can't tell when will it be used)?
2. Beside that, if the REORG can obtain exclusive lock and proceed to purge the deleted record, and at this moment if any program try to access the PF will hit error?
Another additional question is, in what situation I need to specify RBDACCPTH *YES, *NO or **OPTIMIZE? what are their impact?
Thank you.
Comment