Archives of the TeradataForum
Message Posted: Mon, 18 Aug 2003 @ 14:46:41 GMT
Subj: | | Sessions holding locks after query completes? |
|
From: | | McBride, Michael |
I have been getting ETL sessions that do renames on tables getting blocked by end users "sessions" that are idle. In other words, the
query that had an "access" lock on the table (via a view) is complete, the session is "idle" but the ETL sessions continues to be blocked.
The blocking user session is initiated from Cognos Impromptu. When the user ends the session by closing the catalog, then the lock is
released and the ETL is unblocked...
When a session is idle and a query has completed, including all response, shouldn't the locks for that query be released by the
database???
This is what the logger utility is reporting...
---------------- AMP 0 REPORTS 2 LOCK ENTRIES -------------
GRANTED LOCK REQUEST(S):
Tran: 16380 00AC04F2
Host: 1025 Session: 4,64056 Mode: Ac User: XXXXXXX
Database: AEO_PRODDB Table: DAILY_STORE_INVN_8DN
BLOCKED LOCK REQUEST(S):
Tran: 16383 00937B5E
Host: 2049 Session: 4,64207 Mode: EX User: AEOBATCH
Database: AEO_PRODDB Table: DAILY_STORE_INVN_8DN
User AEOBATCH is in the "BLOCKED" session Report
User XXXXXX is in the "IDLE session Report
|