How to release space after deleting table data in DB2?

In DB2, after deleting table data, the space is not immediately released. Instead, it is automatically managed and maintained by the database management system. DB2 marks the deleted data as reusable and adds new data to the previously deleted space when needed. This automatic management can improve the performance of the database.

If you want to free up space immediately, you can use one of the following methods:

1. Reorganize the table using the REORG TABLE command, which will sort rows and release unused space in the table. For example, reorganize a table named your_table with the following command:
2. Reorganize the table named your_table.
3. Please note that the REORG TABLE command may take some time to complete, depending on the size of the table and the workload of the database.
4. To free up space, you can rebuild a table by creating a new empty table, transferring the data from the old table to the new table, and then deleting the old table. This will create a blank table with no deletion markers, thus freeing up the space previously occupied by deleted data. It is important to backup your data before performing this operation.
5. For example, use the following command to rebuild a table named your_table:
6. Create a new table with the same data as your_table, drop your_table, and rename the new table to your_table.
7. This will create a new table named new_table, copy the data from your_table to new_table, drop your_table, and finally rename new_table to your_table.

Please remember to backup your data before carrying out these operations to prevent any potential accidents.