Configuring Db2 for z/OS tooling

To set general preferences for Db2® for z/OS® Development, use the Db2 for z/OS Preferences page.

To open the Db2 for z/OS page of the Preferences window, navigate to z/OS Solutions > Db2 for z/OS. You can set these preferences:

Log level: Sets the number and level of detail for messages that are written to the log file. The trace logging option records the highest level of detail, while error records only error messages. To turn off logging, select off. Messages are written to the metadata/.plugins/com.ibm.systemz.db2/logs folder of the Eclipse workspace.

HTTP port range: The default port range is 3100-3110.

Character conversion: Select an option for how to handle characters that cannot be converted between the client and server encodings. The default setting is to replace the character that cannot be converted with the replacement character �, �. You can choose instead to issue an error message when a character cannot be converted.

Max heap size (MB): The maximum size megabytes to use for the launched JVM that hosts the Db2 SQL service. The default is 256.

Connection keep alive: Specify a smaller number to send dummy queries more frequently.

Db2 JDBC driver: Displays the installed location of the Db2 JDBC driver. If you have or want to use a different or more recent JDBC driver, you can enter the location in this field or click Browse to navigate to the location.

Db2 JDBC driver license: Displays the installed location of the Db2 for z/OS client license. If you have or want to use a different or more recent JDBC driver license file, you can enter the location in this field or click Browse to navigate to the location. To import the db2jcc_license_cisuz.jar client license file, click Import License.
Attention: If you click Restore Defaults on this page, custom driver or license locations are cleared from these fields.

Debugger session manager port: Specify the port for the debugger session manager. You can specify multiple values or a range of values, for example, 4555, 4556, 4559-4985. If you specify multiple ports, the first available port is used. The default value is 4655-4665.

Service status: Displays the current status of the Db2 SQL service.

The Max number of rows returned and Max number of syntax errors fields set maximums for each query you issue by using the Db2 for z/OS > Run Selected SQL editor command.

If the Display result sets as plain text in the Console view checkbox is selected, result sets are displayed as plain text in the Console view instead of as a table in the Remote Systems Details view.

Available checkboxes:
  • Remove Carriage Return and Line Feed characters – strips new lines from the displayed content.
  • Remove Tab Characters – replaces tab characters with spaces.
  • Wrap Columns – wraps content within a column when it exceeds the maximum column width.

Maximum Column Width – specify the maximum width of a column. Content exceeding this width will be wrapped if Wrap Columns is enabled, or truncated if it is not.