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
 

 

Tablespace in CHECK PENDING status..

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

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Thu Jan 02, 2014 6:45 pm    Post subject: Tablespace in CHECK PENDING status..
Reply with quote

Hi,

If the tablespace is in CHECK PENDING status. the below 2 commands if executed, will it reset the CHECKPENDING status to normal?


Code:

REPAIR OBJECT                                 
  SET TABLESPACE DB01.TS01 NOCOPYPEND 


START DATABASE(DB01) SPACENAM(TS01) ACCESS(RW)


Please advise

Thanks
Back to top
View user's profile Send private message

chandan.inst

Active User


Joined: 03 Nov 2005
Posts: 269
Location: Mumbai

PostPosted: Thu Jan 02, 2014 6:51 pm    Post subject:
Reply with quote

What happened when you tried these commands?

Reagrds,
Chandan
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Thu Jan 02, 2014 6:52 pm    Post subject:
Reply with quote

Would suggest talk to DBA first and understand why it is in check pending status.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jan 02, 2014 7:09 pm    Post subject:
Reply with quote

Hello,

As PB suggests, you need to understand how/why the tablespace got into a CHECK PENDING status.

These should NOT just be reset . . .
Back to top
View user's profile Send private message
Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Thu Jan 02, 2014 7:39 pm    Post subject:
Reply with quote

Hi Dick ,

There is referential integrity constraints which we are facing while loading the table. I want to know if the start database command alone will reset these flags or we need to explicitely give the repair commands for reseting the CKP and COPY pending flags for the tablespace.

I understand that explicitely resetting the flags may cause data inconsistency but again this is the need of the hour.

Thanks,
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Thu Jan 02, 2014 8:31 pm    Post subject:
Reply with quote

Quote:
I understand that explicitely resetting the flags may cause data inconsistency but again this is the need of the hour.



Bad idea for me .... Did you let your DBA know about your approach icon_wink.gif ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jan 02, 2014 8:40 pm    Post subject:
Reply with quote

Yup, i concur. . .

I understand it might be expedient, but may cause surprises later.

Suggest proper prevention/correction be implemented soon so the possibility of this causing problems later will be minimized.

My main concern is that when the quick way is used for a while, it is tougher to correct it later . . .
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 685
Location: Earth

PostPosted: Fri Jan 03, 2014 12:51 am    Post subject:
Reply with quote

Code:
NOCOPYPEND 

option will not reset CHECKPENDING flag. You will need to use NOCHECKPEND option.

Code:
ACCESS(RW)
will not reset the flag either. You will need to use ACCESS(FORCE) to reset any COPY/CHECK pending flags.

Either one of the approaches is sufficient. There is no need to use both.
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 What is the command to check MODE of ... rohanthengal CLIST & REXX 6 Fri Nov 18, 2016 1:48 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts How to resolve IMS DB status code FM Priyanka Boga IMS DB/DC 3 Fri Jun 10, 2016 1:54 pm
No new posts JCL to fetch schedule status from act... parasmalik20 CA Products 1 Thu Jun 02, 2016 7:11 pm
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am


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