IT34228: JDBC DATABASE CALL TIMEOUT CANNOT BE SET MORE THAN 10 MINUTES.

APAR status

• Closed as program error.

Error description

• The default JDBC database call timeout of a message flow is 15
  seconds. This can be increased to a maximum of only 600 seconds
  with environment variable MQSI_POOL_DBCALL_TIMEOUT. Some JDBC
  batch processing might need a larger timeout value and this APAR
  allows to set a value larger than 600 seconds. Also the default
  JDBC database call timeout value is changed to 60 seconds from
  15 seconds.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM App Connect Enterprise V11.0 and IBM
  Integration Bus V10.0 using pooled JDBC connections
  
  
  Platforms affected:
  z/OS, MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  The default timeout for a JDBC database call using a pooled
  connection is 15 seconds. This can be increased to a maximum of
  only 600 seconds with the environment variable
  MQSI_POOL_DBCALL_TIMEOUT. Some JDBC batch processing might need
  a larger timeout value and this APAR allows the user to set a
  value of up to 18000 seconds. Also the default timeout for a
  JDBC database call is changed to 60 seconds from 15 seconds.
  

Problem conclusion

• The product now allows the user to set a larger timeout value
  for JDBC operations performed by pooled connections, up to 18000
  seconds, with the environment variable MQSI_POOL_DBCALL_TIMEOUT.
  Also, the default timeout value is now 60 seconds, changed from
  15 seconds.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.23
  v11.0      11.0.0.11
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INTEGRATION BUS

• Fixed component ID

  5724J0540

Applicable component levels