IBM Support

IT31976: IF UPDATE STATISTICS FOR PROCEDURE HAS TO CALL AUTOREGEXE IT MAYHANG THE SCHEDULER AND THE CALLING SESSION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The reproduction environment defines a  Database containing
    Stored procedures calling Datablade functions.
    When an Update statistics for procedure has to call the
    autoregexe task from the scheduler because
    of a missing registration of the base datablade in the database
    and some internal functions like
    SYSBldSQLTextIn or SYSBldSQLTextOut are missing in the database
    a deadlock situation may occur with
    the following representation :
    
    The user session calling the Update statistics hang in
    
    yield_processor_svp
    mt_yield
    ph_submit_task
    dbcron_submit_task
    ifknowncreate
    udr_determine
    expr_determine
    common_routine2expr
    expr2expr
    op_bind_rtn
    ....
    
    pr_compile
    aud_pr_compile
    updprocstat
    
    The first scheduler worker show the stack
    
    mt_call_size
    mi_call_size
    autoregexe
    udrlm_clang_execute_internal
    udrlm_clang_execute
    udrlm_exec_routine
    udr_execute
    mi_routine_exec
    ph_exec_func
    ph_execute
    do_task
    ....
    
    The second scheduler worker
    
    yield_processor_mvp
    mt_yield
    lkwait
    lkmanagex
    lkrow
    rsread
    fmread
    creatproc
    aud_creatproc
    excommand
    sq_execute
    mi_exec
    QUERunQuery
    SYSBldLogCallback
    SYSBldParseScript
    SYSBldRunSQLFile
    SYSBldInit
    SYSBldPrepare
    SYSBldPrepare2
    registerBlade
    SYSBldCreate
    SYSBldCustomPrepare
    
    In this situation the user session cannot be stopped by onmode
    -z, a long tx will happen which cannot be rollbacked without
    restart
    and the scheduler is blocked.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4.  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 12.10.xC15 (when available) or    *
    * 14.10.xC4.                                                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31976

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-25

  • Closed date

    2020-12-10

  • Last modified date

    2020-12-11

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
14 December 2020