Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Describing Db2 packages

( SPE2005 )

Use the Describe views to display details about all statements in a Db2 package. The Describe views display the following information:

  • Statement number for all statements
  • Statement text for all statements
  • Message severity for explainable statements
  • If you bound the package with Explain set to YES or ONLY:
    • Explain cost
    • Explain timestamp
    • Explain plan translation
You can also start an SQL Tuning session for a statement in the package.

To describe Db2 packages

  1. Select the DB2 Navigator perspective.
  2. Open or create an object view for packages.
  3. Select up to five objects from the packages list and click Describe .

    Alternatively, you can right-click the selected objects and select Describe.

    The Describe summary view is displayed in the Performance perspective.

    Legend

    #DescriptionDetails
    1View report

    Displays the Describe output in a Report dialog box

    To save the output to disk, in the Report dialog, click Save output text .

    2Statement detailsDisplays the following information for each statement:
    • Package name
    • Statement number
    • Statement text
    • Cost
    • Explain (YES) details
    • Explain (ONLY) details
    3Sort optionsSelect how to sort the statements from the following options:
    • Default sort
    • Sort by Cost
    • Sort by Severity
    4Performance perspective optionsDisplays the Performance perspective options. For more information, see Setting SQL tuning options.
    5Message severity indicator

    Indicates the highest severity of the message rules associated with the statement (if a message rule exists)

    IconDescription
    Severe
    Warning
    Information
    6DetailsDisplays the statement in the Describe details view
    7Describe statusDisplays the status of statement processing for the packages that you selected
  4. Select one of the following sort options:
    • Default order
    • Sort by Cost
    • Sort by Severity
  5. (Optional) To view the messages for the statement, click the message severity icon. 

  6. Click Details on the statement that you want to inspect.
    The Describe details pane is displayed that includes the complete statement, cost, and explain data.

    Legend

    #DescriptionDetails
    1BackDisplays the Describe summary view
    2Statement details

    Displays the following information:

    • Package name
    • Statement number
    • Statement text
    • Cost
    • Explain (YES) details
    • Explain (ONLY) details
    3Performance perspective optionsDisplays the Performance perspective options. For more information, see Setting SQL tuning options.
    4Message severity indicator

    Indicates the highest severity of the message rules associated with the statement (if a message rule exists)

    IconDescription
    Severe
    Warning
    Information
    5ExplainOpens an SQL Tuning Session for the statement. For more information, see Performance perspective.
    6Describe statusDisplays the status of statement processing for the packages that you selected.
  7. (Optional) To open an SQL Tuning Session, click Explain.
    For more information, see Performance perspective.


Was this page helpful? Yes No Submitting... Thank you

Comments