Technote (troubleshooting)
Problem(Abstract)
The application event log will show informational messages related to the DB2 client code page not being found.
Symptom
In Tivoli Enterprise Portal, the navigation may show a dark gray X on the Warehouse Proxy.
Cause
DB2CODEPAGE environment variable is not set.
Environment
Windows
Diagnosing the problem
Open the application event log and search for messages like:
Source: Tivoli Warehouse Proxy
Event ID: 13
Type: Error
Exporter Error reported by khdxdbb.cpp at 2413 in checkUTF8ClientEncoding.
------------------------------------------------------------------------------
Source: Tivoli Warehouse Proxy
Event ID: 12
Type: Information
Exporter Error
Error Type=CTX_InitializationFailed
Severity=CTX Warning
Native Error Code=0
SQL State= NULL
Reason Code=0. Native Error Message "DB2 client code page not found"
Resolving the problem
To resolve this issue, follow the steps below:
Create a Windows Environment variable DB2CODEPAGE=1208 within the Windows Operating System:
Procedures.
Right-click on My Computer and choose "Properties".
In the box that opens, click the "Advanced" tab to obtain the dialog box shown below.
Next, click the button "Environment Variables".
The box for adding a new user variable will appear . (system variable)
Input the following values and Click OK to apply.
Variable Name = DB2CODEPAGE
Variable Value = 1208
Reboot the server afterwards.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.