<div>
<div class="content wysiwyg-content">
DB2 10.5 on Windows.<br />
<br />
I have a DB2 database that I am removing a large amount of old data from. &nbsp;So tables with 130,000,000 rows will be reduced to 5,000,000. &nbsp;I want to do this quickly and cleanly with minimum impact to storage. &nbsp;I have read several articles on how to do this but each suggest a different way.<br />
<br />
What is the most efficient way to do this? &nbsp;Should I copy the data I am going to keep to a new table and then drop and recreate the original and then copy it back in?<br />
<br />
Or should I use a delete or truncate routine? &nbsp;If I do it this way, will I need to do a reorg with truncate on the tables afterwards?<br />
<br />
Any suggestion would be very welcomed. &nbsp;Thank you!<br />
<br />
Jim
</div>
</div>


DB2 10.5 on Windows.

I have a DB2 database that I am removing a large amount of old data from.  So tables with 130,000,000 rows will be reduced to 5,000,000.  I want to do this quickly and cleanly with minimum impact to storage.  I have read several articles on how to do this but each suggest a different way.

What is the most efficient way to do this?  Should I copy the data I am going to keep to a new table and then drop and recreate the original and then copy it back in?

Or should I use a delete or truncate routine?  If I do it this way, will I need to do a reorg with truncate on the tables afterwards?

Any suggestion would be very welcomed.  Thank you!

Jim

DB2 best way to delete large amounts of data

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.