Is there a query from a snapshot table, or some other method, to
monitor that a database is using trusted context connections? My
company is requesting that I run a report from our monitoring server
and report any non-compliant databases. Any assistance would be
greatly appreciated. We are running DB2 V9.5.0.4 on AIX.

Thank you.

Kermit L

On 3/10/2010 9:14 AM, Ultrak The DBA wrote:
I'm told there are three fields in the audit records dedicated to
trusted context.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

The audit record layout can be found here:
http://publib.boulder.ibm.com/infoce.../c0005633.html


--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

Ultrak The DBA wrote:
In addition to the link provided by Serge, here's some more:

"DB2 UDB security, Part 5: Understand the DB2 audit facility"
http://www.ibm.com/developerworks/da...man/index.html
(Based on v8, but still useful)

InfoCenter topic: "db2audit - Audit facility administrator tool command"
http://publib.boulder.ibm.com/infoce...n/t0011541.htm

Couple of articles on Rebecca Bond's blog (what's in a name...):
http://www.dbisoftware.com/blog/db2_security.php?id=151
http://www.dbisoftware.com/blog/db2_security.php?id=156
http://www.dbisoftware.com/blog/db2_security.php?id=162
http://www.dbisoftware.com/blog/db2_security.php?id=185

Cheers!

--
Jeroen