Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 3270 Data stream error Benchwarmer CICS 6 Tue Apr 17, 2018 12:06 am
No new posts How to list data set names with diffe... murali.andaluri CLIST & REXX 8 Thu Apr 12, 2018 11:33 pm
No new posts Searching a table for the field name? socker_dad COBOL Programming 8 Sat Mar 31, 2018 2:57 am
No new posts Need inputs on DB2 tablespace/table r... ashek15 DB2 3 Sat Mar 24, 2018 11:49 pm
No new posts Invalid XML character while producing... nikhil.bhole IBM Tools 4 Tue Mar 20, 2018 1:24 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us