What commands can be used to check the Advanced Availability server type?

Document ID : KB000011717
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

In an Advanced Availability (AA) configuration, there are 3 types of Advanced Availability servers.  These are Background, Standby, and Application.

Question:

How can I check the AA type of each server?

Environment:
CA Service Desk Manager 12.9 or 14.1, with Advanced Availability configuration (i.e. not Conventional primary/secondary configuration)
Answer:

The usual command which you can run on each AA server to check the AA type of the server is:

pdm_server_control -t

 

You could also use sql_check_db or orcl_check_db. 

sql_check_db can be used when the Database Management System in the environment is configured to be SQL Server; orcl_check_db can be used when the DBMS is Oracle.

 

Additional Information:

pdm_server_control

Run:

pdm_server_control -t

Results are one of the following:

BACKGROUND
STANDBY
APPLICATION

Note that if you are using a Conventional configuration instead of an AA configuration, you will receive:

ERROR:
This program is not used for this configuration.

 

sql_check_db and orcl_check_db

In the examples that follow, you must replace <local_hostname> with the host name of the server on which you are running the command. 

Note that the executable for the command exists in the "bin" directory of the CA Service Desk Manager installation directory.

For SQL Server DBMS, run:

sql_check_db  -B -s <local_hostname>

For Oracle DBMS, run:

orcl_check_db  -B -s <local_hostname>

Results are one of the following, when the hostname of the server is SDMW8B4:

SDMW8B4 is a background or standby server.
SDMW8B4 is a background or a standby.

 

For SQL Server DBMS, run:

sql_check_db  -S -s <local_hostname>

For Oracle DBMS, run:

orcl_check_db  -S -s <local_hostname>

Results are one of the following, when the hostname of the server is SDMW8B4:

WARNING - SDMW8B4 not found as standby server.
ERROR - SDMW8B4 is not a standby.
SDMW8B4 is a standby server.
SDMW8B4 is a standby.

 

servers.dat

As an additional check, you could verify the content of the "servers.dat" file on the Background server, which exists in the "pdmconf" subdirectory of the CA Service Desk Manager installation directory.  The results should be similar to:

14542 SDMW8B3 3 1001 1 0
14543 SDMW8B4 2 400001 1 0
14544 SDMW8B5 4 400002 1 0
14545 SDMW8B6 4 400003 1 0

The third column in the results is the AA type.  A value of "2" indicates "Background", "3" indicates "Standby", and "4" indicates "Application".