IBM Support

JR25839: MSSQL FEDERATED STORED PROCEDURE WHICH HAS DATE PARAMETER MAY CAUSE DB2 CRASH ON LINUX.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Create remote procedure which has "datetime" data type
    parameter. Create type mapping which maps remote "datetime" to
    DB2 "DATE". Create federated stored procedure. Call federated
    stored procedure and then it may crash DB2 instance.
    

Local fix

  • Use TIMESTAMP or TIME data type as federated stored procedure
    parameters
    

Problem summary

  • Users affected: Federation users (MS SQL Server wrapper)
    
    Problem description and summary:
    Create remote procedure that has a parameter of type "datetime".
    Create type mapping that maps remote "datetime" to DB2 "DATE".
    Create federated stored procedure.  Call federated stored
    procedure and then it may crash DB2 instance.  The top of the
    call stack looks like:
    
    --Frame--- ------Function + Offset------
    0xBFFF0258 sqloCrashOnCriticalMemoryValidationFailure + 0x002c
    0xBFFF0380 _ZN8SMemPool32diagnoseMemoryCorruptionAndCrashEjPKc +
    0x0206
    0xBFFF03D8
    _ZN8SMemPool10MemTreeGetEjjPPvPP17SqloChunkSubgroupPP12SMemLostN
    ode + 0x026c
    0xBFFF042C
    _ZN8SMemPool19allocateMemoryBlockEjjjjjPPvPP17SqloChunkSubgroupP
    P12SMemLostNodeP12SMemLogEvent + 0x00c9
    0xBFFF1300 sqlogmblkEx + 0x0275
    0xBFFF1330 _ZN17Wrapper_Utilities8allocateEjPPv + 0x0063
    0xBFFF13D0
    _ZN21FencedMssql_Utilities16convert_codepageEPhijPS0_Pij +
    0x0364
    0xBFFF1438 _ZN15Mssql_Statement12execute_callEv + 0x00db
    0xBFFF1458 _ZN15Mssql_Procedure7executeEv + 0x0084
    0xBFFF14C4 _Z21sqlqg_FMP_ExecuteProcP15sqlriRemoteProc + 0x0194
    0xBFFF156C
    _Z11sqlqgRouterP17sqlqg_FMP_RequestPP15sqlqg_FMP_ReplyP10sqlri_u
    fob + 0x188e
    0xBFFF163C
    _Z21sqlqg_Call_FMP_ThreadP17sqlqg_FMP_RequestPP15sqlqg_FMP_Reply
    + 0x0326
    0xBFFF16A8 _Z16sqlqgExecuteProcP15sqlriRemoteProc + 0x0154
    0xBFFF1708 _Z19sqlriDjxExecuteProcP8sqlrr_cb + 0x0109
    0xBFFF1724 _Z15sqlriExecThreadP8sqlrr_cbP12sqlri_opparm + 0x004d
    0xBFFF1750 _Z18sqlriDjxProcRouterP8sqlrr_cb + 0x00d4
    0xBFFF1784 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x00af
    0xBFFF1814 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x0488
    0xBFFF1854 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo +
    0x0107
    0xBFFF1914
    _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP14sqljsDDMObject +
    0x042d
    0xBFFF1978
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2
    UCinterface + 0x0063
    0xBFFF1A00 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface +
    0x027c
    

Problem conclusion

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

Temporary fix

  • See LOCAL FIX.
    

Comments

APAR Information

  • APAR number

    JR25839

  • 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-01-31

  • Closed date

    2008-02-07

  • Last modified date

    2008-02-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 February 2008