View previous topic :: View next topic
|
Author |
Message |
vijayprabu
New User
Joined: 15 Dec 2005 Posts: 21
|
|
|
|
Guys am getting confusions .. please help me out
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
vijayprabu
New User
Joined: 15 Dec 2005 Posts: 21
|
|
|
|
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 |
|
|
vebs
New User
Joined: 27 Oct 2007 Posts: 19 Location: UK
|
|
|
|
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 |
|
|
vebs
New User
Joined: 27 Oct 2007 Posts: 19 Location: UK
|
|
|
|
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 |
|
|
skkp2006
New User
Joined: 14 Jul 2006 Posts: 93 Location: Chennai,India
|
|
Back to top |
|
|
|