Configure Datastores for Db2

You can connect to a Db2 database using two methods. The recommended method is to use connection strings, as these can be used for both 32-bit and 64-bit client connections. Connection strings are configured using the connect attribute within the configuration file. If you do not use connection strings, you must connect using ODBC DSNs.

Db2 datastores can be created in their own database, or you can store many datastores in a single database - this database may also contain one or more region databases, and a single cross-region database.

Unlike some other database types, Db2 does not support the mixing of ANSI and EBCDIC collating sequences for table columns in the same database. This means that if you require EBCDIC files to be used, they need to be deployed to a separate datastore database to non-EBCDIC files. However, IBM does not provide commands to allow the creation of databases with an EBCDIC collating sequence; instead, you need to use a Db2 API call to achieve this, which is called when using the dbfhadmin -createdb -ebcdic syntax. The actual collating sequence used is that specified by the MFCODESET environment variable. If MFCODESET is not set, the default collating sequence for the platform is used.

Use these steps to configure datastore databases in Db2.