IBM FileNet P8, Version 5.2.1            

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


Last updated: March 2016
os_reuse_object_store_databases004.htm

© Copyright IBM Corporation 2016.