JMast
Reputable Poster
Hello All,
We are experiencing a lot of locking on our 9.2 system. In looking for answers, I found a post on the List discussing locking. One reply referenced time out settings. It isn't clear if they are referring to the settings on the HTML server or the enterprise server.
I don't seem to be able to find Oracle documentation on the JDE.INI settings for the database section like there is for kernels or BI Publisher. Server Manager refers to it as the Bootstrap Datasource section. There are two timeout settings:
SQL Server Query Timeout - 1
SQL Server Query Timeout Retries - 17
Do I change these settings? Currently, on the HTML servers, we have it set for queries to timeout after 30 seconds and retry 3 times. What would be your recommendation for these settings to work well together?
Thank you for any advice you have,
Jeremy
We are experiencing a lot of locking on our 9.2 system. In looking for answers, I found a post on the List discussing locking. One reply referenced time out settings. It isn't clear if they are referring to the settings on the HTML server or the enterprise server.
I don't seem to be able to find Oracle documentation on the JDE.INI settings for the database section like there is for kernels or BI Publisher. Server Manager refers to it as the Bootstrap Datasource section. There are two timeout settings:
SQL Server Query Timeout - 1
SQL Server Query Timeout Retries - 17
Do I change these settings? Currently, on the HTML servers, we have it set for queries to timeout after 30 seconds and retry 3 times. What would be your recommendation for these settings to work well together?
Thank you for any advice you have,
Jeremy