Archives of the TeradataForum

Message Posted: Wed, 13 Oct 2010 @ 12:47:03 GMT

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

Hi,

Answer is different depending on whether or not you've got TASM enabled (I think Category 3 rules only).

If NO:

The AccountName / Accountstring used at logon time (or the default one for the user) will contain the PG as the first part. Something like $M, $H or a site-defined one such as $HIGHUSER$. If there is nothing like this at the front of the Accountname then the user is using the defauly PG which is $M.

If YES:

When the query is submitted, then TASM looks at the explain plan estimates and assigns the query to a WD (workload definition). That in turn is associated with a PG.

Does that help ?

Cheers,

Dave

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