IBM Support

LI74678: THE RTRIM UDF MAY ABEND INSTANCE WHEN USED ON EMPTY DBCLOB COLUMN IN THE SELECT SQL STATEMENT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The instance may abend when the RTRIM UDF is used on empty
    DBCLOB column. Please consider the following SQL statements:
    
    create table test(name dbclob(1G) not logged);
    insert into test values ('');
    select RTRIM(SUBSTR(name, 1, 10)) from test;
    
    The instance may abend with the similar call stack
    
    0x000000000000F410 ?unknown + 0x0
    0x090000006E4FEA50 memcpy__FPvPCvUl + 0x3C
    0x090000006E502D90 sqlo_md_mcpy + 0x204
    0x09000000708B52D4
    sqlrimso__FP8sqlrr_cbP9sqllf_csoPUcPUiUiisPPvT6 + 0x18DC
    0x09000000708B58B8
    sqlrimso__FP8sqlrr_cbP9sqllf_csoPUcPUiUiisPPvT6 + 0x1EC0
    0x0900000070BE2DF4 sqlriGetArgs__FP8sqlrr_cbP10sqlri_ufob +
    0xAC8
    0x0900000070BDF820 sqlriInvokeInvoker__FP10sqlri_ufob + 0x230
    0x0900000070BDF1F4 sqlriusf__FP8sqlrr_cb + 0x53C
    0x0900000070886B5C sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm +
    0x60C
    0x09000000708860AC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x4A8
    0x0900000070F57FE8
    sqlrr_process_fetch_request__FP14db2UCinterface + 0x7B8
    0x0900000070F56CEC
    sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0xB00
    0x0900000073277550
    sqljs_ddm_cntqry__FP14db2UCinterfaceP14sqljsDDMObject + 0x1E4
    0x0900000073255684
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14d
    b2UCinterface + 0x180
    

Local fix

  • n/a
    

Problem summary

  • Users affected: All
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74678

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-18

  • Closed date

    2009-12-15

  • Last modified date

    2009-12-15

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

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

    IC61764

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       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:
15 December 2009