Following are the options specific to DB2 Mainframe:
Connection Name: Enter a unique Connection Name. This fields accepts letters, numbers, and symbols.
Hostname: Enter the Hostname of the database or select from the list of available IPs. You can also search for the hostnames and IP addresses of databases by Find DBMS.
IP Address: Enter the IP Address for the connection.
Port Number: Enter the Port Number for establishing a connection. You can also edit the port number later, if required.
Subsystem Name: Subsystem name is required to connect to DB2 mainframe. Enter the subsystem name.
Authentication Method: There are three authentication methods:
DB2 Mainframe Server: Authenticates the connection using Username and Password.
Kerberos: Authenticates the connection using the Kerberos Username and Key Path.
Kerberos with Principal: Authenticates the connection using Kerberos system’s Principal Name and Password.
Use Connection String: A Connection String specifies the information about the data source and the means of connecting to it. Check the Use Connection String checkbox and provide the connection string. Use this option if you want to secure the connection using connection string instead of SSL.
Connection Attribute: Select the attribute name from the Connection Attribute drop-down. This functionality allows you to add tags to the created connection.
Databases/Schemas: Enter the name of the database in the Filter By Schema/DB Name text box. Check the Include System Schema/DB Name checkbox to include the required schemas and databases and then click Fetch Metadata. It will list down the available databases/schemas for the connection.
Check the databases or schemas name that you want to add as the target databases or schemas. The checked databases or schemas will appear in the Target Databases/Schemas panel.
To proceed further for remaining steps, refer Step 2 in RDBMS Detection Connection.