MicroStrategy ODBC Driver for IBM Db2 for z/OS for Windows and Linux

The following information is required for setting up the driver connection for MicroStrategy ODBC Driver for IBM Db2 for z/OS.

• Data Source Name: A name to identify the Db2 z/OS data source configuration in MicroStrategy. For example, Finance or Db2z/OS-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, which is also the current schema. On Db2 z/OS, the user ID should be used as the Collection.
• Location: The Db2 z/OS location name, which is defined during the local Db2 z/OS installation. To determine the Db2 location, you can run the command DISPLAY DDF.
• Package Collection: The collection or location name where bind packages are created and stored for searching purposes.
• Package Owner (Optional): 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.