Archives of the TeradataForum

Message Posted: Wed, 02 Apr 2003 @ 18:49:14 GMT

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

Is there a way to populate all queries sent to the warehouse into one table???

Does PMON have a command line or API that would capture all the queries into one table?

I know there are tools, if used, will consolidate the queries sent through using the particular tool but may not capture all of the queries sent to Tdat.

The Accesslogging table may truncate large queries and the accesslog table is a hog with a bad index.... So, my question stands... Is there a way to consolidate all the queries into a single table?

Thanks for your thoughts and comments. I understand the V2R5 will have this resolved for future use so maybe I should simply wait...

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