Hello, all.

db2 v9.

Can I switch on debug_mode flag of sql stored procedure created
initially without keeping debug info without dropping / recreating it?
I see the SYSPROC.PSMD_SET_DEBUGINFO in the system catalog, but this
procedure is undocumented.
What it is the procedure?
May be it can help me?

Sincerely,
Mark Barinstein.

4.spam (AT) mail (DOT) ru wrote:

You need to drop and recreate. Similarly to compiling e.g. C code in
debug mode an SQL Procedure will be instrumented with a lot of extra
code (which will make it slower).

As noted in the other post plans are to make DROP/CREATE less invasive
rather than providing point solutions.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

On Oct 5, 5:17 pm, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:
Thanks, Serge.