Strategy recommends using the provided drivers in the installation since it was fined tune to work with Strategy Software.
Open Strategy Connectivity Wizard and select "Strategy ODBC Driver for DB2 Wire Protocol for UDB for iSeries and then hit next and fill out the information as shown in the image below.
Data Source Name:
Enter a name to identify the data source configuration in Strategy. For example, Finance and DB2UDBiS-1 can serve to identify the connection
IP Address:
Enter the IP Address of the machine where the catalog tables are stored. This can be a numeric address such as 123.456.789.98 or a host name which is located in the HOSTS file of the machine or a DNS server.
Collection:
Enter the name that identifies a logical group of database objects. On AS/400, it is also the current schema.
NOTE: Collection in the Strategy driver is equivalent to the Library/Schema in IBM's driver.
Location:
Enter the DB2 location name, which is defined during the local DB2 installation.
NOTE: Location in the Strategy driver is equivalent to the Database in IBM's driver.
Isolation Level:
Select the method by which locks are acquired and released by the system.
Package Owner:
Enter the package's AuthID if you want to specify a fixed user to create/modify the packages on the database. The AuthID must have authority to execute all the SQL in the package.
TCP Port:
Enter the DB2 DRDA listener process's port number on the server host machine provided by your database administrator. The default port number is 446 in most cases.
Note: The Strategy driver does not work with a File Based system. It needs to be a Database
KB423421
