|
|
confirm trusted context from remote reporting server
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
|
|
0
|
|
|
|
Reply
|
 Ultrak
|
3/10/2010 2:14:36 PM |
|
On 3/10/2010 9:14 AM, Ultrak The DBA wrote:
> 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.
There is no monitoring, but there is auditing. Take a look in that area.
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
|
|
|
0
|
|
|
|
Reply
|
Serge
|
3/10/2010 3:35:16 PM
|
|
The audit record layout can be found here:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.sec.doc/doc/c0005633.html
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
|
|
|
0
|
|
|
|
Reply
|
Serge
|
3/10/2010 4:05:19 PM
|
|
Ultrak The DBA wrote:
> 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
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/data/library/techarticle/dm-0603wasserman/index.html
(Based on v8, but still useful)
InfoCenter topic: "db2audit - Audit facility administrator tool command"
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.udb.doc/admin/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
|
|
|
0
|
|
|
|
Reply
|
The
|
3/10/2010 10:50:43 PM
|
|
|
3 Replies
534 Views
(page loaded in 0.04 seconds)
Similiar Articles: confirm trusted context from remote reporting server - comp ...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 reques... Smartnet - should we purchase? - comp.dcom.sys.ciscoconfirm trusted context from remote reporting server - comp ... Smartnet - should we purchase? - comp.dcom.sys.cisco confirm trusted context from remote reporting server ... HP48G+ to windows xp - comp.sys.hp48confirm trusted context from remote reporting server - comp ... file opening slows down - puzzling - comp.lang.xharbour If you can confirm that the problem is the new ... Repeated SQL and ResultSet in a method - comp.lang.java.programmer ...confirm trusted context from remote reporting server - comp ..... there a query from a snapshot table, or some other method ... Cheers Serge -- Serge Rielau SQL ... file opening slows down - puzzling - comp.lang.xharbourHP48G+ to windows xp - comp.sys.hp48 confirm trusted context from remote reporting server - comp ... file opening slows down - puzzling - comp.lang.xharbour If you can ... Slow telnet and ftp - comp.sys.sun.adminOnly context change seem a bit frequent but i am ... get a shell prompt, what does who am i report back? If the remote ... before i got this problem. > > Sylvain Check ... basic questions about the leapsecond - comp.protocols.time.ntp ...So, why do so many drivers not report it immediately? ... 005, stability=0.018 C:\>ntpq -n -p pixie remote ... To check a server near you, run ntpq, as and rv commands > for ... Oracle 10g on HP-UX, Terrible Poor Performance!! - comp.sys.hp ...Server is a HP 9000, 4 CPUs (750 MHZ). It is connected ... I changed the output of disk report to "Report IO by ... Local Controller Product Revision:____A120 Remote ... Incredibly slow! - comp.graphics.api.opengl... plug-ins. Everything's fine apart from the odd report of ... get a p-buffer offscreen accelerated rendering context ... When I create ODBC connection, put server address and ... How best to detect duplicate values in a column? - comp.databases ...... it into alphabetical order by shortitl and then check ... do you come up with a consensus answer you could report ... once in a while there's a long pause before the server ... confirm trusted context from remote reporting server - comp ...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 reques... Access to the remote server is denied because the current security ...Access to the remote server is denied because the current security context is not trusted. A few facts ... The report previews fine in ... Check -- Impersonate the ... 7/28/2012 12:12:22 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
0 followers. 