Messaging Engine - has failed to gain an initial lock on the data store (8 of 285 technotes for 2015)

Messaging Engine - is attempting to obtain an exclusive lock on the data store.
Messaging Engine - has failed to gain an initial lock on the data store.

Root Cause - 

An unclean shutdown could left lock owner information down to the database level. so when you bring up the server, it trying to get the same lock, but in the sibowner table, you already had one entry which tell the websphere process server, the lock already have an owner.

Action

Please delete all the tables with schema name like “CMN%” i.e. 

DROP INDEX CMNCM00.SIB000PKIX;
DROP INDEX CMNCM00.SIB000STREAMIX;
DROP TABLE CMNCM00.SIB000;
DROP INDEX CMNCM00.SIB001PKIX;
DROP INDEX CMNCM00.SIB001STREAMIX;
DROP TABLE CMNCM00.SIB001;
DROP INDEX CMNCM00.SIB002PKIX;
DROP INDEX CMNCM00.SIB002STREAMIX;
DROP TABLE CMNCM00.SIB002;
DROP TABLE CMNCM00.SIBCLASSMAP;
DROP TABLE CMNCM00.SIBKEYS;
DROP TABLE CMNCM00.SIBLISTING;
DROP TABLE CMNCM00.SIBOWNER;
DROP TABLE CMNCM00.SIBOWNERO;
DROP TABLE CMNCM00.SIBXACTS;
DROP INDEX CMNSA00.SIB000PKIX;
DROP INDEX CMNSA00.SIB000STREAMIX;
DROP TABLE CMNSA00.SIB000;
DROP INDEX CMNSA00.SIB001PKIX;
DROP INDEX CMNSA00.SIB001STREAMIX;
DROP TABLE CMNSA00.SIB001;
DROP INDEX CMNSA00.SIB002PKIX;
DROP INDEX CMNSA00.SIB002STREAMIX;
DROP TABLE CMNSA00.SIB002;
DROP TABLE CMNSA00.SIBCLASSMAP;
DROP TABLE CMNSA00.SIBKEYS;
DROP TABLE CMNSA00.SIBLISTING;
DROP TABLE CMNSA00.SIBOWNER;
DROP TABLE CMNSA00.SIBOWNERO;
DROP TABLE CMNSA00.SIBXACTS;
DROP INDEX CMNSS00.SIB000PKIX;
DROP INDEX CMNSS00.SIB000STREAMIX;
DROP TABLE CMNSS00.SIB000;
DROP INDEX CMNSS00.SIB001PKIX;
DROP INDEX CMNSS00.SIB001STREAMIX;
DROP TABLE CMNSS00.SIB001;
DROP INDEX CMNSS00.SIB002PKIX;
DROP INDEX CMNSS00.SIB002STREAMIX;
DROP TABLE CMNSS00.SIB002;
DROP TABLE CMNSS00.SIBCLASSMAP;
DROP TABLE CMNSS00.SIBKEYS;
DROP TABLE CMNSS00.SIBLISTING;
DROP TABLE CMNSS00.SIBOWNER;
DROP TABLE CMNSS00.SIBOWNERO;
DROP TABLE CMNSS00.SIBXACTS;

commit;