I have a Notes database that does an SQL call to a DB2/400 database via an ODBC link to select and pull down records. It has worked for days at a time, but lately it has started to fail, and be timed out by the server. We’ve done a few work-arounds, but have come to the conclusion that the table is locked when we are doing our call. (We recently set the agent to run more frequently, hence the greater occurance of the problem).
Is there a way of detecting the lock status of the DB2/400 table, so we can just close down the agent cleanly? At the moment it errors out, and sets a safety flag in the NSF, which then requires human intervention to find out what the problem was before resetting the flag.