View previous topic :: View next topic
|
Author |
Message |
lind sh
New User
Joined: 04 Feb 2015 Posts: 32 Location: Tajikestan
|
|
|
|
Dear Friends
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?
|
|
Back to top |
|
|
Gary Jacek
New User
Joined: 17 Dec 2007 Posts: 66 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.
Code: |
//STEP01 EXEC PGM=DSPURX00,REGION=3000K
//*
//STEPLIB DD DISP=SHR,DSN=IMS.RESLIB
//IMSDALIB DD DISP=SHR,DSN=IMS.DFSMDA
//JCLPDS DD DISP=SHR,DSN=IMS.GENJCL
//SYSABEND DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
GENJCL.ARCHIVE MAXOLDS(01) SSID(____) MEMBER(ARCHJCL)
/*
//*
//JCLOUT DD SYSOUT=(A,INTRDR),
// DCB=(RECFM=FB,LRECL=80,BLKSIZE=6240)
//* |
|
|
Back to top |
|
|
lind sh
New User
Joined: 04 Feb 2015 Posts: 32 Location: Tajikestan
|
|
|
|
Mr.Gary Jacek
DBCTL region accepted command "/DISPLAY OLDS" so I saw the OLDS status. But there is no any activity in response to "/TERMINATE OLREORG" and "/SWITCH OLDS" commands. |
|
Back to top |
|
|
Gary Jacek
New User
Joined: 17 Dec 2007 Posts: 66 Location: Victoria, BC, Canada
|
|
|
|
Lind sh
You don't offer any more details from the display command.
Could you capture the output and paste it here? |
|
Back to top |
|
|
|