Question & Answer
Question
When using Data Stores with the Maximo Integration Framework (MIF) why do I see exclusive locks on the SIBOWNER and SIBOWNER0 tables?
Answer
This is working as designed.
The following documentation describes the exclusive lock on the SIB tables for Websphere 7.
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-nd-dist&topic=cjm0450
Please review this information on backup of SIB tables related to the exclusive lock.
https://www.ibm.com/developerworks/community/blogs/aimsupport/entry/backup_considerations_websphere_process_server?lang=en
Note that starting in Websphere 8.5, there have been changes which allow you to configure the Message Engine to use Short Duration locks. It must be configured when the Message Engine is created.
Webcast Replay: New Enhancements to the SIBus in WebSphere Application
Server V8.5:
http://www-01.ibm.com/support/docview.wss?uid=swg27039490
The third part, Short Duration Database Locks, explains the change..
Page 14 of the PDF presentation shows how to do that.
"Restrict long running locks" feature
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21903661