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 - Setting Log option YES

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

New User


Joined: 11 Nov 2008
Posts: 27
Location: Canada

PostPosted: Wed Dec 28, 2011 10:23 pm    Post subject: Copy Pending Status - Setting Log option YES
Reply with quote

Hi..

I am performing few tests and need to run the LOAD job several times which locks the table space and I have to tell DBA everytime to unlock the table as I do not have privilege to run the Image copy job in Test region.

I am planning to make the option LOG = YES... so that the table wont go in COPY pending status and I can do my repetitive load tests.

The number of records are no more than 20 for each test.

Can anyone tell me if it will create any issues if I again run the LOAD job for the same table space?

I am planning to put below options for LOAD

LOAD DATA INDDN SYSREC00
LOG YES
RESUME YES
INTO TABLE TABLE01
Back to top
View user's profile Send private message

senthilnathanj

New User


Joined: 31 Jul 2007
Posts: 47
Location: chennai

PostPosted: Thu Dec 29, 2011 11:39 am    Post subject: Reply to: Copy Pending Status - Setting Log option YES
Reply with quote

If it is a copy pending status. Please check the status of the database
-DIS DB(*) SPACENAM(*) RESTRICT in db2commands option.

if any error in that status then start the database with corresponding tablespace with access force option.

-STA DB(XXX) SPACENAM(YYY) ACCESS(FORCE)
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Thu Dec 29, 2011 2:15 pm    Post subject:
Reply with quote

yeah, just force it and then when it is really corrupt ask the dba to help you. (Be prepared to get yelled at.)

maybe it would be better if you ran
Code:
REPAIR OBJECT LOG YES SET table-space-spec NOCOPYPEND

This way you are sure you are only resetting the COPYPEND status
Back to top
View user's profile Send private message
rajesh1183

New User


Joined: 07 Jan 2008
Posts: 98
Location: Hyderabad

PostPosted: Thu Dec 29, 2011 3:50 pm    Post subject: Reply to: Copy Pending Status - Setting Log option YES
Reply with quote

or you can code LOAD card with option

Code:
LOG NO NOCOPYPEND


This will not make your table to go to COPYPEND when you LOAD data...
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 0 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