Oninit Logo
The Down System Specialists
+1-913-732-8892
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g arc Archive status

The onstat -rc command display the current status of archives to the system. The output is sorted by DBSpace number. 


num   DBSpace            Q Size Q Len  Buffer partnum    size     scanner   
                                                                            
Dbspaces - Archive Status                                                   
name               number level date             log        log-position    
rootdbs            1      0     04/14/2001.01:01 863        0x952018        
logdbs01           2      0     04/14/2001.01:01 863        0x952018        
smrtdbs01          3      0     04/14/2001.01:01 863        0x952018        
datadbs01          4      0     04/14/2001.01:01 863        0x952018        
datadbs02          5      0     04/14/2001.01:01 863        0x952018        
datadbs03          6      0     04/14/2001.01:01 863        0x952018        
datadbs04          7      0     04/14/2001.01:01 863        0x952018

Active Archive Status

Heading Description Format See Also
num The DBSpace number Dec onstat -d
DBSpace The DBSpace currently being archived Str  
Q Size Size of list containing pages to be archived Dec  
Q Len Number of pages remaining in queue to write (gets - puts) Dec  
Buffer The number of pages in the archive before-image bin Dec  
partnum Before image bin partition number Hex  
size The number of used pages in temp partition Dec  
scanner Archive high water partition number Hex  

Dbspaces Archive Status

Heading Description Format See Also
name The name of the DBSpace archived Str onstat -d
number The number of the DBSpace Dec  
level The archive level that was performed (0,1, or 2) Dec  
date The datetime the archive was performed. Str  
log The logical log that was active at the time of the archive Dec onstat -l
log-position The position within the current active log when the archive was performed. Hex  

Notes

    By setting the environment variable ARCHIVE_TEST and running onstat -g arc, the DBSpace flags (onstat -d) and timestamp (hex value) columns will be added to the output.

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.