IBM Support

JR29506: -30005 WHEN ISSUING DELETE OR UPDATE OPERATIONS WITH ARRAY INPUT AGAINST DB2 FOR Z/OS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A CLI application performing an array input with DELETE or
    UPDATE statements may receive an SQLCODE of -30005 from DB2 for
    z/OS if the size of the array (the number of rows)  is larger
    than 32760.
    .
    DB2 for z/OS does not support the delete or update operation
    when using parameter-wise array input, so CLI will submit the
    request as a chain of EXECUTE requests.  There is a maximum of
    32760 statements that can be chained at one time.  Surpassing
    this limit would cause an exception.  This APAR will allow DB2
    Connect to split the chain up so that the limitation is not
    reached.
    .
    An exception may also occur with an array input request for
    INSERT or MERGE statements if the number of rows is greater than
    32767. DB2 for z/OS does support the insert and merge operations
    when using parameter-wise array input, but the number of rows is
    limited to 32767. This APAR fix will cause the  insert and merge
    array input requests that exceed this limit to be sent as chains
    of execute statements.
    

Local fix

  • Change the application by limiting the array size to less than
    32K
    

Problem summary

  • Users Affected:   CLI application connecting to DB2 for z/OS
    Problem Description:
    A CLI application performing an array input with DELETE or
    UPDATE statements may receive an SQLCODE of -30005 from DB2 for
    z/OS if the size of the array (the number of rows)  is larger
    than 32760.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, Fixpak 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR29506

  • Reported component name

    DB2 CEE WINDOWS

  • Reported component ID

    5765F3001

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-06-06

  • Closed date

    2009-03-09

  • Last modified date

    2009-03-09

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

    JR29440

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

Fix information

  • Fixed component name

    DB2 CEE WINDOWS

  • Fixed component ID

    5765F3001

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 March 2009