Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 1 Installing Service Gateway for DB2 : Specifying the Gateway Plan to TIBCO Object Service Broker

Specifying the Gateway Plan to TIBCO Object Service Broker
Generally you specify the DB2 Gateway plan using the PLAN gateway parameter.
Specifying Different DB2 Plans
You can specify a browse plan name and an update plan name for a group of Gateways. To do this, you use the following parameters:
BROWSEPLAN=browseplanname
UPDATEPLAN=updateplanname
If the Gateway wants to use the value of either of these gateway parameters and that value is not specified, the Gateway uses the name specified for the PLAN gateway parameter.
The Gateway uses the browse flag passed in the first message of a transaction to determine which plan to use. If the browse flag is on, the Gateway uses the browse plan, otherwise it uses the update plan. For example, if you browse a DB2 table from the table browser, the message sent is set to browse mode and the Gateway uses the browse plan. If you then select a row to invoke the single occurrence editor, another Gateway is assigned, that transaction does not have the browse flag set, and that Gateway uses the update plan.
Scope Considerations
Specifying a SCOPE of other than TRANSACTION when specifying separate browse and update plans generates an error in the Gateway start up. Only a SCOPE of TRANSACTION closes the plan at the end of a transaction. A scope of SESSION or time does not close the plan at transaction end and the next transaction inherits the previous transaction’s plan.
SECLEVEL=1 forces a SCOPE of TRANSACTION.
SECLEVEL=0 defaults to a scope of SESSION. It can be overridden by using the SCOPE=TRANSACTION parameter.
Isolation Considerations
A browse plan should specify an isolation level of Cursor Stability.
An update plan should specify an isolation level of Repeatable Read.
A plan specifying an isolation level of Cursor Stability can still perform updates.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved