IBM Support

IC81838: CLI/.NET APPLICATIONS FAIL WITH SQL30020N/SQL30081N WHEN EXECUTI NG A STORED PROCEDURE WITH A RETURN VALUE, AND LOB IN PARAMETER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If a stored procedure has a return value and LOB IN parameter
    that requires streaming the LOB data, then executing the
    procedure can fail with one of the following messages:
    
    SQL30020N  Execution of the
    command or SQL statement failed because of a syntax error in the
    communication data stream that will affect the successful
    execution of subsequent commands and SQL statements:  Reason
    Code "0x124C"("020A")"".  SQLSTATE=58009
    
    or
    
    SQL30081N  A communication error has been detected.
    Communication protocol being used: "TCP/IP".  Communication API
    being used: "SOCKETS".  Location where the error was detected:
    "141.128.71.208".  Communication function detecting the
    error:"recv".  Protocol specific error code(s): "*", "*", "0".
    SQLSTATE=08001
    
    This can occur in one of the following cases:
    
    - A .NET application that uses
    DB2CommandBuilder.DeriveParameters()
    OR
    -  A CLI application that has CALL statement with explicit
    parameter for return value of the form "{?=call proc(?)}".
    

Local fix

  • As a work-around explicitly set the LOB parameter size to 0 in
    .NET applications.
    
    For example the sample code would look like:
    
                    cmd.Parameters["IN_LOB_PARAM"].Size = 0;
    //IN_LOB_PARAM is LOB IN parameter
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * CLI/.NET APPLICATIONS FAIL WITH SQL30020N/SQL30081N WHEN     *
    * EXECUTI                                                      *
    * NG A STORED PROCEDURE WITH A RETURN VALUE, AND LOB IN        *
    * PARAMETER                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 6                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81838

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-03-06

  • Closed date

    2012-11-14

  • Last modified date

    2012-11-14

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

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

    IC84519 IC88221

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC81838

Modified date: 14 November 2012