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 Data replication from multiple Db2 ta... kishpra DB2 1 Mon Mar 27, 2017 9:58 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm


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