1. Implementing Siebel Business Applications on DB2 for z/OS
  2. IDTHTOIN Considerations

IDTHTOIN Considerations

The IDTHTOIN DSNZPARM recommended setting is 600. (The parameter is specified in seconds.) Monitor this value in your installation to ensure that it is set properly. The IDTHTOIN parameter time- outs active threads that have been idle (no network traffic) for more than 600 seconds. (This time is the recommended value; your value might differ.)

The events that can occur when an active thread times out include:

  • The thread is not returned to the DB2 Connect thread pool for reuse.

  • When the client or component tries to reuse the DB2 Connect thread, the thread is not available. The client or component has to issue a full Connect to continue processing the work.

  • If the component or client cannot issue a full Connect, the client receives a SQL30081N SQLCODE. An example of an error message you might receive if the component or client cannot reconnect is:

    [IBM][CLI Driver][DB2] SQL30081N A communication error has been detected.  
Communication protocol being used: "TCP/IP". Communication API being used: 
"SOCKETS".  Location where the error was detected: "".  Communication function 
detecting the error: "recv".  Protocol specific error code(s): "*", "*", "0".  
SQLSTATE=08001

Another consideration to bear in mind when specifying a value for the IDTHTOIN parameter is that connection pooling on the ODBC driver must be turned off. Using connection pooling with the driver is not certified with Siebel CRM version 8 releases.