onstat -g dri command: Print high-availability data replication information

Use the onstat -g dri command, either alone or with the ckpt or que options, to print information about high-availability data replication statistics on the current server.

Use the onstat -g dri command to print information about HDR server states and HDR-related configuration parameters.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onstat-- -g--dri--+------+----------------------------------><
                     +-ckpt-+   
                     '-que--'   

Example output and output description for onstat -g dri

Figure 1. onstat -g dri command output
Data Replication at 0x4d676028:
  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  primary        on           my_server                      4 / 5          NA

  DRINTERVAL   5
  DRTIMEOUT    30
  DRAUTO       3
  DRLOSTFOUND  /etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0  Backlog      0
  Last Send    2013/12/11 16:39:48
  Last Receive 2013/12/11 16:39:48
  Last Ping    2013/12/11 16:39:44
  Last log page applied(log id,page): 4,6
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
Last log page applied(log id,page)
The log ID and page number of the last applied log

Example output and output description for onstat -g dri ckpt

Use the onstat -g dri ckpt command to print information about nonblocking checkpoints in HDR servers.

Figure 2. onstat -g dri ckpt command output
Data Replication:
  Type           State        Paired server        Last DR CKPT (id/pg)   Supports Proxy Writes
  primary        on           BB_1                        554 / 558       Y

  DRINTERVAL   30
  DRTIMEOUT    30
  DRAUTO       0
  DRLOSTFOUND  /vobs/tristarm/sqldist/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
DR Checkpoint processing:
  Save State              N
  Pages Saved             0
  Save Area               none
  Received log id, page   17,68
  Saved log id, page      0,0
  Drain log id, page      0,0
  Processed log id, page  17,68
  Pending checkpoints     0
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.

Example output and output description for onstat -g dri que

Use the onstat -g dri que command to print information that is related to nearly synchronous HDR replication.

Figure 3. onstat -g dri que command output
	Pending Msg to Send 1
	ACK QUEUE  5199:1256fff
	thread 0x893de6c8 (85) 5199:1258018
	thread 0x893a16b8 (83) 5199:1258048
	thread 0x89229968 (72) 5199:1258078
	thread 0x89381508 (82) 5199:12580a8
	thread 0x87e81658 (69) 5199:12580d8
	thread 0x89215968 (71) 5199:1259018
	thread 0x89336bc8 (80) 5199:1259048
	thread 0x89370018 (81) 5199:12590f8
	thread 0x892eb018 (77) 5199:125a018
	thread 0x89308018 (78) 5199:125b018
	thread 0x89290138 (75) 5199:125b048
	thread 0x893c1658 (84) 5199:125c018
	thread 0x891fe8e8 (70) 5199:125c048
	thread 0x89325018 (79) 5199:125d018
	thread 0x893ff738 (86) 5199:125d048
	thread 0x894207a8 (87) 5199:125d078
	
	Applied QUEUE  5199:1251018
	-----------------------------------------
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.

Copyright© 2019 HCL Technologies Limited