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

AFTER AN APPLICATION IS FORCED ON A WINDOWS DATABASE SERVER, THE CLIENT
PROGRAM HANGS.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
If an application on a Windows database server is forced, the 
client program for that application hangs next time it runs a 
query. 
 
This problem does not happen for database servers on any 
platform other than Windows. 
 
Here are steps which reproduce the problem: 
 
On the database client, connect to a database that is on a 
Windows database server. 
For example, run: 
 db2 "connect to <database> ..." 
  (substituting for <database> the name of the database on a 
Windows database server) 
 
On the Windows database server, force the application. 
For example, run: 
 db2 "list applications" 
 db2 "force application (<app-handle>)" 
  (subsituting for <app-handle> the application handle that was 
output by "list applications") 
 
On the database client, using the client program for the 
application that you forced, run any SQL statement. 
For example, run: 
 db2 "select count(*) from syscat.tables" 
 
At this point the client program ought to get error: 
"SQL30081N  A communication error has been detected." 
But because of this defect it hangs instead. 
 
Now if you stop the stop the DB2 instance on the Windows 
database server the client program is no longer hung but gets 
the error: 
"SQL30081N  A communication error has been detected."
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who connect to a DB2 on Windows database               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************
Local-Fix:
As a workaround to prevent the client program from hanging 
indefinitely, you can set 
the DB2 registry variable DB2TCP_CLIENT_RCVTIMEOUT on the 
database client to the number of seconds that the client program 
should wait before it gets the SQL30081N error.
verfügbare FixPacks:
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
Problem was first fixed in Version 9.7 Fix Pack 7. 
At a minimum, this fix should be applied on the database server.
Workaround
As a workaround to prevent the client program from hanging 
indefinitely, you can set the DB2 registry variable 
DB2TCP_CLIENT_RCVTIMEOUT on the database client to the number of 
seconds that the client program should wait before it gets the 
SQL30081N error.
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC83679 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.05.2012
30.10.2012
30.10.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList