Preparing object store databases for reuse (DB2®)

Procedure

To prepare a Db2® database for reuse:

  1. In IBM® Control Center, connect to the database for the deleted object store.
  2. Expand the object store database node and select the Tables folder in the left pane.
  3. Select the Tablespace column to sort this list of tables in the right pane.
  4. Select the tables associated with the object store. Do not select any tables in the SYSCATSPACE and SYSTOOLSPACE table spaces.
  5. Right-click and click Drop to drop the selected tables.
  6. 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