DB2 - Problembeschreibung
Problem IC77607 | Status: Geschlossen |
WRONG WARNING GENERATED WHEN THERE IS AN ALIAS WITH SAME DETAILS IN DB2CLI.INI AND DB2DSDRIVER.CFG | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In the scenario below, we have a case where an alias is in the cli.ini file, as well as the dsdriver.cfg file with same details. The validate catches this file, however at the end it prints this statement: db2cli.ini Validation : ---------------------------------------------------------------- ----------- [ DB2CLIINIPATH env var : F:\SQLLIB ] [ db2cli.ini Path : F:\SQLLIB\db2cli.ini ] ---------------------------------------------------------------- ----------- [ Keywords used by CLI for DSN: d2ga ] Keyword Value -------------------------------------------------- AUTHENTICATION SERVER PORT 51203 HOSTNAME sysg.jax.fnfis.com DATABASE CPIJAXD2GA PROTOCOL TCPIP INSTANCE D2GA DBALIAS D2GA PWD ******** UID Q005900 ---------------------------------------------------------------- ----------- Warning: The schema validation operation completed successfully. The following data source name or database name was not found in the db2dsdriver.cfg file: "d2ga". | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * When user uses db2cli tool to validate db2dsdriver.cfg file. * * Issue is db2cli tool specific. * **************************************************************** * PROBLEM DESCRIPTION: * * WRONG WARNING GENERATED WHEN THERE IS AN ALIAS WITH SAME * * DETAILS IN DB2CLI.INI AND DB2DSDRIVER.CFG * * * * The validate catches this file, however at the end it prints * * this statement: * * * * * * db2cli.ini Validation : * * * * * * * * ------------------------------------------------------------ * * ---- * * ----------- * * * * [ DB2CLIINIPATH env var : F:\SQLLIB ] * * * * [ db2cli.ini Path : F:\SQLLIB\db2cli.ini ] * * * * * * * * ------------------------------------------------------------ * * ---- * * ----------- * * * * [ Keywords used by CLI for DSN: d2ga ] * * * * Keyword Value * * * * -------------------------------------------------- * * * * AUTHENTICATION SERVER * * * * PORT 51203 * * * * HOSTNAME * * * * sysg.jax.fnfis.com * * * * DATABASE CPIJAXD2GA * * * * PROTOCOL TCPIP * * * * INSTANCE D2GA * * * * DBALIAS D2GA * * * * PWD ******** * * * * UID Q005900 * * * * * * * * ------------------------------------------------------------ * * ---- * * ----------- * * * * * * * * Warning: The schema validation operation completed * * successfully. * * The following data source name or database name was not * * found in the db2dsdriver.cfg file: "d2ga". * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v97fp5 or later releases. * **************************************************************** | |
Local-Fix: | |
Add some parameter in db2dsdrive.cfg file. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
db2_v97fp5 contains fix. After fix, warning will not come. | |
Workaround | |
Use some parameters in db2dsdriver.cfg file. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.07.2011 12.12.2011 12.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |