View previous topic :: View next topic
|
Author |
Message |
itjagadesh
New User
Joined: 05 Dec 2006 Posts: 89 Location: chennai
|
|
|
|
Hi Team,
can anyone help me out on this.
My requirement if to delete data in particular partition of DB2 table.
ie)In our shop ,DB2 table is partitioned and contains maxumum of 255 partition.i need to delete all the records(rows) from say "100 th " partition alone.Because number of records exceeded in that particular partition alone.
Note :
In our shop there is some utility to unload particular partition data from DB2 table to flat file and again load data from flat file to DB2 table.
Can you please advice me on this.
Please correct me if i am wrong on this.
Thanks in Advance
Jagadesh |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Jagadesh,
Load the table with the empty record. Like,
Code: |
LOAD data inddn emtyrec
RESUME YES
into table HQ.tablename REPLACE PART 100:255 |
Use the utility in your shop. It might be faster.....
Sushanth |
|
Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005 Posts: 306
|
|
|
|
Do a load Dummy on 100th partition alone
Code: |
//SYSREC00 DD DUMMY
//SYSIN DD *
LOAD DATA LOG NO NOCOPYPEND INDDN SYSREC00
INTO TABLE tablename PART 100 REPLACE
|
|
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Quote: |
i need to delete all the records(rows) from say "100 th " partition alone. |
I must have mis-read it.
Thank YOu Prasanth.....
Sushanth |
|
Back to top |
|
|
|