IBM Support

IT05466: LARGE QUERY STUCK IN PARSING CAUSING ENGINE TO HANG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • A significantly large query with a number of CASE operators and
    ANSI joins is run and the session hangs.  Attempts to kill the
    session with 'onmode -z <sid>' command do not work and onmode
    hangs.  A pstack or procstack run against the VP on which the
    thread is running finds a stack trace similar to this:
    
    
    old_do_rualloc ()
    old_rualloc ()
    gtexpnode ()
    val2expr ()
    expr2expr ()
    expr2expr ()
    expr2expr ()
    expr2expr ()
    expr2expr ()
    expr2expr ()
    expr2expr ()
    prjlst2expr ()
    sel2cb ()
    qblk2cb ()
    stmt2cb ()
    p_sp2cb ()
    parsecmd ()
    sqcmd ()
    sq_cmnd ()
    sq_prepare ()
    sqmain ()
    spawn_thread ()
    th_init_initgls ()
    startup ()
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * users using CASE expression                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 12.10.xC5 or earlier PID if available             *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT05466

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-11-10

  • Closed date

    2015-10-16

  • Last modified date

    2015-10-16

  • 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

  • RA10 PSN

       UP

  • RA10 PSY

       UP

  • RB10 PSN

       UP

  • RB10 PSY

       UP

  • RC10 PSN

       UP

  • RC10 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 October 2015