Datastore Database

Configuring in a Windows environment

1. In the search field next to the start icon, type ODBC and click ODBC Data Sources (64-bit).

   This opens the ODBC Data Source Administrator (64-bit) application.

2. Click System DNS tab.
3. Click Add.

   This opens the Create New Data Source dialog box.

4. Click PostgreSQL ODBC Driver(ANSI).
5. Click Finish.

   This opens the PostgreSQL ANSI ODBC Driver (psqlODBC) Setup dialog box.

6. In the Data Source field, type VSAM.
7. In the Description field, type a description for your datastore database. In this case, type VSAM Datastore.
8. In the Database field, type VSAM.
9. In the SSL Mode field, select disable.
10. In the Server field, type the location of the PostgreSQL server. In this case, type localhost.
11. In the Port field, type the port number to connect to the PostgreSQL server. In this case, it will be the default port, type 5432.
12. In the User Name field, type postgres.
13. In the Password field, type the postgres user's password.
14. Click Save.

Configuring in a UNIX environment

Open the .odbc.ini configuration file and add a data source entry for the datastore database which in this case, will store your VSAM files:

[PG.VSAM]
Driver = <driver-name>
Servername = <server-name>
Port = <port-no>
Database = VSAM

where:

<driver-name>

Specifies the name of the driver as configured in the odbcinst.ini file; in the example above, that would be PostgreSQL .

<server-name>

Specifies the name of the server on which the database instance resides.

<port-no>

Specifies the port on which the database is listening, typically 5432.

VSAM

Specifies the name of our datasource database.