DB2 Connection Parameters

DB2 database name

Enter the name (alias) of the DB2® database that was used when the DB2 client was configured.

DB2 connect string

Optional. Enter name/name value pairs that theDB2 CLI or ODBC vendors can accept.

Collation sequence

Enter the collation sequence to be included in the database connection string.

Collation sequences are required only in rare cases where there may be sorting discrepancies between IBM® Cognos® BI and a database. We recommend that you contact customer support before using a collation sequence.

Open asynchronously

Not used.

Trusted context

Select this check box to allow IBM Cognos BI to attempt a trusted connection to an appropriately configured DB2 server. For more information, refer to the DB2 administration documentation.

If you select this check box with a client or server that does not support the feature, you may get a connection error or a report execution error.

JDBC connections do not support a trusted connection. For this reason, the Trusted context check box does not display if the Configure JDBC connection check box is selected.

Timeouts

Specify the time in seconds within which you want the database to connect or wait for your reply before timing out. Valid entries are zero to 32,767. To have the database wait indefinitely, enter zero, which is the default.

Signon

For more information on signon, see Securing Data Sources.

If no authentication is required, click No authentication.

If authentication is required, click Signons.

If a user ID and password is required in the connection string, select the User ID check box.

If a password is required, select the Password check box and enter the password in the Password and Confirm password boxes.

To create a user ID and password that automatically connects to the data source, click Create a signon that the Everyone group can use. Enter the User ID and then enter the password in the Password and Confirm password boxes.