|
Problem IC81402
|
Status: Closed |
MANY TCPIP SOCKET MAY REMAIN OPEN WHILE DEBUGGING A STORED PROCEDURE WITH OPTIM DEVELOPMENT STUDIO. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* all users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Move to v97fp6 or later releases *
**************************************************************** |
| Local Fix: |
Not Available |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 6. |
| Workaround |
Not available. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84489
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.02.2012
06.06.2012
06.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
