The QUERY EVENT status is what you want to pay attention to.

Currently the SUCCESSFUL field in the SUMMARY table isn't useful for
determining the success of a client operation. This field corresponds to
the "Normal server termination indicator" in the TSM server accounting
records, which basically says that the session between client and server
ended normally.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Gene Walters <gwalters AT GWMAIL.STATE.WV DOT US>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/16/2003 07:50
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Query Event VS Successful Flag



Well, that is the only even I can see for that server.  I ran another
query for the last few days on that server and here are the results:

Policy Domain Name: STANDARD
     Schedule Name: SQLBACKUP
         Node Name: WVWFISQLBACKUP
   Scheduled Start: 04/14/2003 01:00:00
      Actual Start: 04/14/2003 01:09:48
         Completed: 04/14/2003 01:29:51
            Status: Failed
            Result: 402

Policy Domain Name: STANDARD
     Schedule Name: SQLBACKUP
         Node Name: WVWFISQLBACKUP
   Scheduled Start: 04/15/2003 01:00:00
      Actual Start: 04/15/2003 01:14:04
         Completed: 04/15/2003 01:31:03
            Status: Failed
            Result: 402

Policy Domain Name: STANDARD
     Schedule Name: SQLBACKUP
         Node Name: WVWFISQLBACKUP
   Scheduled Start: 04/16/2003 01:00:00
      Actual Start: 04/16/2003 01:01:06
         Completed: 04/16/2003 01:10:25
            Status: Failed
            Result: 402

and here is the only record that shows in the summary table on 4/16 for
that server:

START_TIME: 2003-04-16 01:03:56.000000
     END_TIME: 2003-04-16 01:10:25.000000
     ACTIVITY: BACKUP
       NUMBER: 8715
       ENTITY: WVWFISQLBACKUP
     COMMMETH: BPX-Tcp/
      ADDRESS: 129.71.217.20:4703
SCHEDULE_NAME:
     EXAMINED: 8
     AFFECTED: 8
       FAILED: 0
        BYTES: 460421272
         IDLE: 8
       MEDIAW: 0
    PROCESSES: 1
   SUCCESSFUL: YES
  VOLUME_NAME:
   DRIVE_NAME:
 LIBRARY_NAME:
     LAST_USE:


>>> storman AT US.IBM DOT COM 04/16/03 10:20AM >>>
The starting time from QUERY EVENT shows 01:01:06, while the starting
time
from your SELECT shows 01:03:56. Are you sure these two outputs are
for
the exact same event?

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Gene Walters <gwalters AT GWMAIL.STATE.WV DOT US>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/16/2003 06:39
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Query Event VS Successful Flag



I Run a variety of queries each night, one being the query event,
another being a select statement on the summary table.  Here is a
sample
of what I get:

The query event:

Scheduled Start     Actual Start        Schedule NameNode Name
Status
---------------------------------------------------------------------------
04/16/2003 01:00:00 04/16/2003 01:01:06 SQLBACKUP
WVWFISQLBACK-Failed

The select:
ACTIVITY          Server                     MB      Duration(Min)
K/Sec        SUCCESSFUL  Start Time    End Time
BACKUP            WVWFISQLBACKUP  439.09              6       1155.86
            YES           01:03:56    01:10:25

My question is:  which one of these do I believe, the query event or
the info from the summary table.  One says it failed, one says it was
successful?

Thanks
Gene