IBM Support

IC72958: STMT_CONC CONVERTS PASSTHRU STATEMENTS TO PARAMETER MARKER THAT PASSTHRU DOESN'T SUPPORT.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When a database configuration parameter "stmt_conc"(Statement
    concentrator configuration parameter) is set to LITERALS with
    federation servers, applications or db2 components(like db2
    Health Monitor) which call passthru directly may be fire the
    APAR.
    
    Key point is that stmt_conc and passthru can not work together.
    Because passthru doesn't support parameter marker; while
    stmt_conc is converting stmt to parameter marker. Two phenomenon
    can be observed, one is the endless loop; one is the wrong
    result.
    
    This callstacks may be observed in infinite loop.
    ---------------------
    sqlra_find_var_env
    sqlra_find_vars
    sqlra_statement_concentrator
    
    sqlra_find_var_var
    sqlra_find_var
    sqlra_statement_concentrator
    
    
    sqlra_find_var_env
    sqlra_find_vars
    sqlra_statement_concentrator
    ---------------------------------------
    

Local fix

  • Turn off stmt_conc in local data sources.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * STMT_CONC CONVERTS PASSTHRU STATEMENTS TO PARAMETER MARKER   *
    * THAT                                                         *
    * PASSTHRU DOESN'T SUPPORT.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When a database configuration parameter                      *
    * "stmt_conc"(Statement                                        *
    * concentrator configuration parameter) is set to LITERALS     *
    * with                                                         *
    * federation servers, applications or db2 components(like db2  *
    *                                                              *
    * Health Monitor) which call passthru directly may be fire the *
    *                                                              *
    * APAR.                                                        *
    *                                                              *
    *                                                              *
    *                                                              *
    * Key point is that stmt_conc and passthru can not work        *
    * together.                                                    *
    * Because passthru doesn't support parameter marker; while     *
    *                                                              *
    * stmt_conc is converting stmt to parameter marker. Two        *
    * phenomenon                                                   *
    * can be observed, one is the endless loop; one is the wrong   *
    *                                                              *
    * result.                                                      *
    *                                                              *
    *                                                              *
    *                                                              *
    * This callstacks may be observed in infinite loop.            *
    *                                                              *
    * ---------------------                                        *
    *                                                              *
    * sqlra_find_var_env                                           *
    *                                                              *
    * sqlra_find_vars                                              *
    *                                                              *
    * sqlra_statement_concentrator                                 *
    *                                                              *
    *                                                              *
    *                                                              *
    * sqlra_find_var_var                                           *
    *                                                              *
    * sqlra_find_var                                               *
    *                                                              *
    * sqlra_statement_concentrator                                 *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * sqlra_find_var_env                                           *
    *                                                              *
    * sqlra_find_vars                                              *
    *                                                              *
    * sqlra_statement_concentrator                                 *
    *                                                              *
    * ---------------------------------------                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v97FP4.                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

  • Turn off stmt_conc in local data sources.
    

Comments

APAR Information

  • APAR number

    IC72958

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-02

  • Closed date

    2011-02-22

  • Last modified date

    2011-02-22

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC72958

Modified date: 22 February 2011