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
>
>
>