|
Problem IC84489
|
Status: Closed |
MANY TCPIP SOCKET MAY REMAIN OPEN WHILE DEBUGGING A STORED PROCEDURE WITH OPTIM DEVELOPMENT STUDIO. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When a stored procedure is debugged with Optim Development
Studio.
TCPIP socket may not be closed correctly by DB2 Server.
The following kind of error are repeated for many times in
db2diag.log while this issue happens.
2012-02-08-16.43.39.216622+540 I22634260A559 LEVEL: Error
PID : 6193174 TID : 11568 PROC : db2sysc
0
INSTANCE: instname NODE : 000 DB :
P92253
APPHDL : 0-25 APPID:
9.189.215.199.4584.120208073604
AUTHID : E34229
EDUID : 11568 EDUNAME: db2agent (dbname) 0
FUNCTION: DB2 UDB, runtime interpreter,
sqlriOneTimeInitRtn1Trusted, probe:25
MESSAGE : Error calling openHandle. rc =
DATA #1 : Hexdump, 4 bytes
0x0700000004FF1F80 : FFFF FBAA |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* User using Optim Development Studio *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V10.1 Fix Pack 1. *
**************************************************************** |
| Local Fix: |
Not Available |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 10.1 Fix Pack 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2012
01.11.2012
01.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
