Tutorial: Connecting to an IMS Database

Goal

Create and verify an IMS database connection.

Prerequisites

IMS must be configured with ODBM and IMS Connect. See Prerequisites for more information.

Steps

1. In the IMS Connections view, click the Add IMS Connection(s) button.
2. Click Add IMS DB Connection.
3. Specify a name for the new database connection.
4. The ims.connections.json project file opens and the following database connection contents are added to the profile. Save your file changes.

Note: Ensure to replace placeholder information such as yourIMShostname and yourPSBname with your intended connection details.

{
  "profiles": {
    "imsdb": {
      "databaseConnectionName": {
        "dataStoreServer": "yourIMShostname.com",
        "portNumber": 5555,
        "databaseName": "yourPSBname",
        "fetchsize": 100,
        "maxrows": 500,
        "autocommit": false
      }
    }
  },
  "autoStore": true
}

4. Use the IMS Connection button in the status bar to verify or switch the active target IMS database connection.
5. Once connected, your database connection icon changes to green to indicate successful connection. DBDs and PSBs are available in the tree view by clicking the drilldown option next to the database connection.

Result

Your connection is ready for use to browse an IMS database execute SQL.