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

Restrictions

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.

Procedure

To do this task from the command line prompt, issue the ALTER SERVER statement.

Example:

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 is:
```
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')
```