IJ49597: THE PROPERTY IMPACT.JDBC.POOL.CREATETIME IS NOT IN DOCS

APAR status

• Closed as documentation error.

Error description

• The property impact.jdbc.pool.createtime whc goes in the
  <Server>_server.props file is mentioned in some policy logs
  messages.
  E.g.:
  ... Caused by:
  com.micromuse.common.datasource.SQLDataSourceException:
  Connection pool has not be created! May need to increase the
  time to wait for connection pool creation. Property in
  <ServerName>_server.props impact.jdbc.pool.createtime=3000.
  Default is 3 seconds (3000).
  But it is not described in the Impact docs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Impact Users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The parameter impact.jdbc.pool.createtime was missing on how *
  * to configuring the connection pool.                          *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * You can control how long Impact waits for a connection pool  *
  * creation by adding the impact.jdbc.pool.createtime property  *
  * to the $IMPACT_HOME/etc/<servername>_server.prop file.       *
  *                                                              *
  * Procedure :                                                  *
  * 1 Open the backend                                           *
  * $IMPACT_HOME/etc/<servername>_server.props properties file.  *
  *                                                              *
  * 2. Add the property                                          *
  * impact.jdbc.pool.createtime=n                                *
  *                                                              *
  * Where n is the maximum number of milliseconds that Impact    *
  * waits to create a connection pool.                           *
  * So, if this property is set to 4000 millisecond, Impact will *
  * wait for maximum of 4 seconds for creation of connection     *
  * pool.                                                        *
  * If it is the case that connection pool has not be created    *
  * then it  needs to increase the time to wait for connection   *
  * pool creation.                                               *
  * So then impact.jdbc.pool.createtime should also be increased *
  * .                                                            *
  *                                                              *
  * 3. Restart the server to apply the changes                   *
  *                                                              *
  * Note:                                                        *
  * The default value for the impact.jdbc.pool.createtime        *
  * property is 3000 milliseconds.                               *
  * If connection pool is not created in default time then the   *
  * message:                                                     *
  * "Connection pool has not be created! May need to increase    *
  * the time to wait for connection pool" will be seen in the    *
  * log.                                                         *
  *                                                              *
  * Note:                                                        *
  * Properties in the $IMPACT_HOME/etc/<servername>_server.props *
  * file are not replicated so the same changes need to be       *
  * applies on all cluster members.                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
  |Fix Pack | 7.1.0-TIV-NCI-FP0033
  

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

Applicable component levels