|
Problem IC80656
|
Status: Geschlossen |
DB2 CLIENT INCORRECTLY INVOKES SYSPROC.SQLPROCEDURECOLS() WHEN STORED PROCEDURE WITH TIMESTAMP INOUT/OUT PARAMS ARE CALLED |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
DB2 client invokes SYSPROC.SQLPROCEDURECOLS() when .NET
application calls a stored procedures that contains INOUT/OUT
timestamp parameters even when correct data types are bound. DB2
clients should only call SYSPROC.SQLPROCEDURECOLS() when the
application binds parameters with mismatched data types.
The issue only happens against DB2 z/os 10 server.
The extra call to SYSPROC.SQLPROCEDURECOLS() may degrade
performance. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 .Net application users *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 .Net application invokes SYSPROC.SQLPROCEDURECOLS() *
* internally even when correct data types are *
* being bound in the application. *
* *
* Problem only happens with stored procedures that contain *
* INOUT/OUT *
* timestamp parameters and against DB2 z/os 10 server. *
* *
* The extra call of SYSPROC.SQLPROCEDURECOLS() may cause *
* performance degradation. *
* *
* DB2 clients should only call SYSPROC.SQLPROCEDURECOLS() when *
* application binds parameters with mismatched data types. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.7 FP6 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Problem first fixed in V9.7 Fixpak 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC83844
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.01.2012
11.07.2012
11.07.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.,
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
