View previous topic :: View next topic
|
Author |
Message |
skgupta81
New User
Joined: 11 Nov 2008 Posts: 27 Location: Canada
|
|
|
|
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 |
|
|
senthilnathanj
New User
Joined: 31 Jul 2007 Posts: 47 Location: chennai
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
rajesh1183
New User
Joined: 07 Jan 2008 Posts: 98 Location: Hyderabad
|
|
|
|
or you can code LOAD card with option
This will not make your table to go to COPYPEND when you LOAD data... |
|
Back to top |
|
|
|