Upgrading your IBM DB2 databases
Run a number of SQL scripts to upgrade your SQL Server Content Delivery databases (Content Data Store and Experience Manager database, if using). Run these scripts for each database your are upgrading.
Backing up your existing database
Make a back-up of your database before upgrading.
Accessing the DB2 Command Center
To start upgrading the DB2 database, open the DB2 Command Center. Select your Content Delivery 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 to access scripts to run.
Upgrading your SDL Tridion 2009 SP1 IBM DB2 database manually
If you are upgrading from version 2009 SP1 of SDL Tridion, access your SDL Tridion 2013 SP1 installation media, navigate to Database\Scripts\DB2\, and run the following database scripts located in the relative paths provided, in the order given:
- Shared\60\GENERAL_SET_VERSION.db2
- Upgrade\54SP1_60\TCD_ITEMMETA.sql
- Upgrade\54SP1_60\TCD_METADATA.sql
- Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
- Upgrade\54SP1_60\TCD_TAXONOMIES.sql
- Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
- Upgrade\54SP1_60\TCD_TRACKING.sql
- Shared\60\CD_TRACKING_PROCEDURES.sql
- Shared\61\GENERAL_SET_VERSION.db2
- Upgrade\60_61\TCD_TRACKING.sql
- Upgrade\60_61\TCD_BINARYVARIANTS.sql
- Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
- Upgrade\60_61\TCD_PREVIEW.sql
- Shared\61\CD_TRACKING_PROCEDURES.sql
- Shared\71\GENERAL_SET_VERSION.db2
- Upgrade\61_70\TCD_UPDATE_TABLES.sql
- Upgrade\61_70\TCD_PUBLICATION_MAPPINGS.sql
Upgrading your SDL Tridion 2011 SP1 IBM DB2 database manually
If you are upgrading from version 2011 SP1 of SDL Tridion, access your SDL Tridion 2013 SP1 installation media, navigate to Database\Scripts\DB2\, and run the following database scripts located in the relative paths provided, in the order given:
- Shared\71\GENERAL_SET_VERSION.db2
- Upgrade\61_70\TCD_UPDATE_TABLES.sql
- Upgrade\61_70\TCD_PUBLICATION_MAPPINGS.sql
Finishing the DB2 upgrade
To finalize your upgrade, exit the DB2 Command Center.