 |
 |
Archives of the TeradataForum
Message Posted: Mon, 04 Jun 2012 @ 16:07:23 GMT
Subj: | | Re: How to know the Aborted Session Details |
|
From: | | Md, Asifuddin |
| My TransientJournal is going up and down since long time.. As i do not have TM installed/ access to it, I have checked there are no queries
in aborting state in PMON... | |
| Can you please let me know if any other way to find out which query was aborted and by whom ? | |
Reco:
Please Start with DBQL if it is enabled to correlate with user/session w.r.t errorcode. If no TDWM criteria is in place, I am thinking of
space and /or spool isssues with user/db.
If DBQL is not enabled, I would suggest to start enabling for the effected user. There are many tables as part of DBC (if you can get access
to). AMPusage/logonoff/Eventlog to correlate with.
-Asif
| |