Oninit Logo
The Down System Specialists
+1-913-674-0360
+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 cluster High-Availability Cluster Information

The onstat -g cluster command displays high-availability cluster information. The output of the onstat -g cluster command differs slightly depending on whether the command is run on the primary server or on one of the secondary servers and combines the outputs of 

onstat -g cluster verbose  [On primary server]

Primary Server:theoden
Current Log Page:1829,4349
Index page logging status: Enabled
Index page logging was enabled at: 2013/06/04 11:54:04

Server  ACKed Log    Supports     Status
        (log, page)  Updates
london  1829,4349    No           ASYNC(HDR),Connected,On
tokyo   1829,4349    Yes          SYNC(SDS),Connected,Active
berlin  1829,4349    Yes          ASYNC(RSS),Connected,Active

server name: london
type: ASYNC (HDR)
control block: 0x68cec1c0
server status: On
connection status: Connected
Last log page sent (log id, page): 1829,4349
Last log page acked (log id, page); 1829,4525
Approximate log page backlog: 79
SDS cycle not used
Delayed Apply Not Used
Stop Apply Not Used
Time of last ack: 1969/12/31 19:00:00
Supports Updates: No

server name: tokyo
type: SYNC (SDS)
control block: 0x4c2de0b8
server status: Active
connection status: Connected
Last log page sent (log id, page): 1829,4349
Last log page acked (log id, page); 1829,4349
Approximate log page backlog: 79
SDS cycle current: 20 ACKed: 20
Delayed Apply Not Used
Stop Apply Not Used
Time of last ack: 2013/06/04 14:22:37
Supports Updates: Yes

Output description

FieldDescription
Primary server The name of the primary server
Current log page The log ID and page number of the current log page.
Index page logging status Indicates whether index page logging is enabled or disabled.
Index page logging was enabled at The date and time that index page logging was enabled.
Server name The name of the secondary server.
type Displays whether the secondary server is connected synchronously (SYNC) or asynchronously (ASYNC). Also displays the type of secondary server: HDR, SDS, or RSS.
control block The in-memory address of the thread width="20%" control block.
server status Displays the current status of the secondary server.
connection status Displays the current network connection status of the secondary server.
Last log page sent (log id, page) The log ID and page number of the most recent log page sent by the primary server to the secondary server.
Last log page acked (log id, page) The log ID and page number of the most recent log page the secondary server acknowledged.
Approximate log page backlog Indicates the approximate number of log pages that have yet to be processed by the secondary server.
SDS cycle Indicates the cycle number to which the primary server has advanced and which the shared disk secondary server has acknowledged. Used internally by Tech support to monitor coordination of the primary server with the secondary server.
Delayed Apply Indicates whether the secondary server waits for a specified amount of time before applying logs (as specified by the DELAY_APPLY configuration parameter).
Stop Apply Indicates whether the secondary server has stopped applying log files received from the primary server (as specified by the STOP_APPLY configuration parameter).
Time of last ack The date and time of the last acknowledged log.
Supports Updates Displays whether client applications can perform update, insert, and delete operations on the secondary server (as specified by the UPDATABLE_SECONDARY configuration parameter).

onstat -g cluster verbose  [On secondary server]
Primary Server:theoden
Index page logging status: Disabled


Server  ACKed Log    Supports     Status
        (log, page)  Updates
london  1829,5124    No           ASYNC(HDR),Connected,On

Output description

FieldDescription
Primary server The name of the primary server
Index page logging status Indicates whether index page logging is enabled or disabled.
Index page logging was enabled at The date and time that index page logging was enabled.
Server The name of the secondary server.
ACKed Log (log, page) The log ID and page number of the last acknowledged log.
Supports Updates Displays whether client applications can perform update, insert, and delete operations on the secondary server (as specified by the UPDATABLE_SECONDARY configuration parameter).
Status Displays the connection status of the secondary server.

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