Fixes are available
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
APAR status
Closed as program error.
Error description
You might receive the following error when querying from a Microsoft SQL Server wrapper nickname: SQL1822N Unexpected error code "24000" received from data source "DATASTORE2". Associated text and tokens are "Invalid cursor state". SQLSTATE=560BD The error entry in db2diag.log is like below: 2010-05-10-16.36.47.031388+120 I13496158A1181 LEVEL: Error PID : 700528 TID : 2315 PROC : db2sysc 0 INSTANCE: xxxxxxxx NODE : xxx DB : xxxxx APPHDL : xxxxx APPID: xxxxxxxx AUTHID : xxxxxxxx EDUID : xxxx EDUNAME: xxxxxxxxx FUNCTION: DB2 UDB, mssql wrapper, Mssql_Server::get_error_info, probe:7 MESSAGE : ODBC error txt: DATA #1 : Hexdump, 132 bytes 0x0000000110D292A0 : 5B49 424D 2844 6174 6144 6972 6563 7420 [IBM(DataDirect 0x0000000110D292B0 : 4F45 4D29 5D5B 4F44 4243 2053 514C 2053 OEM)][ODBC SQL S 0x0000000110D292C0 : 6572 7665 7220 4472 6976 6572 5D49 6E76 erver Driver]Inv 0x0000000110D292D0 : 616C 6964 2063 7572 736F 7220 7374 6174 alid cursor stat 0x0000000110D292E0 : 6500 0000 0000 0000 0000 0000 0000 0000 e...............
Local fix
NO
Problem summary
User affected: Users of Federation Server who use Sybase wrapper Problem Descripion and Summary: See error description.
Problem conclusion
Problem was first fixed in V97fp4. This fix should be applied Federation Server.
Temporary fix
Comments
APAR Information
APAR number
JR37408
Reported component name
MSSQL WRAPPER
Reported component ID
5724N9705
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-03
Closed date
2011-05-02
Last modified date
2011-05-02
APAR is sysrouted FROM one or more of the following:
JR37391
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
MSSQL WRAPPER
Fixed component ID
5724N9705
Applicable component levels
R970 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPL","label":"Data Sources and Wrappers - Microsoft SQL Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"970","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 May 2011