Fixes are available
APAR status
Closed as fixed if next.
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
**************************************************************** * USERS AFFECTED: * * none * **************************************************************** * PROBLEM 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............... * **************************************************************** * RECOMMENDATION: * * Upgrade to latestest fixpack * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR37391
Reported component name
MSSQL WRAPPER
Reported component ID
5724N9705
Reported release
910
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-02
Closed date
2011-06-10
Last modified date
2011-06-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R910 PSN
UP
R910 PSY
UP
R911 PSN
UP
R911 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":"910","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
10 June 2011