IT26451: DB2 MAY ABEND WHEN ATTEMPTING TO REVALIDATE A MATERIALIZED QUERYTABLE

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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 is sysrouted FROM one or more of the following:

  IT26449

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• RB50 PSY

     UP