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 after Laoding

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

New User


Joined: 07 Apr 2005
Posts: 56

PostPosted: Sat Jun 28, 2008 3:27 am    Post subject: COPY PENDING after Laoding
Reply with quote

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
View user's profile Send private message

vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Sat Jun 28, 2008 4:28 am    Post subject:
Reply with quote

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
View user's profile Send private message
plkanth_526

New User


Joined: 01 Jun 2008
Posts: 7
Location: Bangalore

PostPosted: Mon Jun 30, 2008 12:37 pm    Post subject: Reply to: COPY PENDING after Laoding
Reply with quote

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
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 copy SEQ to PDS and create stats steve-myers JCL & VSAM 5 Thu Apr 27, 2017 1:15 am
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
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


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