Fixes are available
APAR status
Closed as program error.
Error description
Reproduce scripts: create server "<server_name>" type mssqlserver version 2005 wrapper mssqlodbc3 options (node '<node_name>', dbname '<database_name>') DB20000I The SQL command completed successfully. create user mapping for newton server "<server_name>" options ( REMOTE_AUTHID '<username>', REMOTE_PASSWORD '<password>' ) DB20000I The SQL command completed successfully. create procedure FSTP_REMOTE_SYSPROC source "sys"."sp_addgroup" for server <server_name> DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0204N "sys.sp_addgroup" is an undefined name. LINE NUMBER=1. SQLSTATE=42704
Local fix
Problem summary
Users affected: Users of the MS SQL Server wrapper in InfoSphere Federation Server Problem description and summary: See error description.
Problem conclusion
Problem was first fixed in Version 9.1 FixPak 8 (s090823). This fix should be applied on the federation server.
Temporary fix
Comments
APAR Information
APAR number
JR32221
Reported component name
MSSQL WRAPPER
Reported component ID
5724N9705
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-02
Closed date
2009-10-07
Last modified date
2009-10-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
MSSQL WRAPPER
Fixed component ID
5724N9705
Applicable component levels
R910 PSN
UP
R911 PSN
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:
07 October 2009