SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB2 and the iSeries

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB2 and the iSeries
Author Message
Theresa



Joined: 13 Oct 2004
Posts: 4

Post DB2 and the iSeries Reply with quote

How do I set up my production libraries to use DB2 to aduit at the field level for certain users?

Wed Oct 13, 2004 2:52 pm View user's profile Send private message
Theresa



Joined: 13 Oct 2004
Posts: 4

Post Re: DB2 and the iSeries Reply with quote

: 1. I have installed the IBM Client Access ODBC driver and configured the
: connection. When I connect I am only seeing System Supplied tables.
: 2. I have installed DB audit software, I only see a DB Audit selection, not
: the one you site above.

I also notice that some of my tabs are gray, for example, I can not use the System Audit menu. When I try to generate triggers I am getting a message box that I need to supply the table. The software does not allow me to enter a table, I can only escape to get out. Is there a person I can talk to about this product. I really need to get it running today.

Wed Oct 13, 2004 4:21 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Re: DB2 and the iSeries Reply with quote

Please make sure you connect using an admin account.

: 1. I have installed the IBM Client Access ODBC driver and configured the
: connection. When I connect I am only seeing System Supplied tables.
: 2. I have installed DB audit software, I only see a DB Audit selection, not
: the one you site above.

Wed Oct 13, 2004 6:01 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Re: DB2 and the iSeries Reply with quote

System Audit menu is not enabled in DB2 because DB2 does not support it. System Audit is only enabled in Oracle and in Sybase.

: I also notice that some of my tabs are gray, for example, I can not use the
: System Audit menu. When I try to generate triggers I am getting a message
: box that I need to supply the table. The software does not allow me to
: enter a table, I can only escape to get out. Is there a person I can talk
: to about this product. I really need to get it running today.

Wed Oct 13, 2004 6:02 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Re: DB2 and the iSeries Reply with quote

Make sure QSYS and QSYS2 libraries are installed and contain standard catalog tables and views. That's it.

For a list of standard catalog views please see
http://publib.boulder.ibm.com/html/as400/v5r1/ic2931/info/db2/rbafzmstcatalog.htm

: How do I set up my production libraries to use DB2 to aduit at the field
: level for certain users?

Wed Oct 13, 2004 6:14 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.