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 dri Data Replication Information

The onstat -g dri command the current status and settings for data replication services. 

Data Replication at 0x68cec1c0:
  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  primary        on           london                     1829 / 5406       NA

  DRINTERVAL   30
  DRTIMEOUT    30
  DRAUTO       0
  DRLOSTFOUND  /usr/informix/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
  Backlog      80
  Last Send    2013/06/04 14:33:13
  Last Receive 2013/06/04 14:33:13
  Last Ping    2013/06/04 14:33:08

Output description

FieldDescription
Type Current type of server: primary, secondary, or standard
State on or off
Paired server Name of the primary or secondary server that this server is paired with
Last DR CKPT Last checkpoint ID and page
Supports Proxy Writes Displays whether the server is configured to allow secondary server updates. Y = supports secondary server updates, N = does not support secondary server updates.
DRINTERVAL The value of the configuration parameter in the onconfig file.
DRTIMEOUT The value of the configuration parameter in the onconfig file.
DRAUTO The value of the configuration parameter in the onconfig file.
DRLOSTFOUND The value of the configuration parameter in the onconfig file.
DRIDXAUTO The value of the configuration parameter in the onconfig file.
ENCRYPT_HDR The value of the configuration parameter in the onconfig file.
Backlog Number of log pages in the HDR data replication buffer that are not yet sent to the HDR secondary server
Last Send The time that the last message was sent to the peer node
Last Receive The time that the last message was received from the peer node
Last Ping The time of the last ping
onstat -g dri ckpt

Data Replication at 0x548291c0:
  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  HDR Secondary  on           theoden                    1829 / 5406       N

  DRINTERVAL   30
  DRTIMEOUT    30
  DRAUTO       0
  DRLOSTFOUND  /usr/informix/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
  Backlog      0

DR Checkpoint processing:
        Save State                      N
        Pages Saved                     0
        Save Area                       none
        Received log id, page           1829,5465
        Saved log id, page              0,0
        Drain log id, page              0,0
        Processed log id, page          1829,5465
        Pending checkpoints             0

Output description

FieldDescription
Save State B (buffering) when the server is adding logs to the staging area D (draining) when the server is removing logs from the staging area N (normal) when the server is operating normally, meaning that no logs are saved
Pages Saved Displays the number of log pages saved in the staging area that have yet to be applied.
Save Area Displays the location of the staged log files.
Received log id, page Displays the last log ID and page that were received from the primary server.
Processed log id, page Displays the last log ID and page that are queued to the recovery pipeline.
Saved log id, page Displays the last log ID and page that was stored in the staging area (if stage state is either B or D).
Drain log id, page Displays the last log ID and page that were removed from the staging area.
Pending checkpoints Displays the number of checkpoints that are staged but not yet applied.
Pending ckpt log id, page Displays the position of any pending checkpoint records.
onstat -g dri que

Pending Msg to Send 1
	ACK QUEUE  2398:1256fff
	thread 0x893de6c8 (85) 2398:1829018
	thread 0x893a16b8 (83) 2398:1829048
	thread 0x89229968 (72) 2398:1829078
	thread 0x89381508 (82) 2398:18290a8
	thread 0x87e81658 (69) 2398:18290d8
	thread 0x89215968 (71) 2398:1830018
	thread 0x89336bc8 (80) 2398:1830048
	thread 0x89370018 (81) 2398:18300f8
	thread 0x892eb018 (77) 2398:183a018
	thread 0x89308018 (78) 2398:183b018
	thread 0x89290138 (75) 2398:183b048
	thread 0x893c1658 (84) 2398:183c018
	thread 0x891fe8e8 (70) 2398:183c048
	thread 0x89325018 (79) 2398:183d018
	thread 0x893ff738 (86) 2398:183d048
	thread 0x894207a8 (87) 2398:183d078
	
	Applied QUEUE  2398:1828018

Output description

FieldDescription
Pending message to send The number of unprocessed data replication buffers queued to the drprsend thread.
ACK QUEUE The log unique value, the page number, and the value 0xfff for the most recently paged log.
thread The pointer to the thread-control block (TCB), the thread id in parentheses, and the log sequence number (LSN) of the commit that was performed by that thread
Applied QUEUE The LSNs of commits that are waiting for acknowledgement of being received on the HDR secondary.

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