DB2 - Problembeschreibung
Problem IC96699 | Status: Geschlossen |
INSTANCE MIGHT TRAP WHILE EXECUTING PL/SQL ANONYMOUS BLOCK STATEMENT IF ADDRESS CONNECTION IS USED FOR WORKLOAD ASSIGNMENT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Database instance might trap while executing PL/SQL anonymous block statement if ADDRESS connection attribute is used for workload assignment. Stack similar to the one below might be find the trap file: sqlrwEvaluateWlDefs sqlrwPerformWorkloadAssignment sqlrwAssignWorkload sqlrwWLMCommonPre sqlrr_non_sql_request_pre sqlrr_pkg_pre sqlrr_prepinit psmPackageGen::initialize psmPVMCodeGenerator::genProgram psm_ctrl::psm_generate_PVM() psm_gen_program sqlnq_compiled_anon_block sqlnp_smactn sqlnp_parser sqlnp_main sqlnn_cmpl sqlnn_cmpl sqlra_compile_var sqlra_get_var sqlrr_prepare sqlraProcessPrepAnonBlock sqleIndCoordProcessRequest | |
Problem-Zusammenfassung: | |
Problem Summary: INSTANCE MIGHT TRAP WHILE EXECUTING PL/SQL ANONYMOUS BLOCK STATEMENT IF ADDRESS CONNECTION IS USED FOR WORKLOAD ASSIGNMENT Users Effected: All users Problem Description: Database instance might trap while executing PL/SQL anonymous block statement if ADDRESS connection attribute is used for workload assignment. Stack similar to the one below might be find the trap file: sqlrwEvaluateWlDefs sqlrwPerformWorkloadAssignment sqlrwAssignWorkload sqlrwWLMCommonPre sqlrr_non_sql_request_pre sqlrr_pkg_pre sqlrr_prepinit psmPackageGen::initialize psmPVMCodeGenerator::genProgram psm_ctrl::psm_generate_PVM() psm_gen_program sqlnq_compiled_anon_block sqlnp_smactn sqlnp_parser sqlnp_main sqlnn_cmpl sqlnn_cmpl sqlra_compile_var sqlra_get_var sqlrr_prepare sqlraProcessPrepAnonBlock sqleIndCoordProcessRequest | |
Local-Fix: | |
Do not run PL/SQL anonymous block statements or disable WLM workloads that use the ADDRESS connection attribute | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.10.2013 03.09.2014 03.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |