Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 04 Jun 2012 @ 16:07:23 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023