Guest_imported
New member
- Jan 1, 1970
- 0
In online reorg SHRLEVEL REFERENCE, how can we specify parameter for swapping all the concurrent users on the the tablespace that is being reorganized during SWITCH phase.
I hope in shrlevel change we can specify DRAIN ALL parametes so that this will drain allthe claimers during log / switch phase.
How can we drain all the claimers in SHRLEVEL REFERENCE?
When I am trying to run reorg using shrlevel reference my job is timed out. Exactly in the switch phase it was trying to drain all claimers, but the concurrent user querying on the same table that is being reorganized and the reorg waitiing for some time as specified by installation time and timed out.
I got the return code 00C9008E
Please let me know if any one experienced the same problem and how to solve this? I don't want to go for SHRLEVEL CHANGE since there will not be any update during our reorg job.
Thanks
Ganesh
I hope in shrlevel change we can specify DRAIN ALL parametes so that this will drain allthe claimers during log / switch phase.
How can we drain all the claimers in SHRLEVEL REFERENCE?
When I am trying to run reorg using shrlevel reference my job is timed out. Exactly in the switch phase it was trying to drain all claimers, but the concurrent user querying on the same table that is being reorganized and the reorg waitiing for some time as specified by installation time and timed out.
I got the return code 00C9008E
Please let me know if any one experienced the same problem and how to solve this? I don't want to go for SHRLEVEL CHANGE since there will not be any update during our reorg job.
Thanks
Ganesh