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 IC72040 Status: Geschlossen

IF CUSTOMER USING COMBINATION OF REMOTE CONNECT (FROM DIFFERENT BOX) AND
LOCAL CONNECT (FROM THE SAME BOX) AND THE DB IS CATALOG

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
If customer using combination of remote connect (from different 
box) and local connect (from the same box) and the db is 
cataloged using the TCP/IP loopback and similar to the 
following: 
 
 
  System Database Directory 
 
  Number of entries in the directory = 2 
 
    Database 1 entry: 
 
     Database alias                       = IANDB1 
     Database name                        = IANORG 
     Node name                            = LOOPBK 
     Database release level               = c.00 
     Comment                              = 
     Directory entry type                 = Remote 
     Catalog database partition number    = -1 
     Alternate server hostname            = 
     Alternate server port number         = 
 
    Database 2 entry: 
 
     Database alias                       = IANORG 
     Database name                        = IANDB1 
     Local database directory             = /home/ikhono 
     Database release level               = c.00 
     Comment                              = 
     Directory entry type                 = Indirect 
     Catalog database partition number    = 0 
     Alternate server hostname            = 
     Alternate server port number         = 
 
 
 
 Node Directory 
 
     Number of entries in the directory = 1 
 
    Node 1 entry: 
 
     Node name                      = LOOPBK 
     Comment                        = 
     Directory entry type           = LOCAL 
     Protocol                       = TCPIP 
     Hostname                       = 127.0.0.1 
     Service name                   = xikhono 
 
 
==> db2 engine could trap. 
 
---------------------------------------
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW V9.1 users with DB cataloged using a different alias * 
* name than the database name                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When a local database is cataloged using a different alias   * 
* name than the database name, issuing a connect to the        * 
* database alias could fail:                                   * 
*                                                              * 
* Case #1: local connect could fail with SQL1224               * 
*                                                              * 
* Case #2: remote connect could fail with SQL30081N            * 
*                                                              * 
* Case #3: If customer using combination of remote connect     * 
* (from different box) and local connect (from the same box)   * 
* and the db is cataloged using the TCP/IP loopback that       * 
* similar to the catalog below, db2 engine could trap.         * 
*                                                              * 
* System Database Directory                                    * 
*                                                              * 
* Number of entries in the directory = 2                       * 
*                                                              * 
* Database 1 entry:                                            * 
*                                                              * 
* Database alias                      = IANDB1                 * 
* Database name                        = IANORG                * 
* Node name                            = LOOPBK                * 
* Database release level              = c.00                   * 
* Comment                              =                       * 
* Directory entry type                = Remote                 * 
* Catalog database partition number    = -1                    * 
* Alternate server hostname            =                       * 
* Alternate server port number        =                        * 
*                                                              * 
* Database 2 entry:                                            * 
*                                                              * 
* Database alias                      = IANORG                 * 
* Database name                        = IANDB1                * 
* Local database directory            = /home/ikhono           * 
* Database release level              = c.00                   * 
* Comment                              =                       * 
* Directory entry type                = Indirect               * 
* Catalog database partition number    = 0                     * 
* Alternate server hostname            =                       * 
* Alternate server port number        =                        * 
*                                                              * 
*                                                              * 
*                                                              * 
* Node Directory                                               * 
*                                                              * 
* Number of entries in the directory = 1                       * 
*                                                              * 
* Node 1 entry:                                                * 
*                                                              * 
* Node name                      = LOOPBK                      * 
* Comment                        =                             * 
* Directory entry type          = LOCAL                        * 
* Protocol                      = TCPIP                        * 
* Hostname                      = 127.0.0.1                    * 
* Service name                  = xikhono                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* - keep the default catalog entry in which the "Database      * 
* name" and the "Database alias" is the same.                  * 
* - upgrade to DB2 Version 91 Fix Pack 10                      * 
****************************************************************
Local-Fix:
N/A
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
Problem was first fixed in Version 91 Fix Pack 10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.10.2010
30.06.2011
30.06.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP10
Problem behoben lt. FixList in der Version
9.1.0.10 FixList