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
 

 

Copy pending status occcus for many reasons?

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

New User


Joined: 15 Dec 2005
Posts: 21

PostPosted: Mon May 12, 2008 10:21 pm    Post subject: Copy pending status occcus for many reasons?
Reply with quote

Guys am getting confusions .. please help me out icon_sad.gif icon_sad.gif icon_sad.gif

I am learing manually about the load utility and copy pending stuff...

Right now i have some idea abouth that and the manuals really helps lot..

But here i have a basic doube PLease please help me ?


COPY PENDING status occurs

When we try to execute LOAD/UNLOAD utility

OR

When we try to execute the IMAGE COPY jcl to take image copy of the table sapce.


Thanks a Lot and i hope i may get the answers from u guys.
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: Mon May 12, 2008 11:27 pm    Post subject:
Reply with quote

Hello,

Yes, there are multiple ways for COPY PENDING to exist.

Please clarify your question if you are looking for other info.
Back to top
View user's profile Send private message
vijayprabu

New User


Joined: 15 Dec 2005
Posts: 21

PostPosted: Tue May 13, 2008 4:07 am    Post subject: Reply to: Copy pending status occcus for many reasons?
Reply with quote

Still my question wasn't clear?

OK,

When COPY PENDING status will occur?


Either we execute LOAD/UNLOAD utility JCL

OR

when we execute the IMAGE COPY jcl to take image copy of the table sapce.


Or both?



Additionaly, are we going to take the IMAGE COPY after the execution of LOAD/UNLOAD utility OR when this utility job gets fail?
PLease reply
Back to top
View user's profile Send private message
vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Tue May 13, 2008 5:11 am    Post subject:
Reply with quote

COPY PENDING status will occur when a database or tablespace is not in recoverable condition.

For example, if we use load to load a tablespace and do not take a backup of that, the tablespace is not recoverable. That means if some disaster strikes and some data is deleted, we cannot bring tablespace back into consistent state.

When we execute IMAGECOPY jcl, it actually removes a tablespace from COPYPEND status, because we are taking a backup, and so tablespace becomes recoverable. There are many ways in which an object can go in COPYPEND status, and this is a way for DB2 to show us that object can end up in incosistent state.

Hope this helps.
Back to top
View user's profile Send private message
vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Tue May 13, 2008 5:12 am    Post subject:
Reply with quote

Forgot to add this !

Imagecopy should be taken once LOAD is done, so that you have a backup copy of object. It is not related to LOAD being successful or unsucessful, it depends on when you change data in an object.
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Tue May 13, 2008 10:55 am    Post subject: Reply to: Copy pending status occcus for many reasons?
Reply with quote

Vijayprabu,

Please read Image Copy

Syam
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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
This topic is locked: you cannot edit posts or make replies. session stuck in TPX with status ACL amitc23 CA Products 1 Tue Dec 13, 2016 12:53 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am


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