The Data Studio web console supports these job types for DB2 for Linux, UNIX, and Windows: SQL-only script, DB2 CLP script, and Executable/Shell script. For DB2 for z/OS databases, only the SQL-only script job type is supported.
Table 1. Summary of job types
|Job type||Communication method|
|SQL-only script||The job manager connects to the database and runs the SQL commands included in the job script directly against the database via JDBC.|
|DB2 CLP script||The job manager remotely executes the script by invoking the DB2 command-line processor (CLP) on the database server system via SSH, by using the associated database connection user credentials.|
|Executable/Shell script||The job manager remotely executes the script on the database server system via SSH, by using the associated database connection user credentials.|
If you want to run DB2 CLP or Executable/Shell scripts in your jobs, make sure the SSH server is active on the system where the script will be executed, and the user credentials associated with the database connection in the Data Studio web console has SSH access permission. Also, remember to allow for SSH port access in your firewall rules.