Archives of the TeradataForum

Message Posted: Wed, 25 Jun 2003 @ 17:47:04 GMT

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

I would suggest using the TableSize. An empty table generally has a header of 1K / AMP. (Allow 1.5 or 2K if you want to be sure not to miss any empty tables and dont mind a few false positives.)

Therefore on a 50 AMP system look for tables < 50K in size. (Use the dbc.tablesize view and sum across vprocs)

If you are running V2R5 you might want to update (correct) the view to reference the TVMName and DatabaseName columns rather then the 'suffix I' columns.

Alternatively you could use UPPER() around the join columns, or use the specific '(NOT CS)' modifier. (The above change is only required if you are using ANSI mode.)

Mike Dempsey
Teradata Client Tools

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