On Tue, 3 Jun 2003 02:09:56 -0700 (PDT), sami dba wrote:

>Hi All,
>
>Q1)
>If i have only CONTROL privileges(nothing else) on TABLE_A,
>Can i insert/delete records into TABLE_A?

Cannot help with this one

>Q2)
>What is fenced user-defined function and non-fenced user-defined functions?

When a fenced user defined function is invoked, DB2 starts a sub-process,
which loads the shared module/dll holding the user-defined function. The
main DB2 process then communicates with the sub-process via IPC to pump
data through the user defined function.

In the case of an unfenced user defined function, the main DB2 process loads
the shared module/dll holding the user-defined function directly and calls the
function directly.

An unfenced function is vastly faster than the fenced function. However, the
trade off is that if you have any errors in the UDF, then you will crash the main
DB2 engine and the system will be down, and will require a recovery when
restarted. So, if you are POSITIVE you have no errors in your UDF, then
make it unfenced. If you have ANY doubts, make it fenced.

Richard


DB2 & UDB email list listserv db2-l LazyDBA home page