Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Clearing restrictive state

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Fri Jan 01, 2016 2:33 am    Post subject: Clearing restrictive state
Reply with quote

Hello,

We have a challenge in getting clean Image copy for all the test tablespaces in our test environment. Developers are running LOAD REPLACE and leaving many tablespaces on Copy pending and Check Pending states. Due to which our backup jobs are often failing with -904, Resource unavailable error. We are trying to set up something that identifies only the tablespaces with COPY pending and CHECK pending states and clear them because in our environment they are often caused by LOAD REPLACE.

I looked at Repair utility but that needs manual intervention to identify the tablespaces in restricted mode to use REPAIR SET command.

Does any of have run into similar situation? if so, could you please provide some ideas to solve my issue? We are trying to run Full copy twice in a week.

Please let me know should you have any questions.
Back to top
View user's profile Send private message

RahulG31

Active User


Joined: 20 Dec 2014
Posts: 331
Location: USA

PostPosted: Fri Jan 01, 2016 3:03 am    Post subject: Reply to: Clearing restrictive state
Reply with quote

I think the Developers need to modify the LOAD control statement.

Are they using the ENFORCE NO option in LOAD control statement? That may be the cause for check pending status.

And you can use NOCOPYPEND in the LOAD control statement so that there is no copy pending status.

.
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Fri Jan 01, 2016 10:19 am    Post subject:
Reply with quote

yeah, they use ENFORCE NO and LOG NO. I wish it was that simple to communicate and make them follow the standards. We have a large group of users in test region and it is hard to make them follow.

While in the prod it is clean, the support group runs NOCOPYPEND and NOCHECKPEND after the load, the development region is a bit messy.

Happy New Year!!
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 331
Location: USA

PostPosted: Fri Jan 01, 2016 10:51 am    Post subject: Reply to: Clearing restrictive state
Reply with quote

Wish you a very happy new year.

I believe the best thing is to avoid doing what is causing the problem.
Quote:
We are trying to set up something that identifies only the tablespaces with COPY pending and CHECK pending states and clear them

IMHO, this is not a good idea. Suppose, you were able to set up something like that and cleared all the copy/check pending status. But then, the very next second some user/developer runs the LOAD REPLACE and put the table in copy/check pending status. The purpose of setting up a procedure (to clear the pending status) will fail the very next second.

.
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Sat Jan 02, 2016 5:05 am    Post subject:
Reply with quote

I see what you are saying. The whole purpose of this is to get a good backup. We will run backup during non business hours and we believe developers won't be available at that time. Currently our dev environment does not have a backup system at all and that worries us even more.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Tablespace in UT state gylbharat DB2 11 Mon Feb 10, 2014 2:07 pm
No new posts Incase of any FTP error, Need to put ... Gurumanoj Gurusamy All Other Mainframe Topics 3 Mon Jan 30, 2012 12:06 am
No new posts Is there a way to find all volumes th... ananth86 JCL & VSAM 3 Mon Oct 25, 2010 12:07 pm
No new posts DB2 SQL Error Code -104 & State ... naveen_desireddy DB2 4 Fri Sep 24, 2010 12:31 pm
No new posts CEDF - the program goes to the wait ... shankarm CICS 2 Tue Aug 03, 2010 11:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us