Allowing event logging in TMUDF and scalar UDF

[Weishiun Tsai]

TMUDF (and scalar UDF if possible) should have a mechanism that allows the user implementing the TMUDF (or scalar UDF) to enter event log entries into the same event logging infrastructure that SQL uses. This allows the user to read the user-defined events through the same log TMUDF that will be used to access the rest of the SQL event log. This will greatly help debugging TMUDF (or scalar UDF) in a multi-node environment. It also consolidates the logging mechanism and opens up a channel to allow user-defined diagnosis information in UDF, much the same way like the rest of the SQL components.

After discussion with the TMUDF architect, we agree to enter this Wishlist item for considering such future enhancement.

[Hans Zeller (hans-zeller)]

Hope to add this to the C++ interface that is used at compile time right now, and should be extended to runtime.

[Hans Zeller (hans-zeller)]

Part of this has been done by Sandhya, who initialized the logging infrastructure for tdm_udrserv, so that we can now use a standard logger to create events. Hope to get a logging interface from the TMUDF in one of the next releases.