IBM Support

IO09422: SOME API METHODS THAT CLEAR THE FREE CONNECTIONS MAY HAVE A NEGATIVE IMPACT ON APPLICATION PERFORMANCE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • Some API methods that clear the free connections may have a
    negative impact on application performance. This apar is to
    make improvements to the javadoc for CMBConnectionPool objects.
    

Local fix

Problem summary

  • Certain methods of the CMBConnectionPool are intended to be
    called only at initialization time, and will cause performance
    problems when called dynamically, because all unused connections
    in the pool are discarded each time one of these properties is
    reset. None of the documentation informs users of the
    recommended usage of these methods
    

Problem conclusion

  • For the method setMaxConnections, the following caution has been
    added to the javadoc:
    
    This property should be set only once, when the pool is
    initialized. While setting the maxConnections to a higher limit
    will have no adverse effect on performance, setting the
    maxConnections to a lower limit will cause performance problems
    in the pool because all existing free connections will be
    destroyed each time you lower the max connections limit.
    
    For the methods setMaxConnectionsPerUserid,
    setMaxConnectionBehavior, setMaxFreeConnections,
    setMaxFreeConnectionsPerUserid, setTimeOut, setCC2MimeURL,
    setConnectionType, setServiceConnectionType, setDsType,
    setPortNumber, setRMIHostname, setServicePortNumber,
    setServiceRMIHostname, setServerName, setDataManagementEnabled,
    setWorkflowDataManagementEnabled, and
    setSchemaManagementEnabled, the following caution has been added
    to the javadoc:
    
    This property should be set only once, when the pool is
    initialized. Setting this property repeatedly will cause
    performance problems in the pool, as all existing free
    connections will be destroyed each time you call this method.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IO09422

  • Reported component name

    ECLIENT

  • Reported component ID

    5724B43Z1

  • Reported release

    830

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-09-02

  • Closed date

    2008-12-22

  • Last modified date

    2008-12-22

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCTVDL","label":"Db2 Information Integrator for Content"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"830","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
22 December 2008