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


Chapter 3 Managing IMS Data Definitions : Task D: Select an IMS Database

Task D: Select an IMS Database
To select an IMS database as the foundation for your IMS table, you can do one of the following:
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.
Sample Listing of Available IMS Databases

 
LIST OF IMS DATABASES
COMMAND ==> SCROLL: P
NAME DESCRIPTION
---------------- ----------------------------------------------------------
_ CUSTL
_ CUSTOMER
_ CUSTPROD
_ CUSTX
_ EZSD00P
_ USER02P
_
_
_
_
_
_
_
_
< Place “S” beside the item(s) you wish to have Selected on PF3 >
PFKEYS: 1=HELP 3=SELECT 13=PRINT 12=EXIT

 
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.
Selecting an IMS Database

 
COMMAND==> TABLE DEFINITION
Table: CUST_ORDERS Type: IMS Unit: USR40
DB Name:
Server ID: DEFAULT Server Type: IMS Optimize Update:
PSBname: OSTRXDRP Browse PSBname: OSTRXDRQ
Location Parm Typ Syn Len Dec Default Src Sourcename
---------------- --- --- --- -- ---------------- - ----------------
_ LOCATION I C 16 0
Level Segment Name Fields Chosen Order From Segment
-- -------- ---------------- --- --------
_ 0 CUSTROOT
Event Rule Type Access Parms Chosen Order From Segment
---------------- - - ---------------- --- --------
_
_
_
PFKEYS: 3=SAVE 12=CANCEL 22=DELETE 13=PRINT 6=CHILD SEGMENTS 2=DOC 4=DB NAMES

 
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:
 
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.
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.
 
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
Copyright © TIBCO Software Inc. All Rights Reserved