Hi All,

I have some ODBC processes that have been locking tables that I work
with, causing lock issues later at night when we run our billing and
datawarehousing programs. Since this began about a week ago, I have
found the issue but I continue to double check that I'm not locking
anything by doing a WRKOBJLCK command every evening before I leave,
for each file that I've had the locking issues with.

Of course, doing this manually gets cumbersome. There must be some
way to automate this check, and having a limited iSeries background I
prefer to do it in DB2-SQL so that I can set up a Windows/SQL Server-
based solution.

What I don't know is any DB2-SQL commands that accomplish the same
thing as WRKOBJLCK, returning information about any locks that exist.
Is there a table I can query against or a function call that I can
make that would return information about locks?

Thanks in advance for your responses!

CW