IT15560: PROVISION OF IMBESQLMANAGER PARAMETER TO ALLOW MODIFICATION OF SHARED VARIABLE PROPAGATE WITH A LOCK

APAR status

• Closed as new function.

Error description

• When a shared variable is being updated in a FOR loop in ESQL a
  lock is being held on the shared variable. When a PROPAGATE
  statement is issued while the FOR loop is incomplete, a lock on
  the shared variable has proved to cause deadlock issues. To
  prevent such PROPAGATE of message BIP2503 error is thrown.
  
  However, users may still want to have such code construct in
  their application due to the business requirements.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of WebSphere Message Broker V8.0, IBM Integration Bus
  V9.0 and V10.0 who use shared variables.
  
  
  Platforms affected:
  z/OS, MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  When a shared variable is being updated in a FOR loop in ESQL a
  lock is held on the shared variable. If a PROPAGATE statement is
  issued while the FOR loop is incomplete, a lock on a shared
  variable can cause deadlock issues. To prevent this scenario, if
  the PROPAGATE statement is called from within a FOR loop, the
  default behaviour is for exception BIP2503 to be thrown.
  
  However, users may still want to have such a code construct in
  their application due to business requirements so a property has
  been added that enables users to change the default behaviour.
  
  There are a number of resource name changes between WebSphere
  Message Broker and IBM Integration Bus Version 9.0.  For details
  visit
  http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/topic/com.ibm.e
  tools.mft.doc/bb23814_.htm
  

Problem conclusion

• The product is updated to include ESQLManager parameter
  'allowPropagateWithSharedLockHeld' to allow the users to have a
  message propagated even when a lock is being held on the shared
  variable.
  
  The KnowledgeCenter page bn23633_ will be updated as below:
  allowPropagateWithSharedLockHeld
   	Allow to propagate the message even when a lock is held on
  shared variable.
  	-Value type - boolean
  	-Initial value - no
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.7
  v8.0       8.0.0.8
  v9.0       9.0.0.7
  
  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

  WEB MESSAGE BRO

• Fixed component ID

  5724J0520

Applicable component levels