title: How to delete 80 million rows of from DB2 table in which the Where clause will be having a join query?
body: <p>I want to delete 80 million rows of data from a DB2 table. </p>
  
  <p>This table is used in number of CICS-DB2 programs. We cannot drop the table or unload the required amount of data into a file and then delete the unwanted records. Later load the table from file. As this will require CICS outage. CISCS outage is not possible.    </p>
  
  <p>I have tried different methods like DB2 delete cursor, Adhoc job but everything has a limit from 5,000 to 5,00,000 rows.</p>
  
  <p>Please can you suggest a good and optimize way of deleting the rows from table.</p>