Zero Downtime Installation Guide for IBM DB2

10.3

Back Next

Enable Debug Logging

After you install Zero Downtime, enable debug logging on both the source database and the target database.

In a database tool, connect to the source database.

Select the schema for the Operational Reference Store, for example, MDM_SAMPLE.

Run the following commands on the schema. Substitute source system values for the example values.

UPDATE C_REPOS_DB_RELEASE SET DEBUG_FILE_PATH='C:\TEMP',
 DEBUG_FILE_NAME='cmx_debug_SRCDB.log', DEBUG_IND=1, DEBUG_LEVEL=500

SET PATH MDM_SAMPLE, CURRENT PATH

Verify that logging works on the source system.

Run the following command:

CALL CMXLOG.DEBUG('TEST')

Navigate to the directory that you specified and open the

cmx_debug_SRCDB.log

file.

Verify that there is a recent entry that ends with the following text:

GG::DEBUG:TEST

In the database tool, connect to the target database.

Select the schema for the Operational Reference Store, for example, MDM_SAMPLE.

Run the following commands on the schema. Substitute target system values for the example values.

UPDATE C_REPOS_DB_RELEASE SET DEBUG_FILE_PATH='C:\TEMP',
 DEBUG_FILE_NAME='cmx_debug_TGTDB.log', DEBUG_IND=1, DEBUG_LEVEL=500

SET PATH MDM_SAMPLE, CURRENT PATH

Verify that logging works on the target system.

Prepare the Environment for IBM DB2 Databases

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal