Documentation Center

Creating an IBM DB2 publish undo database manually

Create your IBM DB2 publish undo database manually by running database scripts that create the database and its tables.

Procedure

  1. Open the DB2 Control Center.
  2. In the tree control on the left, right-click All Databases and select Create Database > Standard.
    The Create Database Wizard opens. Create a database as you would normally, but take into account the following settings.
  3. In the step 1. Name, do the following:
    • Under Database name, choose a name for the database.
    • From the dropdown under Default bufferpool and table space page size, select a value of 8K or higher.
  4. In the step 3. Region, from the dropdown under Code set, select UTF-8.
  5. Proceed with the wizard until you are finished.
    The newly created database appears in the tree as a subitem of All Databases.
  6. To create the tables for the Content Data Store database in DB2, select the newly created database node in the tree.
    A number of options appears at bottom right.
  7. From these options, select Query.
    A new Command Editor tab opens in the Control Center, with Target set to your new database.
  8. At the bottom of your screen, enter an exclamation mark ('!') next to Statement termination character.
  9. From the toolbar, click Open, browse to the following folder on the SDL Tridion installation media: Database\Scripts\db2\create\
  10. Open and run each of the following scripts in the order listed:
    1. CD_BROKER_TABLES.db2
    2. CD_BROKER_CONSTRAINTS.db2
    3. CD_BROKER_INDEXES.db2
    4. CD_WAI_TABLES.db2
    5. CD_WAI_CONSTRAINTS.db2
    6. CD_WAI_INDEXES.db2
  11. Navigate to the folder Database\Scripts\db2\shared\71\ and in that location, run the script GENERAL_SET_VERSION.db2.