Re: any way to know the progress of a level1 (or level0) ontape save?

If an archive is running the following select statement from sysmaster will tell you which dbspaces still have pending archives. select dbsnum, name from sysdbspaces where bitval(flags, '0x4000') <> 0 order by 1 You can also get this information from onstat -d where the flags column contains 0x4000 bit set. Hope this helps, John Dave Griffen wrote: > 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 > > >