Archives of the TeradataForum

Message Posted: Thu, 14 Sep 2001 @ 16:10:54 GMT

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

I agree with John Hall regarding his approach in using ASE to more accurately identify all users who performed work during a period of time. I'd like to add two comments to his.

1) When populating the Account String with ASE variables, keep in mind that this column is also used to specify the Performance Group name for a user ID. Using the ASE variables of &L&D&T consumes 27 of the 30 bytes available in this column. Since non-default Performance Groups require a '$; character before and after the Performance Group Name, it only leaves 1 cahracter for the Performance Group Name. Something to keep in mind.

2) I'd like to hear back from JOhn on his experince with users who logon and logoff and don't submit a query. We have used the &I ASE variable, which records CPU and IO by request, and we always record AMP activity with a logon. It is typically only record on a couple of AMPs. I believe the AMP activity is related to Primary Index look ups into the dictionary tables to very passwords, accessrights, etc. Even &L&D&T, I would still expect Teradata to collect AMP activity for any session that logs on, but since we don't use that ASE combination, maybe it works differently. John, can you comment? Thanks.

Regards,

Thomas F. Stanek
TFS Consulting

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