Joined: 04 Feb 2015 Posts: 30 Location: Tajikestan
When we reorganize some HALDB database partitions (of our IMSV11,DBCTL mode) , some partitions REORGed but a locking keep the reorganization progress and OLP's state changed to BACKOUT one after another. There is not any more activity about online reorganization.
How can I resolve the problem?
I uses /TERMINATE OLREORG , /SWITVH OLDS and . . . Also I stopped the region that makes the deadlock but no any thing happen and it seems the OLDS and archiving process is frozen.
Is it any way to releasing or making it possible to running archive log to continue?
Joined: 17 Dec 2007 Posts: 57 Location: Victoria, BC, Canada
Is your DBCTL region waiting for an available OLDS?
Does it produce a message "WAITING FOR ONLINE LOG" every minute?
If yes, then your DBCTL region will not accept any commands.
So your /TERMINATE OLREORG and /SWITCH OLDS commands will not be processed.
You will need to run a batch DSPURX00 job to create log archive JCL and submit it for execution. The JCL will look much like this example, but you will need to tailor it for your own IMS RESLIB, DFSMDA dataset, model JCL dataset and shop standards.