home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList