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
 

 

Delete Particular Partition data from DB2 table

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

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Wed Nov 19, 2008 12:05 pm    Post subject: Delete Particular Partition data from DB2 table
Reply with quote

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

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Nov 19, 2008 4:03 pm    Post subject:
Reply with quote

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

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Nov 19, 2008 5:19 pm    Post subject:
Reply with quote

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

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Nov 19, 2008 5:24 pm    Post subject:
Reply with quote

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
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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 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 JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


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