Archives of the TeradataForum

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

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

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>>