Database lock by METASTAGE_LOCK_INFO

JPalatianos · Post by **JPalatianos** » Mon Oct 27, 2008 12:44 pm

Hi,
Our process ID keeps getting locked out.....Our DBA has traced the issue back to something called METASTAGE_LOCK_INFO .
Has anyone heard of this?
Thanks - - John

lstsaur · Post by **lstsaur** » Mon Oct 27, 2008 1:36 pm

No, the table is called XMETALOCKINFO. Tell your DBA to clean all the entries in that table.

chulett · Post by **chulett** » Mon Oct 27, 2008 1:39 pm

All entries? Is that safe or should it be more of a tactical strike?

JPalatianos · Post by **JPalatianos** » Mon Oct 27, 2008 1:43 pm

I'm sorry for the confusion...it is a Mainframe process id that get's locked. We connect to the mainframe via ODBC. It is the Mainframe DBA that repoprted to us that a process called "METASTAGE_LOCK_INFO" is causing our process id to get locked out of the database.