Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 23 Aug 2002 @ 08:21:46 GMT


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


Subj:   Re: Trace of use of volatile table
 
From:   Street, John

The DBC.AllTempTables is for Global Temporary tables. The purely user local volatile tables are not put in that table.

one way would to track the use would to be have access logging turned on for the users for create table in their own database. then the accesslog will have the information stored, this will show details of how many users and tables were created in retrospect.

Another off the wall idea to track this, is to identify all users that are idle and if they have spool Then that point to the fact that they have a volatile table created in their spool allocation at present. You would have to grow your own processes for this by identifying users that are idle via PMON apis and use this idle list to look at current spool.


Cheers

John Street
Senior Principal Consultant,
Relationship Technology Solutions for Financial Services,
NCR Limited



     
  <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: 27 Dec 2016