The onstat -g cdr command displays secondary server queues and is only valid on secondary servers and replicate sets on each of the servers within the domain. If a replicated table is undergoing an alter operation, the onstat -g cat command shows that it is in alter mode. This command can be used to determine:
In a high-availability cluster, the primary server sends log records to one or more secondary servers over the network. Each secondary server continuously replays the transaction logs from the primary server to ensure that data is replicated on the secondary server. Each tblspace on the primary server is assigned a queue on the secondary server in which to receive log records. A thread, called an apply thread, applies the logs stored in the queue to the secondary server. The logs are applied in the order in which they were received.
Log Apply Info: Thread Queue Total Avg Size Queued Depth xchg_1.0 0 9 8.00 xchg_1.1 0 0 0.00 xchg_1.2 0 6 2.54 xchg_1.3 0 3 1.01 xchg_1.4 0 5 1.23 xchg_1.5 0 9 1.72 xchg_1.6 0 1 1.69 xchg_1.7 0 59 3.25 xchg_1.8 0 26 9.59 xchg_1.9 0 18 3.69 Secondary Apply Queue: Total Buffers:12 Size:64K Free Buffers:11 Log Recovery Queue: Total Buffers:4 Size:32K Free Buffers:2 Log Page Queue: Total Buffers:32 Size:2K Free Buffers:32 Log Record Queue: Total Buffers:50 Size:64K Free Buffers:49
|Thread||The name of the apply thread assigned to receive the log record.|
|Queue Size||The number of log records queued for the apply thread.|
|Total Queued||The total number of queued log records for a given apply thread.|
|Avg Depth||The average number of logs in the queue at the time that the last queue insert operation occurred.|
|Secondary Apply Queue||The secondary apply queue receives log buffers from the primary server. The values displayed represent the total number of buffers allocated to receiving log buffer records, the size of the queue, and the number of unused buffers.|
|Log Recovery Queue||The log recovery queue receives output from the secondary apply queue. The log buffers are converted to a format compatible with the ontape utility. The values displayed represent the total number of stream buffers in the recovery queue, the size of the stream buffers, and the number of unused buffers.|
|Log Page Queue||The log page queue receives output from the log recovery queue. The ontape formatting is removed and the data is divided into individual log pages. The values displayed represent the total number of log pages in the queue, the size of the queue, and the number of unused buffers.|
|Log Record Queue||The log record queue receives output from the log page queue. The log pages are divided into individual log records. The values displayed represent the total number of log records in the recovery queue, the size of the queue, and the number of unused buffers.|
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.