Parameter

Explanation

DSN*

This is the name of the data source name (DSN) you are configuring. It must match the catalogued name of the DB2 database.

Description

This field provides a description of the DSN to distinguish it from others.

Database type*

This indicates for which type of database you are configuring this DSN (DB2).

Driver

On the New Data Source Name page, this is the name of the ODBC driver installed for the type of database selected in the Database type box (DB2). It is a nonconfigurable field.

On the Edit Data Source Name page, this is the absolute path name of the ODBC driver specified for this DSN. It is a configurable field.

Database*

This entry must match the catalogued name of this DB2 database. The data source name (DSN) specified above must match this entry.

LogonID*

This is the username required for accessing the database. If the username is not provided when configuring a system DSN, every connection string using this DSN must include the username.

Important Security Note:

To prevent access to a database by unauthorized users in shared Web hosting environments, it is recommended that the username and password be provided in each connection string, rather than in the system DSN.

Password*

This is the password required for accessing the database. If the password is not provided when configuring a system DSN, every connection string using the DSN must include the password.

Important Security Note:

To prevent access to a database by unauthorized users in shared Web hosting environments, it is recommended that the username and password be provided in each connection string, rather than in the system DSN.

IPAddress*

This is the IP address for the database server (DB2).

TcpPort*

This is the port for the database server (DB2).

Location

Specify this attribute only if the DB2 database is running on OS/390.

Location is a path that specifies the DB2 location name. Use the name that was defined during the local DB2 installation.

Collection

Specify this attribute only if the DB2 database is running on OS/390.

Collection is the name that identifies a group of packages. These packages include the Connect ODBC for DB2 Wire Protocol driver packages. The default is DATADIRECTOO.

Package

This is the package created by the DataDirect driver that reflects all of the parameters associated with a specific database (the parameters you specified).

Package is displayed in the Administration Console only when you are editing an existing DSN, not adding a new one.

Note: Do not edit this package. The package is unique to a specific database.