View previous topic :: View next topic
|
Author |
Message |
vinit_infy Warnings : 1 New User
Joined: 07 Apr 2005 Posts: 56
|
|
|
|
Hi experts,
Can there is any way so we can prevent our db2 objects to go in copy pending status after running a load utility to load tables in DB2 database ?
Is there any parameter which we can set in load job to keep database in normal condition after loading?
Please assist.
Thanks |
|
Back to top |
|
|
vebs
New User
Joined: 27 Oct 2007 Posts: 19 Location: UK
|
|
|
|
You can set the logging option on, it will allow TS to be in RW condition. But this option is not recommended if you are loading more then 1000 rows, as it will affect performance adversely.
And ONLY IN TEST REGION, you could remove copy pending by running a repair on the tablespace.
Was there any particular requirement around this. |
|
Back to top |
|
|
plkanth_526
New User
Joined: 01 Jun 2008 Posts: 7 Location: Bangalore
|
|
|
|
Use LOAD LOG NO NOCOPYPEND to keep the tablespace in RW status once load completes.Tablespace will be available.
But it is advisable to run ic after the load with log no as data will be recoverable. |
|
Back to top |
|
|
|