|
Problem IT26449
|
Status: Geschlossen |
DB2 MAY ABEND WHEN ATTEMPTING TO REVALIDATE A MATERIALIZED QUERYTABLE
|
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
DB2 may abend when attempting to revalidate a Materialized Query
Table (MQT). MQTs should not be marked as invalid.
Here's an example stack trace of the problem:
ossDumpStackTraceInternal
ossDumpStackTraceV98
OSSTrapFile::dumpEx
sqlo_trce
sqloEDUCodeTrapHandler
__restore_rt
sqlnn_regen_view
sqlrl_regen_view
sqlnq_check_referenced_qtb
sqlnq_check_referenced_qtb
sqlnq_handle_from_table_ref
sqlnq_expand_stmt
sqlnp_smactn
sqlnp_parser
sqlnp_main
sqlnq_handle_sql_stmt
sqlnq_expand_mst
sqlnq_sem_refresh_table_full
sqlnq_sem_refresh_table
sqlns_imm_checked_noexcp
sqlnq_set_constraints
sqlnp_smactn
sqlnp_parser
sqlnp_main
sqlnn_cmpl
sqlnn_cmpl
sqlra_compile_var
sqlra_find_var
sqlra_get_var
sqlri_ddl_get_section
sqlri_ddl_common
sqlriddl
sqlriSectInvoke
sqlrr_execute_immediate
sqlrr_execimmd
sqljs_ddm_excsqlimm
sqljsParseRdbAccessed
sqljsParse
sqljsSqlam
sqljsDriveRequests
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
sqeAgent::RunEDU
sqzEDUObj::EDUDriver
sqloEDUEntry
start_thread
clone |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All A50 users. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* For now use the workaround to fix the issue and problem may *
* be fixed in future release. *
**************************************************************** |
| Local-Fix: |
Drop and recreate the MQT so that it is no longer invalid.
This query can be used to check the validity of a MQT:
SELECT VALID FROM SYSCAT.VIEWS WHERE VIEWNAME =
AND VIEWSCHEMA = ; |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger :
Nachfolger : IT26451 |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.09.2018
10.03.2020
10.03.2020 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
