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.


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.