| COLLATING_SEQUENCE |
Specifies whether the data source uses the same
default collating sequence as the federated database. Valid values
are Y, N, and I. I specifies a case-insensitive. The default is Y.
The collating sequence specified for the federated server must match
the collating sequence on the remote data source. |
| COMM_RATE |
Specifies the communication rate, in megabytes
per second, between the federated server and the data source server.
Valid values are whole numbers the are greater than 0 and less than
2147483648. The default is 2. |
| CPU_RATIO |
Specifies how much faster or slower the data
source CPU is when compared to federated server CPU. Valid values
are greater than 0 and less than 1x1023. The default is
1.0. Values can be expressed in any valid double notation, for example,
123E10, 123, or 1.21E4. A setting of 1 indicates that the federated
server and the data source server have the same CPU speed; a 1:1 ratio.
A setting of 0.5 indicates that the federated server CPU speed is
50% slower than the data source CPU. A setting of 2 indicates that
the federated CPU is twice as fast as the data source CPU. |
| CONV_EMPTY_STRING |
Specifies whether the federated server converts
an empty string into a space during replication tasks. Valid values
are Y and N. The default is N; the federated server does not convert
empty strings. Set this option to Y when the data source has a non-nullable
character column that stores an empty string. |
| DBNAME |
Required. Specifies the name of the database
that you want to access. Obtain the name of the database from the
Sybase server. |
| DB2_ID_QUOTE_CHAR |
Specifies the quote characters that are used
for delimited identifiers such as column names. If you do not specify
this option, double quotes are used by default. |
| DB2_MAXIMAL_PUSHDOWN |
Specifies the primary criteria that the query
optimizer uses to choose an access plan. Valid values are Y and N.
The default is N; the query optimizer chooses the plan that has the
lowest estimated cost. Y specifies that the query optimizer choose
the access plan that pushes down the most query operations to the
data source. |
| DB2_MAX_ASYNC_REQUESTS_PER_ QUERY |
Specifies the maximum number of concurrent asynchronous
requests from a query. Valid values are from -1 to 64000. The default
is 1. -1 specifies that the federated query optimizer determines the
number of requests. 0 specifies that the data source cannot accommodate
additional asynchronous requests. |
| DB2_TWO_PHASE_COMMIT |
Specifies whether the federated server connects
to the data source in two-phase commit protocol or one-phase commit
protocol. Valid values are Y and N. The default is N; the federated
server uses the one-phase commit protocol to connect. Y specifies
that the federated server uses two-phase commit protocol to connect. |
| DB2_UM_PLUGIN |
Specifies the implementation of the user mapping
plug-in. For a plug-in written in Java,
specifies a case-sensitive string for the class name that corresponds
to the user mapping repository class. For example, "UserMappingRepositoryLDAP".
For a plug-in written in C, specifies any valid C library name. |
| DB2_UM_PLUGIN_LANG |
Specifies the language of the user mapping plug-in.
Valid values are Java and C. The default is Java. |
| FOLD_ID |
Specifies the case for the user ID that is sent
to the data source. There is no default value; the federated server
sends the user ID in uppercase; then if the uppercase user ID fails,
the server sends the user ID in lowercase. Valid values are U (uppercase),
L (lowercase), and N (null). Avoid using the null setting, which might
result in poor performance. |
| FOLD_PW |
Specifies the case for the password that is
sent to the data source. There is no default value; the federated
server sends the password in uppercase; then if the uppercase password
fails, the server sends the password in lowercase. Valid values are
U (uppercase), L (lowercase), and N (null). Avoid using the null setting,
which might result in poor performance. |
| IFILE |
Specifies the path and name of the Sybase interface
file to use instead of the default interface file. The Sybase wrapper
searches for the interface file in the following places, in the order
specified: On Microsoft Windows, in the IFILE server option, then
in the %DB2PATH%\interfaces directory, and finally in the %SYBASE%\ini\sql.ini
directory. On UNIX, in the IFILE server option, then in the sqllib/interfaces
directory, and finally in the $SYBASE/interfaces directory. |
| IO_RATIO |
Specifies how much faster or slower the data
source I/O system runs when compared to the federated server I/O system.
Valid values are greater than 0 and less than 1x1023. The
default is 1.0. Values can be expressed in any valid double notation,
for example, 123E10, 123, or 1.21E4. A setting of 1 indicates that
the federated server and the data source server have the same I/O
speed; a 1:1 ratio. A setting of 0.5 indicates that the federated
server speed is 50% slower than the data source speed. A setting of
2 indicates that the federated speed is twice as fast as the data
source speed. |
| LOGIN_TIMEOUT |
Specifies the amount of time, in seconds, that
the federated server waits before abandoning a login request. The
default is 0; the federated server waits an unlimited amount of time. |
| NODE |
Required. Specifies the name of the node where
the Sybase server resides. The node name is in the Sybase interfaces
file. |
| OLD_NAME_GEN |
Specifies how to convert the column names and
index names that are in the data source into nickname column names
and local index names for the federated server. Valid values are Y
and N. The default is N; the generated names closely match the names
in the data source. Y specifies that the generated names are the same
as the names that were created in IBM® WebSphere® Federation Server Version 9 and
earlier. Thus, the names might not closely match the data source names. |
| PACKET_SIZE |
Specifies the packet size, in bytes, that the
client library uses to send tabular data stream (TDS) packets. If
the Sybase wrapper needs to send or receive large amounts of text
and image data, increase the PACKET_SIZE. |
| PLAN_HINTS |
Specifies whether or not plan hints are to be
enabled. Plan hints are statement fragments that provide additional
information that the data source optimizer uses to improve query performance.
The data source optimizer uses the plan hints to decide whether or
not to use an index and which index or which table join sequence to
use. Valid values are Y and N. The default is N; plan hints are not
to be enabled. Y specifies that plan hints are to be enabled at the
data source if it supports plan hints. |
| PUSHDOWN |
Specifies whether the federated server allows
the data source to evaluate operations. Valid values are Y and N.
The default is Y; the data source evaluates operations. N specifies
that the federated server send SQL statements that include only SELECT
with column names. Predicates, such as WHERE=; column and scalar functions,
such as MAX and MIN; sorts, such as ORDER BY OR GROUP BY; and joins
are not included in any SQL that the federated server sends to the
data source. |
| SERVER_PRINCIPAL_NAME |
Specifies the principal name of the Sybase server
when the principal name is different from node name. The default value
is the node name. |
| TIMEOUT |
Specifies the maximum time, in seconds, that
the federated server waits for the remote server to respond to a command.
The default is 0, which specifies an unlimited amount of time. |
| XA_OPEN_STRING_OPTIONS |
Specifies open strings for the Sybase DTM XA
interface. These strings are in addition to the LRM name, user name,
and password. |