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


Chapter 3 Tools : CHANGE_SERVERID

CHANGE_SERVERID
Updates the server ID of any external TIBCO Object Service Broker data types. (E)
Invocation
Do one of the following:
Type CHANGE_SERVERID (table_name, old_serverid, new_serverid) <Enter>
Type CHANGE_SERVERID (table_name, old_serverid, new_serverid) <Enter>
Where:
 
Note: You do not have to specify the table type.
Usage Notes
CHANGE_SERVERID provides an alternate way to update the server ID. Normally, one would update the server ID of an external table type through the Table Definer of that type.
For DB2, the new server ID must be predefined by the system administrator who manages DB2 table definition. Refer to TIBCO Service Gateway for DB2 Installing and Operating.
If a match of tablename and server ID is not found, the tool returns with OK, does not update the server ID of the table specified, and writes the details to the MSGLOG.
There is no check in place to ensure that the new server ID is valid. These checks are built in under the Table Definer.
Example
The server ID for DB2_EMPLOYEE is to be changed from DB2SVR1 to dedicated server DB2SVR2 to improve access performance. From the workbench, an authorized user goes to the EX Execute rule entry on the menu and types:
CHANGE_SERVERID(DB2_EMPLOYEE,DB2SVR1,DB2SVR2)
Accesses to the DB2_EMPLOYEE table are then serviced by server DB2SVR2.

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