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
 

 

DB2_admin question

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

New User


Joined: 24 Oct 2006
Posts: 32
Location: India

PostPosted: Tue Jan 29, 2008 12:29 pm    Post subject: DB2_admin question
Reply with quote

Production job got abended when trying to update a table because the table was in copy pending status.the problem was fixed.



But i need to know why the tablespace was in copypending status and the user and what caused it to go in copypending status?How can i find it?

I found it from stats table the load was done to that table but how can i confirme it
Back to top
View user's profile Send private message

acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Tue Jan 29, 2008 12:49 pm    Post subject:
Reply with quote

Try -DIS UTIL(*) in DB2 commands
Back to top
View user's profile Send private message
bbessa

New User


Joined: 03 Aug 2006
Posts: 13
Location: Brazil

PostPosted: Wed Jan 30, 2008 2:02 am    Post subject:
Reply with quote

Hi.

There's certain LOAD utility parameters that sets copypending status after the utility has ended, like: REPLACE when the table has data before the loading and RESUME YES. To avoid this, you can use the NOCOPYPEND parameter, define COPYDDN or SYSCOPY or run a separate COPY utility job on the table space after the LOAD.

Bernardo
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Wed Jan 30, 2008 10:59 am    Post subject:
Reply with quote

Its LOG YES option with LOAD that sets the copypending status after the utility has ended.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Jan 30, 2008 6:52 pm    Post subject:
Reply with quote

Srihari Gonugunta wrote:
Its LOG YES option with LOAD that sets the copypending status after the utility has ended.


WRONG
From the DB2 Utilities Manual

LOG Tells whether logging is to occur during the RELOAD phase of the load process.

YES Specifies normal logging during the load process. All records loaded are logged.
The default is YES. NO Specifies no logging of data during the load process. The NO option sets the COPY-pending restriction against the table space or partition that the loaded table resides in. No table or partition in the table space can be updated until the restriction is removed. For ways to remove the restriction, see "Resetting the COPY-pending status" in topic 2.12.4.2.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Wed Jan 30, 2008 8:15 pm    Post subject:
Reply with quote

Craq. Thanks for correcting me.
Back to top
View user's profile Send private message
ravi17s
Warnings : 1

New User


Joined: 15 Aug 2003
Posts: 57

PostPosted: Thu Jan 31, 2008 8:13 am    Post subject: Reply to: DB2_admin question
Reply with quote

Whenever DB2 thinks that its safe to copy the tables or TS after some utilities run it puts the TS in COpy Pending status to make recover possible.

Ex: Load Replace Log No,Reorg without Image Copy.......

Depending on the user's choice these pending status can be removed(Repair or Force Start the TS...) or Image Copy needs to run.

Thanks,
Ravishankar.V
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 QUESTION: RETURN CHANNEL pahiker CA Products 21 Thu Apr 20, 2017 12:31 am
No new posts The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Asynchronous CICS Processing Question moezbud CICS 1 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts Fault Analyzer - listings question. egrove IBM Tools 4 Thu Aug 11, 2016 5:31 pm


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