Edit the general parameters for the connectivity settings in the odbc.ini file. The required parameters are indicated by an asterisk (*).
Parameter |
Comments |
|---|---|
*Driver |
The fully qualified path to the driver. |
*Ip address |
The Internet Protocol (IP) address of the machine where the catalog tables are stored. Specify the address using the machine's numeric address (for example, 123.456.78.90) or its host name. Warning! For Solaris systems, use the numeric IP address,
not the host name.
If you enter a host name, the driver must find this name (with the correct address assignment) in the HOSTS file on the workstation or in a data source name (DSN) server. |
*TcpPort |
Enter the port number that is assigned to the DB2 server on the machine where the catalog tables are stored. Specify either this port's numeric address or its service name. The
default numeric port address varies depending on the OS of the DB2
server machine. The default for:
If you specify a service name, the driver must find this name (with the correct port assignment) in the SERVICES file on the workstation. |
*Location (Required for DB2 UDB on AS/400 and z/OS only) |
This field is valid only if you are connecting to a DB2 database running on z/OS or AS/400. Type the DB2 location name, using the name defined during the local DB2 installation. Note: This parameter is not applicable if the Database Name
field is populated.
|
*Collection (Required for DB2 UDB on AS/400 and z/OS only) |
A field that is valid only if you are connecting to a DB2 database running on z/OS or AS/400. Enter the name that identifies a group of packages that include the ECDA DC DB2 DRDA driver packages. The default for DB2 and AS/400 is the user ID. Note: This field is not applicable if the Database Name field
is populated.
|
*Database (Required for connecting to DB2 on Windows and UNIX) |
The name of the database to which you want to connect to, by default. Note: This parameter is not used for AS/400 and z/OS.
|
*IANAAppCodePage (Required for UNIX platforms) |
A driver code page configuration property for the DB2 UDB driver, for example, 3, 4, 2004, and 2250. For a complete list of the values and their descriptions, see IANA. |
WorkArounds2 |
The name of the string key to allow the driver to pad the DB2 Char for Bit Data field with spaces. The value is 131072. |