IBM Support

JR19934: AN EFFICIENT EXPLAIN PLAN IS NOT GENERATED FOR QUERIES THAT CONTAIN THE CONCAT FUNCTION IN THE SELECT LIST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • when a query includes CONCAT or similar operators in the select
    list, the V8 explain plan generated is less efficient than the
    plan generated in V7. If the arguments with the CAST function,
    then the plan is simular to that of V7.
    

Local fix

Problem summary

  •  This probelm is fixed in DB2 II 8.2..
    

Problem conclusion

  •  Apply DB2 II 8.2..
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR19934

  • Reported component name

    IBM INFO INTEGR

  • Reported component ID

    5724C7400

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2004-04-21

  • Closed date

    2004-09-15

  • Last modified date

    2023-08-05

  • 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

    IBM INFO INTEGR

  • Fixed component ID

    5724C7400

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 August 2023