Procedure
To prepare a DB2® database
for reuse:
- In IBM® Control Center,
connect to the database for the deleted object store.
- Expand the object store database node and select the Tables
folder in the left pane.
- Select the Tablespace column to sort this list of tables
in the right pane.
- Select the tables associated with the object store. Do
not select any tables in the SYSCATSPACE and SYSTOOLSPACE table spaces.
- Right-click and click Drop to drop
the selected tables.
- In the DB2 command
line processor, drop the sequence objects that are named CONTENTQUEUESEQUENCE,
CISEQUENCE, AUDITSEQUENCE, and REPLSEQUENCE, and SCFSEQUENCE using
the following command: DB2 DROP SEQUENCE schema.sequenceName
For example:
db2 => connect to FNOSDB
db2 => drop sequence db2admin.auditsequence
DB20000I The SQL command completed successfully.
db2 => exit