Using server options in server definitions
There are general server options and server options that are for specific data source types.
Before you begin
The authorization ID issuing the ALTER SERVER statement must include either SYSADM or DBADM authority on the federated database.
About this task
See Restrictions on altering server definitions.
Server options are set to values that persist over successive connections to the data source. These values are stored in the federated system catalog.
To do this task from the command line prompt, issue the ALTER SERVER statement.
- You created a server definition for an Informix® server
using the server name of INFMX01. You now want to change the DB2_MAXIMAL_PUSHDOWN
option to Y. The statement to alter the server definition is:
ALTER SERVER INFMX01 OPTIONS (SET DB2_MAXIMAL_PUSHDOWN 'Y')
- You created a server definition for an Oracle server using the
server name of ORCL99. You now want to add the FOLD_ID and FOLD_PW
options to the definition. The statement to alter the server definition
ALTER SERVER ORCL99 OPTIONS (ADD FOLD_ID 'U', FOLD_PW 'U')
- You want to set the timeout value to the number of seconds the
CTLIB wrapper should wait for a response from the Sybase server. You
use the TIMEOUT server option to set this value. The statement to
alter the server definition is:
ALTER SERVER SYBSERVER OPTIONS (ADD TIMEOUT '60')