IBM Support

JR29113: CREATING MSSQL SERVER AS VERSION 2005 WHILE ACTUALLY CONNECT TO MSSQL SERVER 2000 WILL CAUSE DB2 CRASH WHEN CREATING NICKNAME

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Platform:
    The problem was found in DB2 v91 and v95 on Windows.
    Reproduce instructions:
    connect to test;
    create wrapper trusted_ms library 'db2mssql3.dll'
    options(DB2_FENCED 'N');
    --nodename and dbname are mssqlserver version 2000
    create server <servername> type mssqlserver version 2005
    wrapper trusted_ms options (node '<nodename>', dbname
    <dbname>;
    create user mapping for user server <servername>
    options(remote_authid '<authid>', remote_password
    '<password>');
    create nickname <servername>."<datasource
    schema>"."<datasource table>";
    

Local fix

Problem summary

  • Users affected: Users of the MS SQL Server wrapper in WebSphere
    Federation Server
    
    Problem description and summary:
    See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9, FixPak 5 (s080512).  This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR29113

  • Reported component name

    MSSQL WRAPPER

  • Reported component ID

    5724N9705

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-24

  • Closed date

    2008-06-23

  • Last modified date

    2008-06-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    JR29199

Fix information

  • Fixed component name

    MSSQL WRAPPER

  • Fixed component ID

    5724N9705

Applicable component levels

  • R910 PSN

       UP

  • R911 PSN

       UP

  • R950 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:
23 June 2008