Technote (troubleshooting)
Problem(Abstract)
The DB2 CREATE TOOLS catalog command fails with SQL22204N
Symptom
CREATE TOOLS catalog command may fail with an error such as the following:
SQL22204N The DB2 Administration Server encountered a non-severe error while executing a request.
Cause
Due to JDK_PATH set incorrectly in the ADMIN CONFIG for the DAS
Diagnosing the problem
Find out what the current value of the JDK_PATH variable is by running this command
db2 get admin cfg
Look for the following entries in the output:
Java Development Kit Installation Path DAS (JDK_PATH) = AUTOMATIC (C:\SQLLIB\java\jdk)
Java Development Kit Installation Path DAS (JDK_64_PATH) = AUTOMATIC (C:\SQLLIB\java\jdk)
Resolving the problem
If the JDK_PATH values are pointing to invalid locations for a JDK, then you will need to update the values to valid JDK locations. Use these commands to update the JDK path locations:
db2 update admin config using jdk_path <new path>
db2 update admin config using jdk_64_path <new path>
Related information
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Data & Information Management | DB2 Connect | AIX, HP-UX, Linux, Solaris, Windows 2000 | 9.7, 9.5, 9.1 | All Editions |
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.
Rate this page
Please take a moment to complete this form to help us better serve you.
