Results 1 to 2 of 2

Thread: MASS Delete DB2

  1. #1
    Join Date
    Feb 2017
    Posts
    1

    Exclamation Unanswered: MASS Delete DB2

    We need to delete 100+ million rows from table. The table is having 30 partitions with 30+ million rows. What would be best approach to delete rows and recover the space.

  2. #2
    Join Date
    Oct 2007
    Posts
    77
    Provided Answers: 6
    can you load replace particular partitions with dummy load file? Another option is to unload the data you wish to keep and then load/replace with that data.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •