How often and how many times does Service Desk retry to connect a database server after it detects disconnection?

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

Question:

How often does Service Desk Manager try to reconnect to a database server? How many times does Service Desk Manager retry to establish the connection?

 

Answer:

When Service Desk fails to connect to a database server, it retries to connect to the database server 5 times every 5 seconds by default. In order to change the values, please add the following variables to NX.env and NX.env_nt.tpl by running pdm_options_mgr command.


- Maximum number of retries:
NX_SQL_CONNECTION_RETRY= (desired value)

e.g. Change the maximum number of retry to 10 times

pdm_options_mgr -c -s SQL_CONNECTION_RETRY -v 10 -a pdm_option.inst

 

- How many seconds to wait for retry:
NX_SQL_CONNECTION_WAIT= (desired value)

e.g. Change the frequency to retry to 10 seconds
pdm_options_mgr -c -s SQL_CONNECTION_WAIT -v 10 -a pdm_option.inst -t

 

Additional Information:

TEC1147347: After running pdm_options_mgr command to add a variable to NX.env or NX.env_tpl files,  an existing last line of those files is replaced with a new variable added by the command.

TEC612988: Using the 'pdm_options_mgr' command to change content within the CA Service Desk Manager (CA SDM) NX.ENV file