IBM Support

JR29026: CHANGE INPUT PARAMETER FOR SP XDBDECOMPXML100MB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An PTF on DB2 z/OS v9 added a new stored procedure
    XDBDECOMPXML100MB. The name is exactly same as in DB2 LUW but
    there is a difference in the data type for one of the input
    parameters that accepts XML document to be decomposed. In DB2
    LUW, the parameter is of BLOB type whereas in DB2 z/OS the
    parameter is of CLOB type.
    
    The DB2 Connect package (SQLC2F0A) contains static SQL CALL
    statements for all the stored procedures. As a result, customers
    with the DB2 Connect package that is earlier bound with DB2 LUW
    get an error (SQLCODE -408) while rebinding it with DB2 z/OS due
    to parameter type mismatch.
    
    Changes can be made in DB2 LUW/Connect so that it generates
    separate DB2 Connect packages for DB2 LUW and DB2 z/OS or avoids
    the usage of static SQL CALL statements. A fix in which we will
    call the XMLDECOMPXML100MB SP with a CLOB parameter if connected
    to a z/OS server or else call the SP with a BLOB as it exists
    currently.
    

Local fix

Problem summary

  • See problem description.
    

Problem conclusion

  • Problem first fixed in DB2 V9.1 Fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR29026

  • Reported component name

    DB2 CEE WINDOWS

  • Reported component ID

    5765F3001

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-16

  • Closed date

    2009-01-21

  • Last modified date

    2009-01-21

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

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

    IZ31394

Fix information

  • Fixed component name

    DB2 CEE WINDOWS

  • Fixed component ID

    5765F3001

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 January 2009