suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT38107 Status: Closed

CONNECT TO A INCORRECTLY CATALOGED DATABASE CAUSED AGENT SPAWNING

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
When the remote server is the actual server where it is
cataloged and the database that is cataloged does not exists,a
simple "db2 connect to" will fork threads (agents) until
exhaustion(32K), sometimes it leads to DB2 coming down.

The problem is easy to reproduce:

db2 catalog tcpip node mynode remote  server 
db2 catalog database rsample as rsample at node mynode
Note: rsample is non-existent database.

db2 connect to rsample user   using 
==> This connect command will cause agent spawning.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* All users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* The problem will be fixed in next releases.                  *
****************************************************************
Local Fix:
Avoid cataloging non-existent database as remote.
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* All users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* The problem will be fixed in next releases.                  *
****************************************************************
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
24.08.2021
16.03.2022
16.03.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)