IBM Support

IZ29975: USING DB2 CLI SQLGETDATA2() WITH LOBS MAY RETURN WRONG LENGTH OF THE REMAINING DATA PIECE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQLGetData() on LOB columns is called repeatedly () to get the
    remaining pieces of data until it returns SQL_SUCCESS,
    signifying that the entire data has been retrieved for this
    column.
    
    This APAR is documenting the fact that under very rare
    circumstances the SQLGetData() call may return the wrong data
    length in the pcbValue. The circumstances are very much
    depending on the sequence in which sizeh of pieces data was
    previously retrieved and how large an internal CLI buffer was
    allocated. This problem causes data to be missing within the
    application.
    
    Additionally in this scenario the call returns SQL_SUCCESS while
    it should have returned SQL_SUCCESS_WITH_INFO to indicate more
    data exists.
    

Local fix

Problem summary

  • Users Affected: ALL
    
    Problem Description:
    
    SQLGetData() on LOB columns is called repeatedly () to get the
    remaining pieces of data until it returns SQL_SUCCESS,
    signifying that the entire data has been retrieved for this
    column.
    
    This APAR is documenting the fact that under very rare
    circumstances the SQLGetData() call may return the wrong data
    length in the pcbValue. The circumstances are very much
    depending on the sequence in which sizeh of pieces data was
    previously retrieved and how large an internal CLI buffer was
    allocated. This problem causes data to be missing within the
    application.
    
    Additionally in this scenario the call returns SQL_SUCCESS while
    it should have returned SQL_SUCCESS_WITH_INFO to indicate more
    data exists.
    
    Problem Summary:  See Problem Description.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 7 (build s090308)
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ29975

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-08-19

  • Closed date

    2009-04-07

  • Last modified date

    2009-04-07

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

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

    IZ31199 IZ32887

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

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

Document Information

Modified date:
04 October 2021