Can anybody please tell me how to find number of concurrent users firing query in teradata at a particular time in PAST.. lets say yesterday.
Can we do this in Pmon ( although we can see all the active users in Pmon, I want to see no. of maximum concurrent users at a specific point of time in past).
Please do reply..Its very urgent!!
I have searched on net.. we can find out the Users Count in Teradata Manager.. via Analyze>Trends>User Count.
But I am getting "No Rows found". I have changed the filter values also..but same result. :(
Actually for all the options in Trend tab,I am getting the same result: No Rows Found
Else all the options in Analyze tab e.g. Resource Histort etc are showing proper result .
Please let me know if any one has information regarding this issue.
Thanks a lot in advance :)
You would need to enable the data collection process before you can analyse historic data. Seems that this is not active in your environment.
Do you log all queries in DBQL on detail level?
If yes you could have a chance to get the info you search there.
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
thanks a lot ulrich for the information..
yes we do collect data in DBQL tables
Can u please tell me which table shud I look for...
I am searching in DBC.LogOnOff table... I want to find the number of concurrent users daily... i.e. number of users firing query simultaniously daily (atleast their logon time is same)
The definition of DBC.LogOnOff is as below:
REPLACE VIEW DBC.LogOnOff
SELECT Datefld(NAMED LogDate),
CAST(TRANSLATE(UserName USING UNICODE_TO_LOCALE WITH ERROR)
AS CHAR(30)) (NAMED UserName),
CAST(TRANSLATE(AccountName USING UNICODE_TO_LOCALE WITH ERROR)
AS CHAR(30)) (NAMED AccountName),
TRANSLATE(LogonSource USING UNICODE_TO_LOCALE WITH ERROR)
FROM DBC.EventLog WITH CHECK OPTION;
Please tell me how to do it..
You can use below sql to get concurrent user.
SEL count(*) FROM DBC.LOGONOFF
WHERE LogonDate = '2012/06/25'
AND Event = 'Logoff'
AND 120000 BETWEEN LogonTime AND LogTime
dbc.LogonOff is only information about when a session logged on/off, only dbc.QryLog carries info about executed queries.
So it depends on the definition of "concurrent":
- number of users logged on -> LogonOff
- number of sessions logged on -> LogonOff
- number of queries running in parallel -> QryLog, but this will not count those fast tactical queries which are usually not logged in QryLog, but in QryLogSummary