JR37407: SQL1822N WITH MESSAGE 'INVALID CURSOR STATE' REPORTED BY MICROSOFT SQL SERVER WRAPPER

DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 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

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This problem raises up when customer's operation sequence    *
  * implicitly includes two close cursor operations against same *
  * statement handle.                                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When querying from remote data source through nickname,      *
  * mssql wrapper would report below error:                      *
  *                                                              *
  * SQL1822N  Unexpected error code "24000" received from data   *
  * source                                                       *
  * "DATASTORE2". Associated text and tokens are "Invalid cursor *
  * state".                                                      *
  * SQLSTATE=560BD                                               *
  *                                                              *
  * Mssql wrapper is failed to deal with sqlstate '24000' when   *
  * it closes a cursor.                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Infosphere Federation Server version 9.5 fixpack  *
  * 7.                                                           *
  ****************************************************************
  

Problem conclusion

• This problem has been fixed in Infosphere Federation Server
  version 9.5 fixpack 7.
  With this fix, customer won't see SQL1822N error with sqlstate
  "24000" again.
  

Temporary fix

Comments

APAR Information

• 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

• R950 PSN

     UP

• R950 PSY

     UP