With Omegamon for DB2 PE v5.40, with PWH configured, from classic interface, I can run Explain function of SQL text in thread active or in SQL cache. The customer requests the ability to edit EXPLAIN report, to correct the SQL query and rerun the Explain. The sql texts are very long, is impossible for the customer to do copy/paste of the rows.
It is an enhancement fundamental for the customer, which he is used to using in CA sysview. He must have the possibility with OMPE, classic interface, in EXPLAIN report, to modify the queries and re-evaluate them with the explain.
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions