Using the DBA Command Manager for DB2 Module › Issue SQL Statement or DB2 Command

Issue SQL Statement or DB2 Command

Use the DBA Command Manager for DB2 module to enter an SQL statement or a DB2 command. This module processes the DB2 command or SQL statement, displays the returned messages, and displays the results of the SQL execution, if applicable.

Follow these steps:

1. Add the DBA Command Manager for DB2 module to a dashboard.
2. Use the connection toolbar to select the DB2 subsystem and LPAR, SQLID, Explain Schema, and the maximum number of SELECT statements to review and display.

   Note: If the selected subsystems do not appear, close and reopen the module.

3. Enter the SQL statement or DB2 command in the text box, and click Submit.

   Note: Enter the statement syntax using capital letters. Enter one SQL statement at a time. The module input statements are limited to 1,000,000 characters. Multi-line comments are not supported.

   The following processing occurs:

   • If you entered an SQL statement, the Messages tab contains the status of the SQL execution unless you executed a single SELECT query. In this instance, the Messages tab is disabled. The Results tab contains the output from running an SQL SELECT statement. The data that is retrieved from a column of type XML, CLOB, BLOB, or DBCLOB is limited to 32 KB per row.
   • If you entered a DB2 command, the module executes the DB2 command and displays the results of the command in the Messages tab. If the size or the sum of the column length is larger than 4096 bytes, the data is truncated.

   Note: This module cannot display binary data in hexadecimal form.

4. (Optional) Click the Recent Commands History icon to display the last 100 previously saved command entries. The most recently saved commands appear on the top. These commands are sorted by date and time. The grid contains two columns—Description and Date/Time. The description inside the grid is an active link. Selecting this link closes the panel and populates the Input field with the selected history item. Initially, the active link displays the first 50 characters of the command. When you click the active link, the module fetches the entire command from the database and displays it in the input area.
5. (Optional) Click the Import icon to import SQL statements or DB2 commands from a .txt file or a .sql file. Click Browse to select a file, and click Import. The SQL statements or the DB2 commands from the selected file appear in the input text area. Click Submit and the output appears in the command results area.

   Note: The DBA Command Manager for DB2 validates the selected file. The file must be a .txt file (UTF-8 or ASCII) or .sql file, less than 100 KB. Binary files are not supported.