IBM Support

IC75053: A QUERY REFERENCING A REPLICATED MQT MIGHT FAIL WITH A SQL0901N

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Description:
    
    A query might fail with a SQL0901N error code if the following
    are true:
    1. The MQT definition is simply a select from one base table or
    multiple base tables joined together
    2. The user has enforced replicate MQT through either one of :
         i. optguidelines
         ii. DB2_EXTENDED_OPTIMIZATION=FORCE_REPLICATED_MQT_MERGE
    
    In the db2diag.log an error message such as the following may be
    seen:
    
    2011-02-02-00.37.29.943200-300 E671418998E802      LEVEL: Info
    (Origin)
    PID     : 28374                TID  : 47901128517952PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001          DB   : SAMPLE
    APPHDL  : 1-57167              APPID:
    10.139.25.214.32786.11030715355
    AUTHID  : DB2INST1
    EDUID   : 5407                 EDUNAME: db2agent (SAMPLE) 1
    FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
    MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
              "unexpected error but state is OK"
    DATA #1 : String, 257 bytes
    Compiler error stack for rc = -2144272209:
    sqlnn_cmpl[370]
    sqlnr_exe[1200]
    sqlnr_rcc[100]
    sqlnr_seq[100]
    sqlnr_comp[110]
    sqlnr_optprep_action[100]
    sqlnr_optprep[2240]
    sqlnr_compute_matchinfo[600]
    sqlnq_som::compute_matchin[360]
    sqlnq_mch::cleanUpForOpt[50]
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * A query that has an MQT definition as a select from one base *
    * table or multiple base tables joined together and where the  *
    * user has enforced replicate MQT through optguidelines or     *
    * DB2_EXTENDED_OPTIMIZATION=FORCE_REPLICATED_MQT_MERGE may     *
    * result in a SQL0901N error.                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 5.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75053

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-15

  • Closed date

    2012-01-03

  • Last modified date

    2012-01-03

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 January 2012