IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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.
    
    ---------------------------------------
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * 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                       *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 95 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68448

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-05

  • Closed date

    2011-01-20

  • Last modified date

    2011-04-04

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC68730 IC68731 IC72040

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 April 2011