IBM Support

IT34425: HANGING QUERY IN CLOB TYPE STATEMENTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Hanging query in case of a small but specific exceeding of the
    limit.
    e.g. select length(t.a) from table(test_clob(4 * 1024 * 1024 +
    5)) t (a clob);
    
    Size of CLOB in DB2GENERAL java style.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Hanging query in case of a small but specific exceeding of   *
    * the                                                          *
    * limit.                                                       *
    * e.g. select length(t.a) from table(test_clob(4 * 1024 * 1024 *
    * +                                                            *
    * 5)) t (a clob);                                              *
    *                                                              *
    * Size of CLOB in DB2GENERAL java style.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to product version V11.1 m4 fp6                      *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT34425

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-10-02

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

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

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
01 April 2021