Customize Teiid Timeout Value

Managing CA Chorus Components › Customize Teiid Timeout Value

Customize Teiid Timeout Value

The Teiid timeout value to execute a query is 300 seconds by default. If a Teiid query execution exceeds the default value, Teiid stops the execution, and Teiid returns an error message. Use this procedure to set the Teiid timeout value in CA Chorus. The system administrator must perform this procedure to set the custom environment variable.

Note: To configure this setting such that Teiid never times out, use a negative value, such as -1.

Follow these steps:

Edit the ENVETJ member in chorus_runtime_hlq.CETJOPTN to set the session timeout in seconds:

# For Teiid timeout configuration                
 IJO="$IJO -Dcom.ca.chorus.queryTimeout=350"

Stop the CA Chorus Application Server:
```
P CHORJBOS
```
A message indicating that the CA Chorus Application Server started task has ended is logged.
Start the CA Chorus Application Server:
```
S CHORJBOS
```
A message indicating that startup is complete is logged, and the new Teiid timeout value is in effect.