Migrate Siebel 7 e-business applications from DB2 UDB V8 to DB2 9

This article will lead you through the upgrade of the Siebel 7 database environment from DB2®UDB Version 8 to DB2 9. You will learn some of the necessary steps and the tools and commands you need to complete the migration process.

This article first introduces some of the new features in DB2 9 and shows how Siebel applications can take advantage of these features. This article details the work of the UNIX® and Windows® operating systems during the pre-migration and actual migration process, and finally describes the steps that need to be followed to complete the migration.

New features in DB2 9

PUREXM™L:DB2 9-day support for XML data storage. This allows well-formed XML documents to be stored in Siebel table columns in their own hierarchical format. The XML data is stored as an XML type rather than as text. Therefore, you can use XQuery, SQL, or a combination of both to efficiently search for and retrieve XML data.

Automated management features: Automated management features simplify SIEBEL/DB2 DBA management tasks. It includes self tuning memory management (self tuning Memory MANAGEMENT,STMM). STMM reduces or eliminates the task of configuring DB2 servers by continually updating configuration parameters (database parameters and Database Manager parameters), adjusting the buffer pool size, and dynamically determining the total amount of memory used by the database.

Enhanced Database Security: tab-based access control (label Based access Control,lbac) is a new security feature that allows you to control data access at the level of rows and columns. To do this, a new security Administrator (SECADM) authorization level is added that collects security-related permissions. Depending on the structure, location, or affiliation of a list or group, LBAC can be used to enhance Siebel access control for user-visible records.

Flex enhancement: SIEBEL/DB2 DBAs can immediately use some of the enhancements in DB2 9 to add resilience. Some of these features include:

The ability to restart interrupted recovery operations that can save valuable time and effort in database recovery.

Supports the redirection recovery operation using scripts that are automatically generated from an existing backup image.

The ability to reconstruct the database from a tablespace backup image.

Additional useful features: Many features are useful for Siebel applications. Some of these features are related to performance and scalability, such as data row compression, while others are related to manageability, such as the ability to replicate database schemas, and ALTER TABLE statement enhancements.

This article will show you how to enable some of the features of DB2 9, such as self-tuning memory management and compression, that are done after the migration.

Pre-migration steps

The pre-migration step is very important and is the key to achieving a successful migration. In this section, you will actually perform three tasks:

Before starting the migration, gather the most important information about the current database and environment (some useful scripts and examples are given). This way, if there is a problem during the migration process, you can easily revert to the state before the migration. Also, if you need to use this information and the values are useful after migration, you can also apply them.

See if your machine is compatible and can safely install and use DB2 9.

Stop the DB2 server and prepare for migration.