Connecting to an IMS database

You can create and manage connections to IMS™ databases by using the Data Source Explorer. Use the New Connection wizard to create a connection profile so that you can connect to an IMS database and browse data objects.

Before you begin

Make sure that the host system that you are connecting to is set up to support open access to IMS data. See Configuring IMS for open access to IMS data.

Procedure

To connect to an IMS database:

  1. In the Data Source Explorer, right-click the Database Connections folder, and click New.
    Tip: To reopen the Data Source Explorer, click Window > Show View > Other... > Data Management > Data Source Explorer. Click OK.
  2. Select IMS as the database manager and the IMS Universal JDBC driver as the JDBC driver. Enter the connection properties.
    Connection property Description
    Connection name Unique alphanumeric name for this connection.
    Host Name or IP address of the data store server (IMS Connect). Specify either the host name (for example, dev123.svl.ibm.com) or the IP address (for example, 192.166.0.2).
    Port number TCP/IP server DRDA® port number that is used to communicate with IMS Connect.
    User name User name for the connection to IMS Connect, provided by your RACF® administrator.
    Password Password for the connection to IMS Connect, provided by your RACF administrator.
    Default schema If the query contains unqualified objects, the default schema is used.
    Metadata source Location of the database metadata that represents the target IMS database.
    • If you select IMS catalog as the metadata source, enter the name of a PSB in the IMS catalog-enabled system.
    • If you select Local IMS Explorer project as the metadata source, select a Project and a PSB from the lists.

      To use the generated Java™ class file that is located in Project/IMS Universal Drivers Metadata/<psbname>/<PSBname>DatabaseView, select the Use DLIDatabaseView check box.

      Note: When Use DLIDatabaseView is selected, UserTypeConverters, Maps, and Cases are not supported.
    • If you select Local file system as the metadata source, browse to a .jar file that contains the Java metadata class. In the .jar file, the metadata class must be stored under a directory that is named for the PSB (for example, BMP255/BMP255DatabaseView.class, where BMP255 is the PSB name). The .jar file can contain multiple metadata classes. In the connection wizard, you must specify the name of the metadata class (for example, BMP255.BMP255DatabaseView).
  3. Optional: On the Tracing tab, clear the Disable tracing box to turn on tracing. Turning on tracing creates a log file of your activity that helps with troubleshooting problems.
  4. Optional: On the Optional tab, specify whether to use an SSL for your connection, a data store, a log-in timeout value, and any additional property values you want to add to the JDBC connection URL.

    You can specify more JDBC connection properties and set their values by using the Property name and Property value fields. For example, you can specify flattenTables and true to produce a flattened view of database tables and see the sub-elements of a STRUCT or an ARRAY as columns of a table.

    For all of the connection properties that the IMS Universal JDBC driver support, see Connecting to an IMS database using the JDBC DataSource interface (Application Programming).

  5. Click Finish.

Results

The connection is displayed in the Data Source Explorer.




© Copyright IBM Corporation 2010, 2017.