Archives of the TeradataForum

Message Posted: Sun, 16 Aug 2009 @ 21:07:39 GMT


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

Subj:		Re: Teradata Data Dictionary and DBQL

From:		Joerg Mutsch

Hi Geoffrey,

thanks for your reply.

I'm not sure what you mean. You connect to a PE, not to the Data Dictionary; and once a connection has been made (CLI, ODBC, or JDBC), the priority is set by TDWM or PSF. The priority of a request depends on the account string, not the connection type.

Basically I agree. But when I am thinking of 3rd party tools (regardless if ETL, Front End or anything else) which are accessing the Data Dictionary even with the same user, I will definitely have a less responsive access time compared to accessing a 'regular' database. I was talking to some Teradata Consultants which confirmed that Teradata is handling this kind of access with a quite low priority. Well I can not say if this has to be set or has been set by the DBA or if this is set by default but I've experienced that many times in the past.

Thanks

Joerg