Documentation Center

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:

  1. Shared\60\GENERAL_SET_VERSION.db2
  2. Upgrade\54SP1_60\TCD_ITEMMETA.sql
  3. Upgrade\54SP1_60\TCD_METADATA.sql
  4. Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
  5. Upgrade\54SP1_60\TCD_TAXONOMIES.sql
  6. Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
  7. Upgrade\54SP1_60\TCD_TRACKING.sql
  8. Shared\60\CD_TRACKING_PROCEDURES.sql
  9. Shared\61\GENERAL_SET_VERSION.db2
  10. Upgrade\60_61\TCD_TRACKING.sql
  11. Upgrade\60_61\TCD_BINARYVARIANTS.sql
  12. Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
  13. Upgrade\60_61\TCD_PREVIEW.sql
  14. Shared\61\CD_TRACKING_PROCEDURES.sql
  15. Shared\71\GENERAL_SET_VERSION.db2
  16. Upgrade\61_70\TCD_UPDATE_TABLES.sql
  17. 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:

  1. Shared\71\GENERAL_SET_VERSION.db2
  2. Upgrade\61_70\TCD_UPDATE_TABLES.sql
  3. Upgrade\61_70\TCD_PUBLICATION_MAPPINGS.sql

Finishing the DB2 upgrade

To finalize your upgrade, exit the DB2 Command Center.