Querying servers

This information displays when running the Query Server option from the Hot Backup Main Menu. Note that the message format may differ depending upon whether this option is run on the master or the slave server:

Server 'hbslave'. PIB 14. PID 40774. Server type Slave. Traces OFF
Total Recvd O K. Cur trans 1. ACK'ed trans 1. Updates applied
Status: Reading network

Value	Description
`Server`	Name of the server.
`PIB`	D3 port number of the server.
`PID`	UNIX process ID of the server.
`Cur trans`	For slave servers only. Current transaction number received by the slave server. This number should increase as data is exchanged between the servers.
`ACK'ed trans`	Current transaction number successfully acknowledged by the slave server. Unless the queue is empty, the acknowledged transaction number should be slightly less than the transaction number received by the slave.
`Updates applied`	For slave servers only. Indication of whether updates received from the master server have been applied to the slave database.
`Status`	Possible status values:
	`Reading network`	Normal state of the slave server.
	`Wait response to call`	For master servers only. Master server is attempting to call its associated slave.
	`Wait incoming call`	For slave servers only. Slave server is waiting for its associated master server to establish communication.
	`Stopped`	Server has stopped. The previous message in the status or permanent log file indicates the reason for the termination.
	`Connected`	Indicates that a connection is established.
	`Writing to network`	Sending data to the associated server. If this state persists and no data transfer occurs, this indicates that the receiver is not reading data. A 30-second time-out occurs, after which the connection is shut down and restarted.
	`Waiting for ACK`	For master servers only. Waits for an acknowledgment from the associated slave server.
	`Idle`	For master servers only. Queue is empty and there is no traffic.
	`Reading queue`	For master servers only. Intermediate state while the master server is extracting messages from the transaction log queue.
Other information which may display	Total size, in kilobytes, received for the current day. The master reports a slightly higher number than the slave, due to additional protocol information. For slave servers only. Indication of whether the slave server received requests to open files and was not able to do so. The number of files that do not open displays. At any given time, there may be a few pending open files, so repeat the command to verify whether or not problems exist. Examine the permanent log file to obtain more information. For slave servers only. Indication of whether updates to the slave database are currently disabled, and the number of pending updates.

Note: Additional information on the slave server is available in the hb.log,stats file. The item datetime.pib, where datetime is the date and time when the server was last started, and pib is server on which it is running, contains statistics for number of updates, deletes, file creates, file deletes, file clears, file renames, index creates, index deletes and index clears since the last server start.