Connecting to target databases : Adding (or modifying) a target connection : Configuring DB2 options
 
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.