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

Tablespace in CHECK PENDING status..


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 275
Location: Mumbai

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

What happened when you tried these commands?

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

Global Moderator


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

PostPosted: Thu Jan 02, 2014 6:52 pm
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

Moderator Emeritus


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

PostPosted: Thu Jan 02, 2014 7:09 pm
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
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

Global Moderator


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

PostPosted: Thu Jan 02, 2014 8:31 pm
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

Moderator Emeritus


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

PostPosted: Thu Jan 02, 2014 8:40 pm
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: 691
Location: Earth

PostPosted: Fri Jan 03, 2014 12:51 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Sort card help to prepare status report DFSORT/ICETOOL 13
No new posts Control M features to check string in... Compuware & Other Tools 1
No new posts Numeric check w/SyncSort. SYNCSORT 1
No new posts FILE STATUS - 39 ON VARIABLE LENGTH V... COBOL Programming 2
No new posts DB2 tablespace space limitation DB2 3
Search our Forums:

Back to Top