db2fedsvrcfg command syntax - ODBC tuning utility
Use the db2fedsvrcfg command to improve the performance of the ODBC wrapper.
Syntax
db2fedsvrcfg -s serverName [-m odbcDriverManagerLibrary] -dsn odbcDSNname [-dbname dsDBname]
[-u userid] [-p password]
[-noprep] [-prefix tableNamePrefix]
[-suffix tableNameSuffix] [-dscp codePage]
[-v] [-o outputFile] [-h]
Parameters
Use the command db2fedsvrcfg32 when you use 32-bit ODBC drivers on AIX® or Solaris. Otherwise, use the command db2fedsvrcfg.
- -dbname dsDBname
- The database name of the data source.
- -dscp codePage
- The code page identifier for the data source. If this option is not specified, the utility uses the code page of the user's environment. This parameter is optional.
- -dsn odbcDSNname
- The system data source name (DSN) for the data source.
- -h
- Causes detailed help to be displayed. This parameter is optional.
- -m odbcDriverManagerLibrary
- The fully qualified file name of the ODBC driver manager library. The ODBC driver manager library file name is optional for Windows.
- -noprep
- Prevents the testing tables from being created at the data source before testing. This parameter is optional.
- -o outputFile
- The fully qualified file name for the ODBC tuning utility output file. The output file contains the ALTER SERVER statements that are used to tune the ODBC wrapper performance. This parameter is optional. If this parameter is not specified, the output is displayed in the command window.
- -p password
- The password for connecting to the data source. This parameter is optional.
- -prefix tableNamePrefix
- The prefix of the ODBC data source table names that the utility uses for the analysis. If a prefix is not specified, the default prefix, IITEST, is used. This parameter is optional.
- -s serverName
- The name of the federated server.
- -suffix tableNameSuffix
- The suffix of the ODBC data source table names that the utility uses for the analysis. If a suffix is not specified an empty string is used.
- -u userid
- The user name for connecting to the data source. This parameter is optional.
- -v
- Specifies that the output of the utility is verbose. This parameter is optional.
Example
The following example shows the command that is run against datastore, the ODBC data source. In this example, the test tables are named ABCnXYZ, where n is a number from 1 to 7.db2fedsvrcfg -s DS1 -m "/usr/lib/odbc.a"
-dsn datastore -dbname db1 -u authid -p password -noprep
-prefix ABC -suffix XYZ -o "/home/user1/db2fedsvrcfg.sql"