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 sds SDS Server Information

The onstat -g sds command displays information about SDS servers.



Option Description
onstat -g sds Displays brief SD secondary server information
onstat -g sds verbose Displays detailed SD secondary server information
onstat -g sds server_name Displays information about a specific SD secondary server. When server_name is specified, the command must be issued from the primary server. 
onstat -g sds verbose 

Number of SDS servers:1
Updater node alias name :beijing

SDS server control block: 0x5fd51518
server name: serv2
server type: SDS
server status: Active
connection status: Connected
Last log page sent(log id,page):1829,24513
Last log page flushed(log id,page):1829,24513
Last log page acked (log id, page):1829,24513
Last LSN acked (log id,pos):1829,86765574
Approximate Log Page Backlog:0
Current SDS Cycle:2
Acked SDS Cycle:2
Sequence number of next buffer to send: 3182
Sequence number of last buffer acked: 3174
Time of lask ack:2013/06/04 14:16:11
Supports Proxy Writes: Y

Output Descriptions

Not all fields are in the above example

Option Description
Number of SDS servers Number of attached SDS (shared disk secondary) servers
Updater node alias name Name of primary server
SDS server control block SD secondary server control block
server name The name of the server
server type The type of server
server status Displays whether the server is active or inactive
connection status Status of connection between primary and secondary server
Source server name Displays name of primary server
Connection status Displays whether SD secondary server is connected
Last log page sent (log id, page) Log ID and page of most recent log page sent
Last log page received (log id, page) Log ID and page of most recent log page received
Last log page flushed (log id, page) Log ID and page of the most recent log page flushed
Last log page acked (log id, pos)) Most recent log page acknowledged
Next log page to read (log id,page) Next log page in sequence to read
Last LSN acked (log id, pos) Most recent log sequence number that was acknowledged
Approximate Log Page Backlog The number of logs waiting to be sent
Current SDS Cycle Used internally by IBM® support to monitor coordination of the primary server with the SDS server
Acked SDS Cycle Used internally by IBM support to monitor coordination of the primary server with the SDS server
Sequence number of next buffer to send Sequence number of next buffer to send
Sequence number of last buffer acked Sequence number of next buffer acknowledged
Time of last ack Date and time of last log acknowledgment
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.
Current paging file Name of current paging file
Current paging file size Size of current paging file
Old paging file Name of previous paging file
Old paging file size Size of previous paging file

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