IBM Support

IZ43314: NULLPOINTEREXCEPTION MAY OCCUR USING BLOB,CLOB,DBCLOB,OR XML OUT PARAMTERS ON CALLABLESTATEMENT IF PROGRESSIVE STREAMING ENABLED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Type-4 and Type-2 LUW Connectivity:
    
    When connecting to DB2 for z/OS v9.1 and above, a
    NullPointerException may occur during program execution in
    the following scenario:
    
    - progressiveStreaming is enabled (default)
    - The application has one of the following:
    -- A Callable Statement with a BLOB, CLOB, DBCLOB, or XML
       OUT or INOUT parameter.
    -- A select into a SQLJ BLOB, CLOB, DBCLOB or DB2Xml host
       variable.
    - The statement is used more than once.
    
    This problem does not occur when progressive streaming is
    disabled, or when running against DB2 for Linux, Unix, and
    Windows.
    

Local fix

  • Disable progressive streaming
    

Problem summary

  • Users Affected: All users
    
    Problem Description:
    Type-4 and Type-2 LUW Connectivity:
    
    
    When connecting to DB2 for z/OS v9.1 and above, a
    NullPointerException may occur during program execution in
    the following scenario:
    
    - progressiveStreaming is enabled (default)
    - The application has one of the following:
    -- A Callable Statement with a BLOB, CLOB, DBCLOB, or XML
       OUT or INOUT parameter.
    -- A select into a SQLJ BLOB, CLOB, DBCLOB or DB2Xml host
       variable.
    - The statement is used more than once.
    
    This problem does not occur when progressive streaming is
    disabled, or when running against DB2 for Linux, Unix, and
    Windows.
    
    Problem Summary:
    Type-4 and Type-2 LUW Connectivity:
    
    
    When connecting to DB2 for z/OS v9.1 and above, a
    NullPointerException may occur during program execution in
    the following scenario:
    
    - progressiveStreaming is enabled (default)
    - The application has one of the following:
    -- A Callable Statement with a BLOB, CLOB, DBCLOB, or XML
       OUT or INOUT parameter.
    -- A select into a SQLJ BLOB, CLOB, DBCLOB or DB2Xml host
       variable.
    - The statement is used more than once.
    
    This problem does not occur when progressive streaming is
    disabled, or when running against DB2 for Linux, Unix, and
    Windows.
    

Problem conclusion

  • Problem was first fixed in Version 9.1 Fix Pack 8
    

Temporary fix

  • Disable progressive streaming
    

Comments

APAR Information

  • APAR number

    IZ43314

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-02-05

  • Closed date

    2010-02-25

  • Last modified date

    2010-02-25

  • 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

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R910 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"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