Re: Query Event VS Successful Flag
2003-04-16 10:52:26
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
|
|
|