Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    207

    Answered: DB2 Explain on z/OS without Data Studio

    Hello Friends,

    can anyone explain me the db2 explain? i have a long sql query and i dont want to use the Data Studio for it.

    Thanks in advance for this.

    Best regards,

    Christian

  2. Best Answer
    Posted by DNance

    "explain plan set queryno =9999 for select.....

    you can run the above in qmf, spufi, toad, batch job like dsntep2 or 4, then query plan table"


  3. #2
    Join Date
    Oct 2007
    Posts
    161
    Provided Answers: 9
    explain plan set queryno =9999 for select.....

    you can run the above in qmf, spufi, toad, batch job like dsntep2 or 4, then query plan table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •