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.