db2caem – Get Actual Row Counts in Your Explain Plans

You may also like...

5 Responses

  1. Sue says:

    Thank you for all the info.
    I did try the CLP you wrote above and didn’t work

    The error message say.
    DBT7020E “db2caem”: The db2caem command failed because the specified output path does not e qualified. Specified output path: “/home/db2inst/f21monitor/query2.caem”.

    I did specify the path of output.
    Could you please tell me what I did wrong?

    Thank you in advance.

  2. sekhar says:

    Excellent articles. I like all your posts. Thanks for sharing your knowledge

  3. Bruno Almeida says:

    Hi Ember,
    I did try db2caem. The statements must be declared with real values on the where clause. If we try using parameter markers, the analyser tool returns CLI0100E (Wrong number of parameters.).


Leave a Reply

Your email address will not be published. Required fields are marked *