
300 DB2 II and WPS Synergy
following example activates (add), sets and deactivates (drop) a server
option:
ALTER SERVER DB2OS390SERVER OPTIONS (ADD IO_RATIO '2.0')
ALTER SERVER DB2OS390SERVER OPTIONS (SET IO_RATIO '3.0')
ALTER SERVER DB2OS390SERVER OPTIONS (DROP IO_RATIO)
To temporarily set a server option for the duration of a single connection to the
federated database, use the SET SERVER OPTION statement as follows:
SET SERVER OPTION COMM_RATE TO '3' FOR SERVER DB2OS390SERVER
The settings are not stored in the federated system catalog.
Table B-7 DB2 UDB for z/OS additional server options
B.7.4 Create the DB2 UDB for z/OS user mappings
As mentioned ...