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
Procedure
To connect to an IMS database:
- 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.
- 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).
- 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.
- 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).
- Click Finish.
Results
- Adding an IMS Universal JDBC driver definition
To use multiple versions of the IMS Universal JDBC driver, you must add a driver definition for each version of the IMS Universal JDBC driver before you can connect to an IMS database.
© Copyright IBM Corporation 2010, 2017.