JR27407: If database quiesces and unquiesces, all connections in the conn ection pool will be stale and a -1228 sql error will be returned

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• If database is started and stopped, such as when a restoredb is
  done, all connections in the connection pool will be stale and
  a -1228 or SQL30081N sqlerror will be returned. The defect fix
  will make it so that only the first connnection in the pool,
  upon returning this error, will be bad All remaiing connection
  objects will be guaranteed to be good.
  If this APAR is not applied, when this situation described
  above occurs, the application will need to create new
  connection objects in order to re-connect to the database.
  SQL30081N error when executing the user application of restore
  db, delete, and insert sequentially in a short time.
  

Local fix

• Turn connection pooling off using "pooling=false" in the
  connection string. Performance will be slightly slower, but it
  will work correctly.
  

Problem summary

• If database quiesces and unquiesces, all connections in the
  connection pool will be stale and a -1228 sql error will be
  returned.
  

Problem conclusion

• First fixed in DB2 UDB Version 9 FixPak 5
  

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:

  JR28802

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSY

     UP

• R810 PSN

     UP

• R820 PSN

     UP

• R950 PSN

     UP