Acess plan for update query does not come up

[rdevarajan]

We are using db2 UDB on aix v8

Through control centre I am trying to get the access plan for an update statment

update orders
set (orstat, orustmp) = (?, current timestamp)
where orrfnbr = ? and
orstat =?

WE have around 4 triggers attached to the orders table.
When i try getiing the access plan , it just hangs... my machine starts going to 100% utilisation and hangs...

Normally to execute a statment with many triggers we increase the statement heapsioze..this statement executes fine. So i am not sure whats happening.

Please throw some light...

cheers
R

 

[juliane26]

Are you using the Control Center GUI for the access plan ?

Well, if the java stuff is not working, try ascii:

run a
> db2 explain plan with snapshot for "update... <your statement>
>db2exfmt
enter the db name, leave the defaults (default timestamp is last explain done), enter an output file, otherwise it just goes on the screen.
And there you are.

at least you will see whether it is the explain making efforts or the java stuff of the GUIs, with 4 triggers it sure can take some time ....


Juliane

 

[rdevarajan]

Thanks
I am able to explain the statment on ascii... so not sure why am not bale to do the same on control center GUI

cheers
R

 

[juliane26]

That is java GUI for you ...

In version 6 or 7 it was bad, especially on AIX I remember waiting for ages ...

Juliane