Analyzing an ad hoc statement

To analyze an ad hoc statement

1. In the Performance perspective, click the Add view  menu arrow and then click Add SQL Statement View.
2. Complete the SQL tab:
   1. Enter a name for the statement.

   2. From the DB2 Connection list, select a Db2 subsystem.

      Tip

      Click  and specify which Db2 connections to include in your list of favorite connections.

   3. ( Optional ) Enter the table qualifier. BMC AMI Command Center for Db2 uses this qualifier if the table in the SQL is unqualified.
   4. For the Explain Type, select Dynamic.
   5. At Degree, select the degree of parallel processing to allow:
      • Select Any to allow parallel processing.
      • Select 1 to prohibit parallel processing.
   6. Type or paste the SQL statement into the SQL statement box.

   7. Edit the SQL statement as needed:

      Purpose	Action
      Find a search string	Click Find/Replace . Enter the search string in the Search box. Click Find.
      Find and replace a search string	Click Find/Replace . Enter the search string in the Search box. Enter the replacement string in the Replace box. Click Find. Click Replace.
      Find and replace all instances of a search string	Click Find/Replace . Enter the search string in the Search box. Enter the replacement string in the Replace box. Click Replace All.
      Make a search case sensitive	Select the Match case checkbox.
      Enable syntax highlighting	Select the Use syntax highlighting for SQL statements Command Center option. For more information, see Setting Command Center options.
      View SQL statement options	Click Show more.
      Hide SQL statement options	Click Show less.
      Undo an action	Click  to undo the last action.
      Redo an action	Click  to cancel undoing the last action.

3. Click Generate explain plan . The Explain results are displayed along with the following tabs:
   • SQL (see SQL tab)
   • Indexes (see Indexes tab)
   • Explain (see Explain tab)
   • Cost (see Cost tab)
   • Predicates (see Predicates tab)