How to see explain plan in iseries - DB2 Database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kamal1108
    New Member
    • Oct 2015
    • 1

    How to see explain plan in iseries - DB2 Database

    Am using a IBM iseries DB2 database which is configured in AS400 machine.
    am connecting data studio to connect to the database.
    Here am not sure of,
    a. How to see the explain plan for the query to find the bottleneck of the slowness.
    b. What are the privilages I need to see the explain plan for the query.

    Thanks,
Working...