![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Task D: Select an IMS Database
• Type in the name of an IMS database whose definition is loaded into TIBCO Object Service Broker and press Enter.
• Leave the DB Name field blank and press PF4 to access a list of all databases defined to TIBCO Object Service Broker, as shown in the example below.
Type an S beside the desired database and press PF3 to select the item and return to the IMS Table Definition screen. The above example shows that the database CUSTOMER is selected. The name of its root segment (CUSTROOT) appears in the first occurrence of the Segment Name field.
The value of DB Name can be overridden at runtime. Refer to Chapter 2, Operating the Service Gateway for IMS/DB for more information.
After you select an IMS database, complete the following fields to continue defining the IMS table definition:
Type the ID for a Gateway or group of Gateways to use when accessing the table you are defining. This ID identifies Gateways with common characteristics and must match the SERVERID startup parameter specified in the Gateway JCL (described in Supplying Gateway Startup Parameters). Valid entries are character strings of up to eight characters. The default is DEFAULT.
Specifies access to IMS data or both IMS and DB2 data in the same TIBCO Object Service Broker transaction. Valid entries are:IMS – Use the Gateway to access only IMS data.IM2 – Use the Gateway to access both IMS and DB2 data.
Required only when one or more IMS segments defined in an IMS table do not have unique keys and the definition is used in an INSERT, REPLACE, or DELETE statement. The default is N. Valid entries:
The Gateway returns one segment occurrence at a time to the Data Object Broker. The following applies:All fields belonging to the segment where the primary key is defined must be fully defined to TIBCO Object Service Broker. If the definition contains more than one segment type under the TIBCO Object Service Broker primary key, all fields belonging to each segment type must be fully defined to TIBCO Object Service Broker.The Gateway Program Specification Block (PSB) requires at least two identical Program Control Blocks (PCBs) for the specified IMS database. Refer to Chapter 2, Operating the Service Gateway for IMS/DB for more information. For a FORALL statement, the Gateway returns IMS data to the Data Object Broker in variable length buffers up to 31 KB. If the request must have more than 31 KB of data, it sends 31 KB buffers as required until the request is complete.
This field is used only if the THREADUSAGE gateway startup parameter is set to TABLE or TRANSACTION. Refer to Supplying Gateway Startup Parameters for more information.The PSBNAME parameter can be overridden at runtime. Refer to Chapter 2, Operating the Service Gateway for IMS/DB for more information.Specify the name of the PSB to be scheduled by the TIBCO Service Gateway for IMS/DB when this is the first IMS table accessed in a transaction.If a PSBname is not specified in the first IMS table accessed in a transaction, the Gateway schedules the PSB specified by the PSBNAME gateway startup parameter.If the PSBNAME gateway startup parameter is not specified, the default S6BIMSS is used. This PSB is then scheduled for the duration of the TIBCO Object Service Broker transaction.Depending on the setting of the THREADUSAGE parameter, the following occurs:
A PSB specified by a table in a subsequent TIBCO Object Service Broker IMS access request is ignored. All PSBs specified by tables in subsequent TIBCO Object Service Broker IMS access requests are checked. The PSB must be the same as the one specified in the first IMS table accessed or it must be blank for the TIBCO Object Service Broker transaction to proceed.
This field is used only if the Gateway is running in either BMP, DRA, or CICS mode with the THREADUSAGE startup gateway parameter set to TRANSACTION. Refer to Supplying Gateway Startup Parameters for more information.Specify the name of the Browse PSB if you want to use a read-only PSB (for example, a PSB with a PROCOPT=GP) when running an TIBCO Object Service Broker transaction in browse mode.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |