Re: any way to know the progress of a level1 (or level0) ontape save?
You may not do archives regularly, but you were right about being able to
use onstat -g arc for tracking in progress archives. Although the datetimes
for each dbspace are not updated during the archive, the top part of this
report is totally dedicated to the in progress archive including all
dbspaces that have yet to be backed up and some reference info about
BEFIMAGE's being held in tempspace. I definately missed this yesterday, a
bit tunnel visioned on the datetime section I suppose.
num DBSpace Q Size Q Len Buffer partnum size scanner
32 idx_sale_item 0 0 80:209632
35 dbs_mnth_sales 0 0
36 idx_mnth_sales 0 0
37 dbs_shipments 0 0
38 idx_shipments 0 0
39 dbs_sale_tender 340 0 15 0xa00020 29248
40 idx_sale_tender 144 0 13 0xa00021 11936
41 idx_sale_discount 0 0
42 dbs_sale_discount 0 0
43 dbs_sales_tax 0 0
44 idx_sales_tax 0 0
45 dbs_toolbox 0 0
46 idx_toolbox 0 0
"Art S. Kagel" <kagel@bloomberg.net> wrote in message
news:pan.2004.09.23.16.59.46.253623.1355@bloomberg.net...
> On Thu, 23 Sep 2004 15:39:23 -0400, Dave Griffen wrote:
>
> Gores to show how frequently I run archives myself anymore. Onstat -g arc
> will not show the progress live during an archive. It is apparently
updated
> at the completion of the archive.
>
> Art S. Kagel
>
> > I haven't noticed this -g previously, so I'm trying to figure it out.
All
> > my dbspaces show the same datetime for Level-0 and Level-1 respectively.
> > These times look to match up to initiation time of the last successful
> > level-0 and level-1. I'm running a level-0 on a test system, it's done
> > enough reads to get through half a dozen dbspaces, and the none of the
times
> > have been updated. It looks like the times won't get updated until the
> > archive is complete. Am I missing something with this command?
> >
> >
> > "Art S. Kagel" <kagel@bloomberg.net> wrote in message
> > news:pan.2004.09.20.18.07.56.222183.1355@bloomberg.net...
> >> On Wed, 15 Sep 2004 18:50:22 -0400, sumGirl wrote:
> >>
> >> > Just wondering if anyone knows of a way to check the progress of an
> > ontape> >> > backup?
> >>
> >> onstat -g arc will show the last archive time for each dbspace. You> > should
> >> be able to follow the progress through the dbspaces that way also.
> >>
> >> Art S. Kagel