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 rss RS Secondary Server Information

The onstat -g rss command displays RSS server information. There are a number of command line options.



Option Description
onstat -g rss Displays brief RS secondary server information
onstat -g rss verbose Displays detailed RS secondary server information
onstat -g rss log Displays log information. This command is only applicable when run on the primary server.
onstat -g rss server_name Displays information about a specific RS secondary server. This command is only applicable when run on the primary server. 

onstat -g rss 

Local server type: Standard
Index page logging status: Enabled
Index page logging was enabled at: 2010/05/11 14:33:06
Number of RSS servers: 2

RSS Server information:

RSS Srv      RSS Srv      Connection     Next LPG to send
name         status       status           (log id,page)
theoden      Active       Connected           20714,29007
gimli        Active       Connected           20718,48667


onstat -g rss verbose [Run on primary server]

Local server type: Standard
Index page logging status: Enabled
Index page logging was enabled at: 2010/05/11 14:33:06
Number of RSS servers: 2

RSS Server information:

RSS Server control block: 0x3142c2738
RSS server name: london
RSS server status: Active
RSS connection status: Connected
Log transmission status: Blocked
Next log page to send(log id,page): 20714,29107
Last log page acked(log id,page): 20714,29002
Time of Last Acknowledgment: 2010/05/11 15:32:06
Pending Log Pages to be ACKed: 105
Approximate Log Page Backlog:97104
Sequence number of next buffer to send: 2469
Sequence number of last buffer acked: 2454
Supports Proxy Writes: Y

onstat -g rss log

Log Pages Snooped:
RSS Srv         From      From      Tossed
name            Cache     Disk     (LBC full)

london          1139     1134      0
berlin          1138     1128      0

Output Descriptions

Not all fields are in all the above examples

Option Description
Local server type Primary or RSS (remote standalone secondary) server type
Index page logging status Displays whether index page logging is enabled or disabled between primary server and secondary server
Index page logging was enabled at Date and time that index page logging was enabled
Number of RSS servers Number of RS secondary servers connected to the primary server
RSS Server control block RS secondary server control block
RSS Server name Name of RS secondary server
RSS Server status Displays whether RS secondary server is active or not
RSS Connection status Connection status of RS secondary server
Log transmission status Displays whether log transmission is active or inactive
Next log page to send (log id, page) The log ID and page number of the next log page that will be sent
Last log page acked (log id, page) The log ID and page number of the last acknowledged log
Time of Last Acknowledgment The time at which the last log was acknowledged
Pending Log pages to be ACKed The number of logs sent but not yet acknowledged
Approximate Log Page Backlog The difference between the number of logs that were sent and the end of the logical log
Sequence number of next buffer to send The sequence number of the next buffer to be sent
Sequence number of last buffer acked The sequence number of the last acknowledged buffer
Supports Proxy Writes Displays whether the server is currently configured to allow updates to secondary servers.
  • Y = supports updates to secondary servers
  • N = does not support updates to secondary servers.
Local server type Primary or RSS (remote standalone secondary) server type
Server Status Displays whether RS secondary server is active
Source server name Name of the primary server
Connection status Connection status of RS secondary server
Last log page received (log id,page) Most recent log ID and page received
Log Pages Snooped Statistics for each RS secondary server
RSS Srv name RS secondary server name
From Cache From cache number
From Disk Log from disk
Tossed (LBC full) Number of log pages discarded as a result of the LBC becoming full

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