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


Article ID: 39007


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager



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?



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


Release: SDMU0M99000-14.1-Service Desk Manager-Full License