How do know my procedure getting recompiled?

"jcolins" <r_josephcollins (AT) rediffmail (DOT) com> wrote

You can tell in different ways, for example by enabling traceflag 302 -- if
there's 302 output, the proc is recompiled. You can also look at
monCachedProcedures.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

Alternatively, enable trace 214 where ouput will indicate recompilation occurs.
1> exec proc_a
2> go
Execution required recompilation with status of:
(0x00001000 (MULT_RECOMPILE), 0x00000010 (SCHEMACT), 0x00000002 (RECOMPILE)),
for procname = proc_a, procid = 486293001, dbid = 2
at statement = 1, line = 1
c1 c2
----------- -----------
10 10

(1 row affected)

-Terence

"jcolins" <r_josephcollins (AT) rediffmail (DOT) com> wrote