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 IC68448 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 / 950 - 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.5 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 95 Fix Pack 6                       * 
****************************************************************
Local-Fix:
N/A
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 95 Fix Pack 6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC68730 IC68731 IC72040 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.05.2010
20.01.2011
04.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version