View previous topic :: View next topic
|
Author |
Message |
alluri12
New User
Joined: 15 Aug 2006 Posts: 44 Location: Virginia, USA
|
|
|
|
Hi,
I have a table = owner.Table1 with 16 partitions.
I want to load the Partition table with Load replace and i want to load only few partitions. I do not want to touch the data in other partitions.
I tried the syntax
Code: |
LOAD REPLACE
LOG NO
ORDER YES
COPY YES INLINE REGISTER NONE
UPDATEDB2STATS YES
BMCSTATS YES
REDEFINE NO
INTO TABLE owner.table1 PART 1:11 |
It loaded successfully but the remaining partions data also deleted.
Could anybody please provide the syntax to load only 11 partitions and should not touch the other 12:16 partitions data. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello Alluri,
Since you have specified REPLACE option before the PART OPTION, replace will indicate entire tablespace to be replaced .
Please use below code for each partition :
Code: |
LOAD
INTO TABLE owner1.table1 PART 1 REPLACE |
|
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Alluri,
Quote: |
It loaded successfully but the remaining partions data also deleted. |
Well that is what your below syntax also meant, i guess. If you had worked in BMC, you could have said "TESTED SUCCESSFULLY" for BMC LOAD test documents.
Code: |
LOAD REPLACE
LOG NO
ORDER YES
COPY YES INLINE REGISTER NONE
UPDATEDB2STATS YES
BMCSTATS YES
REDEFINE NO
INTO TABLE owner.table1 PART 1:11 |
Open-Up the BMC Load manual, Look for the "REPLACE" keyword and where to place it, while loading partitions. Since, i have never used BMC, i cannot tell you that position. But, my guess is somewhere near the PART keyword like
Code: |
LOAD
LOG NO
ORDER YES
COPY YES INLINE REGISTER NONE
UPDATEDB2STATS YES
BMCSTATS YES
REDEFINE NO
INTO TABLE owner.table1 PART 1:11 REPLACE |
Above is not tested, similar method is followed for IBM load utility & FASTLOAD utility for loading specific partitions.
Sushanth |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Sorry guptae, i guess i didn't refresh my page.
Sushanth |
|
Back to top |
|
|
alluri12
New User
Joined: 15 Aug 2006 Posts: 44 Location: Virginia, USA
|
|
|
|
Thanks guys.... it worked, Here is the code i used
Code: |
LOAD
RESUME YES
LOG NO
ORDER YES
COPY YES INLINE REGISTER NONE
UPDATEDB2STATS YES
BMCSTATS YES
REDEFINE NO
INTO TABLE owner.table1 PART 1:11 REPLACE |
|
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Thanks Alluri for the update. |
|
Back to top |
|
|
|