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


Chapter 2 Operating the Service Gateway for IMS/DB : Dynamically Changing Gateway Parameters

Dynamically Changing Gateway Parameters
Table Type Attributes
When a table is defined, attributes specific to external DBMS table types are held in the @SERVERPARMS TIBCO Object Service Broker control table, which is parameterized by table type. Each occurrence in the table specifies a value for the table about the external environment, such as SERVERID and DBID.
Sample @SERVERPARMS Control Table for Table Type IMS

 
BROWSING TABLE : @SERVERPARMS(IMS)
COMMAND ==>
 
NUMBER NAME TYPE SYNTAX LENGTH DECIMAL DEFAULT USAGE
_ ----------- ---------------- - - ------ ------ --------------------- -
_ 1 SERVERID S C 8 0 DEFAULT C
_ 2 SERVERTYPE S C 3 0 IMS T
_ 3 DBNAME S C 8 0 CUSTOMER D
_ 4 PSBNAME S C 8 0 P
_ 5 OPTIMIZEUPDATE S C 1 0 Y O
 
PFKEYS: 1=HELP 5=FIND NEXT 9=RECALL 18=EXCLUDE 13=PRINT 3=END 14=EXPAND

 
Using SETXPARM and RESETXPARM
At runtime, you can dynamically modify the SERVERID gateway startup parameter using the utilities SETXPARM and RESETXPARM. This reduces the number of table definitions required to define the external data. The changes are stored in either of two session tables:
 
The changes are in effect for the duration of the session, until SETXPARM is invoked again, or the overrides are reset.
Gateway Parameters That Can Be Overridden at Runtime
The following Gateway parameters and Table Definer fields can be dynamically changed with SETXPARM and RESETXPARM:
Maximum Length (Bytes)
Examples Using SETXPARM and RESETXPARM
This example sets the SERVERID for all IMS tables to TORONTO.
CALL SETXPARM('TABLETYPE', 'IMS', 'SERVERID', 'TORONTO', '');
This example sets the value of the Optimize Update field for the EMPLOYEE table to Y:
CALL SETXPARM('TABLENAME', 'EMPLOYEE', 'OPTIMIZEUPDATE', 'Y', '');
This example resets the SERVERID for IMS tables to the Table Definer default value.
CALL RESETXPARM ('TABLETYPE', 'IMS', 'SERVERID', '');
See Also
TIBCO Object Service Broker Shareable Tools for detailed descriptions of the SETXPARM and RESETXPARM tools.

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