I use the db2expln facility for generating the plan without executing
it Try here:
http://publib.boulder.ibm.com/infoce...c/r0005736.htm
On Nov 18, 7:31*am, w.l.fisc...@googlemail.com wrote:
Quote:
Hi,
>
the following sequence:
>
set current explain mode yes;
set current explain snapshot yes;
>
update ...;
>
set current explain mode no;
set current explain snapshot no;
>
rollback;
>
Will result in that the explain tables are not written (rolled back).
>
Is there a way to explain an update statement without commit?
>
BTW: It is not an option to just use "explain mode explain", because
I'm creating temporary tables, so I have to set "explain yes".
