IZ15272: CONNECTION PERFORMANCE DEGREDATION WHEN RUNNING WITH CLI IN STATIC MATCH MODE.

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as Permanent restriction.

Error description

• When running in static match mode, the capture file is read and
  parsed each time a connection is made. The larger the capture
  file the more it impacts the performance of connections.
  
  Legacy JDBC Type 2 applications may suffer most as all
  connections in a mult-threaded Java environmenr are serialized
  (in Java).
  

Local fix

• Avoid large capture files or do not run with static mode CLI.
  

Problem summary

• USERS AFFECTED: all
  
  PROBLEM DESCRIPTION
  When running in static match mode, the capture file is read and
  parsed each time a connection is made. The larger the capture
  file the more it impacts the performance of connections.
  
  Legacy JDBC Type 2 applications may suffer most as all
  connections in a mult-threaded Java environment are serialized
  (in Java).
  
  PROBLEM SUMMARY:
  When running in static match mode, the capture file is read and
  parsed each time a connection is made. The larger the capture
  file the more it impacts the performance of connections.
  
  Legacy JDBC Type 2 applications may suffer most as all
  connections in a mult-threaded Java environment are serialized
  (in Java).
  
  LOCAL FIX:
  Avoid large capture files or do not run with static mode CLI.
  

Problem conclusion

• module: ENGN_CLI. Permanent restriction
  

Temporary fix

• see LOCAL FIX
  

Comments

APAR Information

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

  IY89661

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

Fix information

Applicable component levels