Troubleshooting
Problem
During the process of configuring the IBM Rational Portfolio Manager Open Data Access database, the process stops when the enable_federated.sql script is run.
Symptom
The full error message is as follows: . . .
BUILD FAILED
com.ibm.db2.jcc.b.km: DB2 SQL Error: SQLCODE=-20076, SQLSTATE=0A502, SQLERRMC=1,
DRIVER=3.50.152
at com.ibm.db2.jcc.b.wc.a(wc.java:573)
at com.ibm.db2.jcc.b.wc.a(wc.java:57)
Cause
The problem is in the code; it modifies the Database Manager (dbm) configuration. The process does not restart the DB2 instance after modifying a instance parameter, which is why the error is occurring. This means that the database created to house the Rational Portfolio Manager Open Data Access content was not enabled to utilize the federated functions prior to starting the configuration process.
Diagnosing The Problem
Running the following query in the DB2 command window on the SQLCODE error number
db2 ? sql20076n
Displays information on the error, which indicates:
"For a federated server, set the DBM variable <FEDERATED> to YES and
then restart the database manager."
Resolving The Problem
To resolve this issue:
1. Run the following commands from a DB2 command window:
db2 update dbm cfg using FEDERATED yes
db2stop
db2start
2. Once the database has been restarted, then uninstall the existing configuration on the Rational Portfolio Manager Open Data Access database by running the following command:
ant uninstall > uninstall.out
3. Once this has completed, review the uninstall output to ensure that there are no other issues. If you have additional errors, contact Rational Client Support and provide this file to the engineer.
4. Once you have a clean uninstall return to the IBM Rational Portfolio Manager Open Data Access Installation and ETL Reference Manual and continue with the install process.
All source code and/or binaries attached to this document are referred to here as "the Program". IBM is not providing program services of any kind for the Program. IBM is providing the Program on an "AS IS" basis without warranty of any kind. IBM WILL NOT BE LIABLE FOR ANY ACTUAL, DIRECT, SPECIAL, INCIDENTAL, OR INDIRECT DAMAGES OR FOR ANY ECONOMIC CONSEQUENTIAL DAMAGES (INCLUDING LOST PROFITS OR SAVINGS), EVEN IF IBM, OR ITS RESELLER, HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. |
|---|
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21376431