Re: script to total backups
2001-12-20 18:24:16
Try this
It gives the averages by node for all successful backups in the summary table
select entity, avg(bytes) "Avg Bytes", avg(end_time - start_time) "Elapsed" \
from summary \
where activity='BACKUP' \
and failed=0 \
group by entity
ENTITY Avg Bytes Elapsed
------------------ --------------------------------- ------------------------
----
ACC-DATAGATE 25524904.3870967741935 0
00:00:28.51ACC-DATAGATE 25524904.3870967741935 0
00:00:28.516129
ACC-ORA-OTTR 15156238.3750000000000 0 00:00:23.093750
ACC-VIVAS 610268.6129032258064 0 00:00:02.483870
AGE-DB1 157714240.0322580645161 0 00:03:08.193548
AGE-TS1 4583265.6666666666666 0 00:01:18.900000
APP-CSS-TEST 168430789.0000000000000 0 00:02:45.666666
APP-ORA-OTTR 594944956.0322580645161 0 00:05:24.516129
BNS-EGATE 36893041.9600000000000 0 01:01:11.520000
DATAGATE 116945846.4838709677419 0 00:01:31.193548
DBSERVER1 767947664.6129032258064 0 00:16:55.258064
DBSERVERDEV 372793559.2903225806451 0 00:31:36.709677
DCTBURNER 174101649.2000000000000 0 00:15:03.200000
ERS-CITEC-DC01 175674509.3870967741935 0 00:15:41.290322
Merry Xmas
Steve Harris
AIX and TSM Admin
Queensland Health
Brisbane Australia
>>> "<James> <healy>" <James.Healy2 AT AXACS DOT COM> 21/12/2001 4:51:37 >>>
Does anyone have a query that will tell me the average time a backup took
and the average amount of data transmitted?
**********************************************************************
This e-mail, including any attachments sent with it, is confidential
and for the sole use of the intended recipient(s). This confidentiality
is not waived or lost if you receive it and you are not the intended
recipient(s), or if it is transmitted/ received in error.
Any unauthorised use, alteration, disclosure, distribution or review
of this e-mail is prohibited. It may be subject to a statutory duty of
confidentiality if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this
e-mail in error, you are asked to immediately notify the sender by
telephone or by return e-mail. You should also delete this e-mail
message and destroy any hard copies produced.
**********************************************************************
|
|
|