Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
OLDS frozen in BACKOUT status when Online Reorg is running.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
lind sh

New User


Joined: 04 Feb 2015
Posts: 30
Location: Tajikestan

PostPosted: Tue Feb 13, 2018 7:12 pm    Post subject: OLDS frozen in BACKOUT status when Online Reorg is running.
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: 52
Location: Victoria, BC, Canada

PostPosted: Tue Feb 13, 2018 10:29 pm    Post subject:
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: 30
Location: Tajikestan

PostPosted: Wed Feb 14, 2018 8:32 pm    Post subject:
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: 52
Location: Victoria, BC, Canada

PostPosted: Tue Feb 20, 2018 3:00 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Image copy after Online reorganization. lind sh IMS DB/DC 0 Tue Jan 30, 2018 9:58 pm
No new posts Job is running with no response!!! Vignesh Sid DB2 3 Fri Oct 27, 2017 6:28 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us