What is this query used for?

I cannot get it to work.

tsm: ADSM_SERVERG>select message from actlog where
cast((current_timestamp-date_time)days as decimal) <=1 and msgno161
ANR2909E The SQL statement is incomplete; additional tokens are required.
ANS8001I Return code 3.

Jeff Bach


        -----Original Message-----
        From:   Bruce Mitchell [SMTP:bruce.mitchell AT DB DOT COM]
        Sent:   Tuesday, October 16, 2001 7:46 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        ACTLOG reporting. (What happend to my message type)

        I've discovered a funny, that I  could do with some help with ..
        We run reporting overnight against  more than 13 TSM servers using
selects against various TMS tables to build stats.

        One of these is :-

        select message from actlog where
cast((current_timestamp-date_time)days as decimal) <=1.and msgno=4961

        which is used to determine BACKUP totals..

        This works fine on all but one server. The server in question shows
no message in ACTLOG table (or actlog)...
        I've checked eventrules and the message isnt disabled..
        Alll servers have  identical options and eventrules
enabled/disbaled..

        Does anyone know of a 'discretionary limit' on a temp table size
with TSM's SQL, as this server has 900+ clients and 120Gb database.
        I know it's way too  many , but they keep a comin...

        Any ideas are welcome...

        Tel:       +44(0) 207 547 4917
        Fax        +44(0) 207 650 7917
        Mobile    +44(0) 7768 361-885
        email:    bruce.mitchell AT db DOT com



        --

        This e-mail may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this e-mail in
error) please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.


**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed.  If you have received this email
in error destroy it immediately.
**********************************************************************