IBM Support

IZ50321: EDU TRAP AND SQLCODE -1131 WHEN EXPLAINING QUERIES WITH NON-SUBQUERY PREDICATES VIA DATA STUDIO.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • EDU trap and sqlcode -1131 when explaining queries
    with non-subquery predicates via Data Studio.
    
    Stack trace may look like this:
    
     <StackTrace>
    ##### Object: /lib/sparcv9/libc.so.1
    strlen
    _doprnt
    vsnprintf
    ##### Object: /apps/IBM/db2/V9.5/bin/routine/db2cadm
    bufferLogPrintf
    fmt_PREDICATE
    process_predicates
    process_plan
    process_statements
    formatExplain
    get_explain
    ##### Object: /apps/IBM/db2/V9.5/lib64/libdb2.so.1
    sqloInvokeFnArgs
    sqlerDyload
    sqlerDyload
    sqlerFmpListener
    ##### Object: /occ/db2/db2insu2/sqllib/adm/db2fmp
    main(0x0,0x0,0x0,0x8,0x9c8,0x19200000) + 0xa90
    _start(0x0,0x0,0x0,0x0,0x0,0x0) + 0x17c
    
    Crash is more likely to occur on Windows and solaris platforms.
    

Local fix

  • Use the explain facility to get the access plan.  For example,
    ues EXPLAIN PLAN FOR statement to populate explain tables with
    explain data, and then format the plan with db2exfmt.
    

Problem summary

  • Users Affected: All Users
    Problem Description: Using Visual Explain from data Studio to
    explain a query with non-subquery predicates may cause an EDU
    trap and sqlcode -1131 is reported.
    

Problem conclusion

  • Problem was first fixed in Version 9.1 Fix Pack 8.
    

Temporary fix

  • Use the explain facility to get the access plan.  For example,
    ues EXPLAIN PLAN FOR statement to populate explain tables with
    explain data, and then format the plan with db2exfmt.
    

Comments

APAR Information

  • APAR number

    IZ50321

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-28

  • Closed date

    2009-10-27

  • Last modified date

    2009-10-27

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

    IZ50148

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

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 October 2009