The users for My Queries are configured by clicking the "Profile" link in the top right of the screen. Within the "Profile" portlet, click on the "Teradata Accounts" tab. Here you select the system and enter the username and password for any accounts you wish to display in My Queries.
Thanks Steve, i got that. Also when i drill down to a session except the overviee tab all other tabs(explain.sql,queryband etc ) are grayed out, is there any setting that i have to enable for this too?
Are you sure you have the right permissions set for seeing all those tabs? This would be in Admin -> Roles Manager -> Permissions -> MyQueries.
yes i do, though i was thinking all other tabs would appear only if the threshods are met but i am assuming SQL and EXPLAIN tab has to appear by default.
As mentioned in the other Viewpoint forum, Viewpoint only collects the SQL and Explain information for queries that run longer than 5 CPU seconds and only displayed for queries in an active, blocked, or delayed state.