IBM Support

JR27511: ERROR FROM MS SQL SERVER WRAPPER FOLLOWED BY THE DATABASE BEING MARKED AS DAMAGED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The db2diag.log file contains errors from the MS SQL Server
    wrapper, for example:
    2007-08-23-04.01.35.045000-300 I3092755H1063      LEVEL: Error
    PID     : 864                  TID  : 7680        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SQLCURP
    APPHDL  : 0-1167               APPID: STATE.LUDB2P.C112DBE624B5
    FUNCTION: DB2 UDB, mssql wrapper, Mssql_Server::get_error_info,
    probe:7
    MESSAGE : ODBC error txt:
    DATA #1 : Hexdump, 144 bytes
    0x05B694C0 : 5B4D 6963 726F 736F 6674 5D5B 4F44 4243
    [Microsoft][ODBC
    0x05B694D0 : 2053 514C 2053 6572 7665 7220 4472 6976     SQL
    Server Driv
    0x05B694E0 : 6572 5D5B 5351 4C20 5365 7276 6572 5D53    er][SQL
    Server]S
    0x05B694F0 : 4855 5444 4F57 4E20 6973 2069 6E20 7072    HUTDOWN
    is in pr
    0x05B69500 : 6F67 7265 7373 2E00 0000 0000 0000 0000
    ogress..........
    followed by a message similar to the following:
    2007-08-23-04.01.36.853000-300 I3124368H466       LEVEL: Error
    PID     : 864                  TID  : 7492        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SQLTBLP
    APPHDL  : 0-1188               APPID: STATE.LUDB2P.C112DBE59A7A
    FUNCTION: DB2 UDB, data protection, sqlpthrd, probe:440
    RETCODE : ZRC=0x8602001A=-2046689254=SQLB_BADD "Bad Database,
    Can't
    flush"
    
    This happens because when the error coccurs, the MS SQL wrapper
    returns an invalid return code to DB2.
    

Local fix

  • None. Correct the error that the MS SQL wrapper reports.
    

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

  • See LOCAL FIX.
    

Comments

APAR Information

  • APAR number

    JR27511

  • Reported component name

    MSSQL WRAPPER

  • Reported component ID

    5724N9705

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-09-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:

    JR28762

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