Hello Everyone,
I have a quick question in reference to using select statements to query the activity
log. For some reason the regular select statement would take forever to run a simple
query? How does TSM query the activity log? I'm still quite a novice at selects
statements so maybe I'm issuing the wrong syntax.
Reason why I would like to use the select statement vs. q act is because TSM Reporting
tool allows me to generate alerts by setting up notification rules which queries the
server using select statements.
Examples below:
TSM QUERY: (Takes about a blink of an eye)
TSM_SERVER_01>q act msg=0986 begintime=14:30:00 endtime=15:00:00
Date/Time Message
-------------------- ----------------------------------------------------------
07/09/04 14:35:21 ANR0986I Process 7544 for SPACE RECLAMATION running in the
BACKGROUND processed 36047 items for a total of
4,279,628,603 bytes with a completion state of SUCCESS at
14:35:21.
07/09/04 14:42:05 ANR0986I Process 7545 for SPACE RECLAMATION running in the
BACKGROUND processed 33537 items for a total of
8,644,875,214 bytes with a completion state of SUCCESS at
14:42:05.
SQL QUERY: (Takes about 20 mins!!!!!)
TSM_SERVER_01>select date_time,message from actlog where date_time between '07/09/04
14:30:00' and ' 07/09/04 15:00:00' and msgno=0986
ANR2963W This SQL query may produce a very large result table, or may require a
significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N)) y
DATE_TIME MESSAGE
------------------ ------------------
2004-07-09 ANR0986I Process
14:35:21.000000 7544 for SPACE
RECLAMATION
running in the
BACKGROUND
processed 36047
items for a total
of 4,279,628,603
bytes with a
completion state
of SUCCESS at
14:35:21.
2004-07-09 ANR0986I Process
14:42:05.000000 7545 for SPACE
RECLAMATION
running in the
BACKGROUND
processed 33537
items for a total
of 8,644,875,214
bytes with a
completion state
of SUCCESS at
14:42:05.
My DB Maximum Reduction space is well over 3 gigs so I know that's not an issue.
Any suggestions and comments would be deeply appreciated!
Thanks in advance!
Calvin
---------------------------------------
The information contained in this e-mail message, and any attachment thereto, is
confidential and may not be disclosed without our express permission. If you are not
the intended recipient or an employee or agent responsible for delivering this message
to the intended recipient, you are hereby notified that you have received this message
in error and that any review, dissemination, distribution or copying of this message,
or any attachment thereto, in whole or in part, is strictly prohibited. If you have
received this message in error, please immediately notify us by telephone, fax or
e-mail and delete the message and all of its attachments. Thank you.
Every effort is made to keep our network free from viruses. You should, however,
review this e-mail message, as well as any attachment thereto, for viruses. We take
no responsibility and have no liability for any computer virus which may be
transferred via this e-mail message.
