BEGINT=-08:00 starts searching the activity log as of 8 hours from the
present time (as opposed to the default, which is 1 hour from the present
time). Leave out the '-' if you really mean 08:00 (8:00 AM).
The raw TSM server database tables are not row-column format, but more
like a B-tree, and we
November 2004 15:55
To: [EMAIL PROTECTED]
Subject: select from actlog VS query actlog performance
Hello TSM'ers
I'm doing some scripting that is using actlog queries fairly heavily, I
have noticed that
Select * from actlog where cast(date_time as date)=current_date and
process=123
Hello TSM'ers
I'm doing some scripting that is using actlog queries fairly heavily, I
have noticed that
Select * from actlog where cast(date_time as date)=current_date and
process=1234
Is a lot slower than
Q actlog begint=-08:00 se=1234 (say, its 8am in the morning...)
Although you need to
