TechNote (Archived)

Connecting to DB2 OS/390 and Z/OS using DataDirect 3.4 or higher drivers

Issue

There are changes with connecting to DB2 databases, beginning with the release of the DataDirect version 3.4 database drivers.

Reason

You can no longer pass in a package for the driver to utilize while connecting. The packageName parameter is deprecated and can no longer be used. The package is created manually by the database driver at the initial connection with a default name ofDDJC330.

Solution

To connect to a DB2 database from ColdFusion MX with the DataDirect version 3.4 or higher drivers, use the following information:

Ensure that the user has permissions to create packages on the database for the initial connection.
On the initial connection, specify the following information:
- Server IP Address and Port
- User name
- Password
- Connection String:
  locationName={name of database to connect to};createDefaultPackage=true
  
  Note: Do not input a value for the 'Database' field when using Z/OS or OS/390.
After the initial connection has been made, changecreateDefaultPackage=false in the connection string properties.