Filter
Top Products
v Work with query results.
v View a graphical representation of the access plan for explained SQL statements.
v Run commands in sequence.
v Create and save a script. You can optionally store a saved script in the Task
Center, where you can schedule the script to run at a specific time.
On the Commands page, you can execute an SQL statement or DB2 CLP
command. You do not need to precede the command by "DB2".
Run and create a visual access plan, by clicking the Execute and Access plan icon
(from the left of the toolbar)
Run a command or statement, by clicking the Execute icon (at the left of the
toolbar).
On the Query Results page, you can see the results of the queries. You can also
save the results or edit the contents of the table.
On the Access Plan page, you can see the access plan for any explainable
statement that you specified on the Interactive page or the Script page when you
click on the Access plan or Execute and Access plan icon. DB2 generates the access
plan when it compiles the SQL statement. You can use this information to tune
your queries for better performance.
If you specify more than one statement on the Script page, an access plan is not
created unless you highlight a single statement.
You can get help writing SQL with the SQL Assist tool available from the Selected
menu of the Command Editor menu.
Figure 6. Command Editor window
Chapter 7. DB2 administration and development tools 47