Command Center -- Overview

Use the Command Center notebook to execute DB2 commands and SQL statements, work with command scripts, and view a graphical representation of the access plan for explained SQL statements.

Tasks

• Executing single DB2 commands or SQL statements on the Interactive page
• Executing commands in sequence on the Script page
• Creating and saving a command script
• Running an existing command script on the Script page of the Command Center notebook
• Running an existing command script on the Interactive page of the Command Center notebook
• Viewing the results of a query.
• Saving query results.
• Creating an access plan
• Viewing a graphical representation of the Access Plan for an explained SQL statement
• Scheduling a job

Page controls

• Interactive
• Script
• Query Results
• Access Plan

• Execute
• Table Data
• Access Plan

Related information

• Script Center -- Overview
• Schedule -- Overview
• Journal -- Overview
• Creating a command script
• Selecting a database
• Changing script options

Troubleshooting tips

• Note:

  The Query Results page will be blank unless you have selected Automatically display query results on the Query Results page in the Command Center Options notebook, before executing the query, or until you execute a statement using the Retrieve Table Data icon.

• Note:

  The Access Plan page will be blank if there is no Access Plan for the most recently issued command.