IBM Support

JR30975: Microsoft SQL SERVER MAY CAUSE DB2 CRASH.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Microsoft SQL Server wrapper may get some invalid data when
    Microsoft SQL Server shutdown, which causes DB2 crash.
    
    You may get the following error in db2diag.log before the crash.
    ...
    2008-10-14-20.16.31.630000-300 I94200164H1147     LEVEL: Error
    PID     : 2424                 TID  : 4736        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   :
    CCSQLSVR
    APPHDL  : 0-16                 APPID: *LOCAL.DB2.081013210424
    AUTHID  : SVCITCINS1
    EDUID   : 4736                 EDUNAME: db2agent (CCSQLSVR) 0
    FUNCTION: DB2 UDB, mssql wrapper, Mssql_Server::get_error_info,
    probe:7
    MESSAGE : ODBC error txt:
    DATA #1 : Hexdump, 144 bytes
    0x4F5B1540 : 5B4D 6963 726F 736F 6674 5D5B 4F44 4243
    [Microsoft][ODBC
    0x4F5B1550 : 2053 514C 2053 6572 7665 7220 4472 6976     SQL
    Server Driv
    0x4F5B1560 : 6572 5D5B 5351 4C20 5365 7276 6572 5D53    er][SQL
    Server]S
    0x4F5B1570 : 4855 5444 4F57 4E20 6973 2069 6E20 7072    HUTDOWN
    is in pr
    0x4F5B1580 : 6F67 7265 7373 2E00 0000 0000 0000 0000
    ogress..........
    0x4F5B1590 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x4F5B15A0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x4F5B15B0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x4F5B15C0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    

Local fix

  • Create wrapper using FENCED Y server option:
    
    ALTER WRAPPER <wrappername> OPTIONS (SET DB2_FENCED 'Y')
    

Problem summary

  • Users affected:
       Users of the MSSQL wrapper in InfoSphere Federation Server
    Problem description and summary:
       See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.5, FixPak 4 (s090429). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30975

  • Reported component name

    FEDERATED RUNTI

  • Reported component ID

    5724N9703

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-03

  • Closed date

    2009-05-30

  • Last modified date

    2009-05-30

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

    JR30964

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

    JR30997

Fix information

  • Fixed component name

    FEDERATED RUNTI

  • Fixed component ID

    5724N9703

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
30 May 2009