Repository Database in Db2 for Linux, Unix and Windows
Fivetran HVR allows you to create a repository database in Db2 for Linux, Unix and Windows (LUW). The Repository Database section in Capabilities (6.1.0, 6.1.5) lists the supported Db2 for Linux, Unix and Windows (LUW) versions that can be used as a repository database.
Prerequisites
HVR requires Db2 client to be installed on the machine from which HVR connects to Db2. The Db2 client should have an instance to store the data required for the remote connection.
The Db2 client must be installed on a machine with the same "endianness" as the machine running the Db2 server. For instance, AIX and Solaris SPARC are big-endian operating systems, while Linux and Windows are little-endian. Therefore, if the Db2 server is running on AIX, the Db2 client should be installed on either AIX or Solaris SPARC.
To set up the Db2 client, use the following commands to catalog the TCP/IP node and the remote database:
db2 CATALOG TCPIP NODE nodename REMOTE remotehost SERVER portnumber db2 CATALOG DATABASE databasename AT NODE nodenameTo test the connection with Db2 server, use the following command:
db2 CONNECT TO databasename USER username
For more information about configuring Db2 client, refer to Db2 documentation.
Grants for Repository Database
The following grant is required for the repository database in Db2 for LUW:
- The HVR repository user should have permission to create and drop HVR repository tables.
GRANT CREATETAB ON DATABASE TO USER username
Repository Database Connection
This section describes the details required for connecting to the repository database in Db2 for LUW:
| Field | Description | Equivalent Location Property |
|---|---|---|
| INSTHOME | When using "Db2 client or Db2 server or Db2 Connect" the directory path of the Db2 installation must be specified. When using "IBM Data Server Driver for ODBC and CLI" the directory path of the IBM Data Server Driver for ODBC and CLI installation on HVR machine (e.g. /distr/db2/driver/odbc_cli/clidriver) must be specified. Example: /db2/9.7 | Db2_INSTHOME |
| DB2INSTANCE | When using "Db2 client or Db2 server or Db2 Connect", the name of the Db2 instance must be specified. When using "IBM Data Server Driver for ODBC and CLI" this field must be left blank/empty. Example: db2instl | Db2_DB2INSTANCE |
| DATABASE | Name of the DB2 database. Example: mytestdb | Database_Name |
| USER | Username for connecting HVR to the Db2 database. Example: hvruser | Database_User |
| PASSWORD | Password for the USER. | Database_Password |