|
Problem IC72958
|
Status: Closed |
STMT_CONC CONVERTS PASSTHRU STATEMENTS TO PARAMETER MARKER THAT PASSTHRU DOESN'T SUPPORT. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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
--------------------------------------- |
| 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. *
**************************************************************** |
| Local Fix: |
Turn off stmt_conc in local data sources. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
Turn off stmt_conc in local data sources. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.12.2010
22.02.2011
22.02.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
