Deleting data from the DB2 database

Before you reload the database with new data, you should delete the old data. This can be done in several ways:

Use the DROP TABLE statement for each table you want to delete.
Use the DROP TABLESPACE statement for each tablespace.
Delete all of the records in each table.
Figure 1 shows the sample SQL statements that delete the group record data from the tables.

Figure 1. DB2 utility statements required to delete the group records

DELETE FROM userid.GROUP_BD           ;
DELETE FROM userid.GROUP_DFP_DATA     ;
DELETE FROM userid.GROUP_INSTALL_DATA ;
DELETE FROM userid.GROUP_SUBGROUPS    ;
DELETE FROM userid.GROUP_MEMBERS      ;