SQL Select Statement Question Please HELP!

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.