Error : SQLM_RC_MCMISS on event monitor tables after Instance Upgrade

Technote (troubleshooting)


Problem(Abstract)

After a successful instance and database upgrade, the db2diag.log contains error messages as
MESSAGE : ZRC=0x840D002A=-2079522774=SQLM_RC_MCMISS "a mandatory column is missing"
for event monitor tables.

Symptom

Error messages in db2diag.log


Cause

This is functioning as designed i.e. these errors are expected. The messages seen in the db2diag.log (SQLM_RC_MCMISS), mean that the event monitors (from previous db2 version) are missing columns that have been added since the new version.

Diagnosing the problem

After an instance and database upgrade there is a possibility users might see similar errors

as follows in the db2diag.log :
------------------------------------------------------------------------------------------------------------------------------
yyyy-mm-dd-mm.ss.ms.ns+                            LEVEL: Error
PID     : 9999999              TID : 4113           PROC : db2sysc 0
INSTANCE: INSTNAME               NODE : 000           DB   : DBNAME
APPHDL  : 0-7                  APPID: appid.host
AUTHID  : authid              HOSTNAME: hostname
EDUID   : 4113                 EDUNAME: db2agent (dbname) 0
FUNCTION: DB2 UDB, database monitor, sqmSqlTarget::validateTable, probe:1330
MESSAGE : ZRC=0x840D002A=-2079522774=SQLM_RC_MCMISS
          "a mandatory column is missing"

yyyy-mm-dd-mm.ss.ms.ns+                            LEVEL: Error
PID     : 9999999              TID : 4113           PROC : db2sysc 0
INSTANCE: INSTNAME               NODE : 000           DB   : DBNAME
APPHDL  : 0-7                  APPID: appid.host
AUTHID  : authid              HOSTNAME: hostname
EDUID   : 4113                 EDUNAME: db2agent (dbname) 0
FUNCTION: DB2 UDB, database monitor,
sqmSharedRecordTypeArray::activateSqlEvmon, probe:90
CALLED  : DB2 UDB, database monitor, sqmSqlTarget::validateTable
RETCODE : ZRC=0x840D002A=-2079522774=SQLM_RC_MCMISS
          "a mandatory column is missing"
DATA #1 : String, 15 bytes
SAP_LOCK_EVENTS

yyyy-mm-dd-mm.ss.ms.ns+                            LEVEL: Error
PID     : 9999999              TID : 4113           PROC : db2sysc 0
INSTANCE: INSTNAME               NODE : 000           DB   : DBNAME
APPHDL  : 0-7                  APPID: appid.host
AUTHID  : authid              HOSTNAME: hostname
EDUID   : 4113                 EDUNAME: db2agent (dbname) 0
FUNCTION: DB2 UDB, database monitor, sqm_evmon_mgr::restartEvmons,
probe:30
CALLED  : DB2 UDB, database monitor, sqmEvmonWriter::startMeUp
RETCODE : ZRC=0x840D002A=-2079522774=SQLM_RC_MCMISS
          "a mandatory column is missing"
DATA #1 : String, 15 bytes
SAP_LOCK_EVENTS

--------------------------------------------------------------------------------------------------------------------------------


Resolving the problem

When upgrading a database which has event monitors, the event monitors themselves need to be upgraded when they have undergone changes (contain new or changed columns) since the last version.


To upgrade the event monitors i.e the evmon tables you will need a user temporary tablespace, since it is required for stored procedure to return a resultset. So if you have one, then directly execute the evmon upgrade command else create one using command as follows:

db2 create user temporary tablespace myuserspace

Event monitor upgrade command :

db2 "call evmon_upgrade_tables(NULL, NULL, NULL, ?,?,?)"

This will fix the problem and users will no more see similar messages logged in db2diag.log.

Related information

EVMON_UPGRADE_TABLES procedure - Upgrade event monitor

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows
Installation - Database Migration

Software version:

9.5, 9.7, 9.8, 10.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

Enterprise Server

Reference #:

1643286

Modified date:

2014-04-30

Translate my page

Machine Translation

Content navigation