Fortinet black logo

Handbook (HTML)

Configuring DB2 options

Copy Link
Copy Doc ID 73ac471a-9afd-11ea-8862-00505692583a:16951

Configuring DB2 options

When you configure a connection to a DB2 database, on the DB2 Options tab, for Retrieval Method, select one of the following options. After you have completed the required settings, click Test Connection to verify them:

SSH

Select to configure FortiDB to connect to the database using Secure Shell (SSH), and then complete the settings on the SSH tab.

For more information on the SSH tab, see Configuring SSH connections to Oracle and DB2 databases.

DB2 Level Command

Select to configure FortiDB to connect to the database using the output from DB2 commands. Then, complete the following settings:

  • db2level Output — Enter the output of the db2level command (show DB2 service level command).
  • dbm cfg Output — Enter the output of the db2 get dbm cfg command (get database manager configuration command).
Use SQL query for connection

Select to configure FortiDB to use a SQL query to connect to the DB2 server.

To use this option, ensure that the FortiDB database user is granted EXECUTE permission on the stored procedure.

Configuring DB2 options

When you configure a connection to a DB2 database, on the DB2 Options tab, for Retrieval Method, select one of the following options. After you have completed the required settings, click Test Connection to verify them:

SSH

Select to configure FortiDB to connect to the database using Secure Shell (SSH), and then complete the settings on the SSH tab.

For more information on the SSH tab, see Configuring SSH connections to Oracle and DB2 databases.

DB2 Level Command

Select to configure FortiDB to connect to the database using the output from DB2 commands. Then, complete the following settings:

  • db2level Output — Enter the output of the db2level command (show DB2 service level command).
  • dbm cfg Output — Enter the output of the db2 get dbm cfg command (get database manager configuration command).
Use SQL query for connection

Select to configure FortiDB to use a SQL query to connect to the DB2 server.

To use this option, ensure that the FortiDB database user is granted EXECUTE permission on the stored procedure.