I am trying to determine the behaviour of stored procedures in DB2 V8.2.x in
Windows/Unix/Linux and how I can control that behaviour. Some documentation
in the manuals is confusing the issue somewhat.
First, am I right in understanding that the normal behaviour of a stored
procedure, fenced or unfenced, is to only go into memory when it is invoked
and to be swapped out of memory when it is not needed any more?
Second, am I right in understanding that setting KEEPFENCED = YES in the DBM
config parameters is the way to override the default behaviour and force the
stored procedure to stay resident even when it is not used?
Now, a word about the confusion in the manuals. I was researching this
question in the manuals and found a topic entitled "Specifying general
properties". It says that there is an option for 'Stay resident at exit' in
the Create Procedure notebook in the Development Center. The problem is that
I can't find any such option anywhere. I suspect that the manual is not in
sync with the code in the Development Center. I am experiencing this on a
V8.2.2 copy of DB2 at a client site.
Am I just particularly dense today or am I right that there is no such
setting for stored procedures? If I am being dense and I can set this value,
could someone tell me EXACTLY how to get to the panel that has this option?
If the manual is wrong, what's the best way to notify the technical writers
so that they can fix this?
Rhino