IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

OLDS frozen in BACKOUT status when Online Reorg is running.


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
lind sh

New User


Joined: 04 Feb 2015
Posts: 32
Location: Tajikestan

PostPosted: Tue Feb 13, 2018 7:12 pm
Reply with quote

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
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 64
Location: Victoria, BC, Canada

PostPosted: Tue Feb 13, 2018 10:29 pm
Reply with quote

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
View user's profile Send private message
lind sh

New User


Joined: 04 Feb 2015
Posts: 32
Location: Tajikestan

PostPosted: Wed Feb 14, 2018 8:32 pm
Reply with quote

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
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 64
Location: Victoria, BC, Canada

PostPosted: Tue Feb 20, 2018 3:00 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Running REXX through JOB CLIST & REXX 13
No new posts Job completes in JES, but the status ... IBM Tools 1
No new posts Reorg abended with REASON=X'00E40347' DB2 2
No new posts Running a Job with the Default User ID JCL & VSAM 2
No new posts Error while running web tool kit REXX... CLIST & REXX 5
Search our Forums:

Back to Top