MicroStrategy ODBC Driver for DB2 Wire Protocol for IBM Db2 for i for Windows and Linux

The following information is required for setting up the driver connection for MicroStrategy ODBC Driver for DB2 Wire Protocol for IBM Db2 for i:

• Data Source Name: A name to identify the Db2 data source configuration in MicroStrategy. For example, Finance or Db2-1 can serve to identify the connection.
• IP Address: The IP Address of the machine where the catalog tables are stored. This can be either a numeric address such as 123.456.789.98, or a host name. If you use a host name, it must be located in the HOSTS file of the machine or a DNS server.
• Collection: The name that identifies a logical group of database objects.
• Location: The Db2 location name, which is defined during the local Db2 installation.
• Isolation Level: The method by which locks are acquired and released by the system.
• Package Owner: The package's AuthID if you want to specify a fixed user to create and modify the packages on the database. The AuthID must have authority to execute all the SQL in the package.
• TCP Port: The Db2 DRDA listener process's port number on the server host machine provided by your database administrator. The default port number is usually 446.
• Enable SSL: The data is encrypted using SSL. If the database server does not support SSL, the connection fails.
• CryptoProtocolVersion: Specifies a cryptographic protocol or protocols that can be used when SSL is enabled.
• ValidatedServerCertificate: Determines whether the driver validates the certificate that is sent by the database server when SSL encryption is enabled.
• TrustStore: Enter the directory of the truststore file to be used when SSL is enabled.
• Host Name in Certificate: Enter a host name for certificate validation when SSL encryption and validation are enabled.