Preparing an object store database or table space for reuse

You can reuse the database or table space of a deleted object store for a new object store. Reuse allows you to retain settings such as next extent size, special user permissions, settings on the data files and transaction logs, and other customized settings. To create an object store after following the preparation procedure in this topic, see Create an object store.

Prerequisite

Delete the object store that uses the database or table space before attempting to reuse the database or table space for another object store. For information about deleting an object store, see Deleting an object store.

ATTENTION  Preparing a database or a table space for reuse is an irreversible operation. The tables dropped as part of this procedure are permanently deleted. Do not drop tables unless you are certain that the tables belong to an object store that has been deleted. In particular, do not drop any table whose name begins with FNGCD unless you are also deleting a domain. (For more information, see Deleting a domain.)

To prepare a Microsoft SQL Server database for reuse

  1. In Microsoft SQL Server Enterprise Manager, connect to the database for the deleted object store.
  2. Select the Tables icon in the right pane.
  3. Select and right-click all the user tables in the right pane. The user tables are identified by the term User in the Type column.
  4. Click Delete from the menu.
  5. In the Drop Objects window, click Drop All. SQL Server deletes the tables.

To prepare an Oracle table space for reuse

  1. Start Oracle SQL Plus.
  2. Drop the Content Engine user account for the table space that belongs to the deleted object store. Be sure to use the CASCADE option. For example:

    DROP USER <user_name> CASCADE

  3. Create a user account for the table space. Use the following script as a guide for assigning privileges to the new user account. Replace <user_name> and <password> with the Content Engine user account information and replace <table_space> with the name of the table space you are reusing.

    DROP USER <user_name> CASCADE;
    CREATE USER <user_name>
    IDENTIFIED BY <password>
    DEFAULT TABLESPACE <primary_table_space>
    QUOTA UNLIMITED ON <primary_table_space>
    TEMPORARY TABLESPACE <temp_table_space>
    QUOTA UNLIMITED ON <temp_table_space>;
    GRANT CREATE SESSION TO <user_name>;
    GRANT CREATE TABLE TO <user_name>;
    GRANT CREATE SEQUENCE TO <user_name>;

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 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