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
- Open the DB2 Control Center.
- 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.
- 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.
- In the step 3. Region, from the dropdown under Code set, select UTF-8.
- Proceed with the wizard until you are finished.
The newly created database appears in the tree as a subitem of All Databases.
- 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.
- From these options, select Query.
A new Command Editor tab opens in the Control Center, with Target set to your new database.
- At the bottom of your screen, enter an exclamation mark ('!') next to Statement termination character.
- From the toolbar, click Open, browse to the following folder on the SDL Tridion installation media: Database\Scripts\db2\create\
- Open and run each of the following scripts in the order listed:
CD_BROKER_TABLES.db2CD_BROKER_CONSTRAINTS.db2CD_BROKER_INDEXES.db2CD_WAI_TABLES.db2CD_WAI_CONSTRAINTS.db2CD_WAI_INDEXES.db2
- Navigate to the folder Database\Scripts\db2\shared\71\ and in that location, run the script GENERAL_SET_VERSION.db2.