|
View previous topic :: View next topic
|
| Author |
Message |
Baskaran
Warnings : 1
New User
Joined: 24 Oct 2006
Posts: 32
Location: India
|
|
|
|
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 |
|
 |
acevedo
Active User
Joined: 11 May 2005
Posts: 344
Location: Spain
|
|
|
|
| Try -DIS UTIL(*) in DB2 commands |
|
| Back to top |
|
|
bbessa
New User
Joined: 03 Aug 2006
Posts: 13
Location: Brazil
|
|
|
|
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 |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
|
|
| Its LOG YES option with LOAD that sets the copypending status after the utility has ended. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| 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 |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
|
|
| Craq. Thanks for correcting me. |
|
| Back to top |
|
|
ravi17s
Warnings : 1
New User
Joined: 15 Aug 2003
Posts: 57
|
|
|
|
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 |
|
|
|
|
