This is one of those areas which illustrates the difference between
TSM command processing and customer-accessible SQL tables...  The
Query EVent command actually reports from both the Events and Summary
tables, so the amount of data it displays differs from what you will
see in the Events table via a Select.

See IBM site Technotes 1110883 and 1114961 for just some of the
causes of absence of past events. (The Events table is much more
volatile than you may expect.) Search the IBM site with  +tsm +"query
event" +technote  for more insights.

   Richard Sims     http://people.bu.edu/rbs

On May 19, 2005, at 6:49 AM, Elio Vannelli wrote:

Hello *SM users,

when I run

SELECT * from EVENTS

in an ODBC connection, TSM returns only records from last db
backup. Is there a way to select records from a certain date
(something like the "query event" statement from the command line)?
Why the db backup erease entries in the events table?