IBM DB2 on iSeries/AS400

The IBM DB2 Connection is available for databases on iSeries/AS400, which is discussed on this IBM Knowledge Center page.

Prerequisites

  • DB2 running on iSeries/AS400 mainframe (min version tested v7.4)
  • Network connectivity
  • Hostname or IP address
  • Port Number (SSL or non-SSL)
  • Database name
  • Database access credentials

Create a new DB2 on AS400 connection

Step 1: Select Ingest and then select + New Connection. Under Database, select DB2 on AS400 (see Figure 1).

14321432

Figure 1

Step 2: Complete the required fields within the connection settings (see Figure 2).

10701070

Figure 2

FieldRequiredDescription
Access TypeRequiredThe type of connection for DB2 on AS400 is Read-Only.
HostRequiredIP or the hostname of the DB2 server.
PortOptionalHost server port number. The default port number for DB2 on iSeries/AS400 is 8471 (non-SSL) or port 9471 (SSL). Reference: IBM Toolbox for Java.
Database NameRequiredThe database name you are connecting to.
Custom Connection PropertiesOptionalProperties specified when connecting to DB2. See Properties for DB2 on AS400 using JDBC below for Ascend specific formatting.
Requires CredentialsOptionalChoose from existing credentials or create new credential for connecting to DB2 Database on AS400 if 'Requires Credentials' checkbox is selected.

Custom Connection Properties

Ascend utilizes JDBC to connect to IBM DB2 on iSeries/AS400 which allows for many property specifications. The names of keys and values can be found in the IBM Toolbox for Java JDBC properties documentation.

Ascend specific formatting

To specify properties in Ascend, do not use quotations. Present each property as newline-delimited key=value pairs (see Figure 3 below for an example).

11291129

Figure 3.

Create new credentials

If the Requires Credentials checkbox was selected and you do not want to use an existing credential or need to set up a new one, you'll need to enter a credential name, credential type, username, and password (see Figure 4).

681681

Figure 4

FieldRequiredDescription
Credential NameRequiredThe name to identify this credential with. This credential will be available as a selection for future use.
Credential TypeRequiredThis field will automatically populate with DB2 on AS400.
UserRequiredThe DB2 username to connect with.
PasswordRequiredThe DB2 password to connect with.

Step 3: Use TEST CONNECTION button to check whether credentials are correctly configured and If ALL PASS, click CREATE (see figure 5).

13251325

Figure 5.


More Reading