Connection timeout in DB connector (DB2)

[Kalyani]

Hi, 

We are trying to put the connection timeout settings for our DB (DB2) connector.

Please help us know if the same configuration as in Connection timeout in DB connector (oracle) - Saviynt Forums - 51790 helps for DB2.

Also, could you share what is the default value Saviynt considers for connectiontimeout and sockettimeout.

Thank you,

Regards,

Kalyani.K

[rushikeshvartak]

• Connection Timeout: This parameter defines how long the connector should wait while establishing a connection before it times out.
• Socket Timeout: This parameter defines the maximum period of inactivity between data packets.

To configure these settings for a DB2 connector, you can add the following properties in the connection JSON or as part of the connection URL:

{ "CONNECTIONTIMEOUT": "10000", "SOCKETTIMEOUT": "30000" }

In Saviynt, the default values for connectiontimeout and sockettimeout for database connectors (such as DB2 or Oracle) are generally infinite. This means that unless you explicitly configure these timeouts, the system will wait indefinitely:

1. Connection Timeout (connectiontimeout):

   • Default: Infinite (The connector will keep trying to establish a connection without timing out unless a value is set).

2. Socket Timeout (sockettimeout):

   • Default: Infinite (The connector will wait indefinitely for data packets unless a value is set).

These default settings mean that if the database server is unreachable or slow to respond, the connection attempt may hang indefinitely. Configuring these timeouts is a good practice to avoid such issues and ensure your application can handle connectivity problems more gracefully.