Fixes are available
APAR status
Closed as fixed if next.
Error description
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
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 = <mqt_name> AND VIEWSCHEMA = <mqt_schema>;
Problem summary
**************************************************************** * USERS AFFECTED: * * 250 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.6 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT26451
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-09-27
Closed date
2021-03-22
Last modified date
2021-03-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
RB50 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 May 2022