Re: Looking for a user exit or something similar to monitor SQL commands being used.

Darryl,

See:
     https://archive.midrange.com/midrange-l/201708/msg00417.html ;

And see also:
     https://www.itjungle.com/2006/11/08/fhg110806-story01/

Hope that helps,

Mark S. Waterbury

On Friday, September 8, 2023 at 01:25:15 PM EDT, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

I need to track who is using SQL to do stuff in our database.
I have worked with the user exit, QIBM_DB_OPEN but that only gives me the file, library and user accessing the file.

I want to be able to receive the SQL command so that I can validate

  1. who is executing the command
  2. are they doing a SELECT, INSERT, UPDATE, DELETE....
  3. where the call is being made from.

With so many tools available today on a PC or UNIX system and SQL being learnt by so many, it is easy for anyone to do what they want.with the
database. 

We also have many users accessing the system using ODBC and Excel.

Does anyone know of another user exit or similar process that I can use to
monitor the SQL usage? The process needs to be able to return a result that will block the user from executing the command.

TIA, Darryl Freinkel.