× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




Tim, this no almost sounds like you want to audit incoming ODBC jobs.
Or do you want to audit all SQL requests, from any job?
for the latter:
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzaik/rzaikodbcexitprog.htm

Searching for QIBM_QZDA_SQL1/2 on the Googles might help.

Bryan



tim wrote on 4/12/2018 6:00 AM:
Thanks for all the feedback. Im am getting closer to what i want. In testing, i created the following sql:

SELECT * FROM TABLE (QSYS2.ACTIVE_JOB_INFO('NO','','','')) A,
              TABLE(QSYS2.GET_JOB_INFO(JOB_NAME)) B
where b.V_SQL_STATEMENT_TEXT <> ' '

This does a great job returning what i need, but i dont want to run this 24x7. I only need to run this when a user tries to access DB2 with an external program such as access, Vb program, etc. I like the idea of using and exit program. I see a plethora of options for this. Is there one i should focus on such as QIBM_QZDA_SQL1 that will allow me to get the info i need?




On 4/10/2018 11:55 AM, Justin Taylor wrote:
They should have QZDASOINIT (or QZDASSINIT) jobs in QUSRWRK subsystem.



-----Original Message-----
From: tim [mailto:iseriesstuff@xxxxxxxxx]
Sent: Tuesday, April 10, 2018 10:39 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: db access to iseries from pc's via ?

is there a way of telling who is connecting to the iseries db using things like access, excel, etc?

i want to be able to control these functions. I believe all our users have odbc set up as part of client access install.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.