All geek questions in one place

How does Reset UDF DETERMINISTIC revise?

In DB2 V5R4, when you change the functionality of DETERMINISTIC UDF, it returns a cached response for a while ...

Is there a way to reset cached responses?

Thanks in advance.

+6
source share
2 answers

Why does it return a cached response? Is it through a remote connection or native access? You can try closing and reopening any remote connection, or terminating and restarting any local jobs.

0
source

I had the same problem. Temporarily create a non-deterministic function, do your testing. When everything is in order, replace the deterministic function.

0
source

Source: https://habr.com/ru/post/908137/

More articles:


All Articles