Is DBAM library in your production library list? Or Not?

[Eric Lehti]

Is DBAM (DataBase Audit Manager) library in your production library list? Or Not?
The A92 DataBase Audit Manager User Guide specifies that it is not necessary to include the DBAM library in any library list or environment. You specify the library name in DBAM setup/configuration when you create a DBAM audit.
We decided to include the DBAM library (containing audit files) in our production library list for this reason.

We create World Writer queries to audit activity in Audit Log files located in our A92DBAM library. It is more convenient to define the World Writer file with *LIBL instead of hard-coding the A92DBAM library name in video 82101 (file F82101).

 

[Eric Lehti]

We wrestled with this decision when we decided to implement the auditing feature in J31225 function key 10.
J31225 help text has superb instructions on how to do so.

Work Order Ledger Inquiry program (P48019) needs DBAM files.

 

[Jim_rubino]

Hello Eric,

It is NOT necessary to include the DBAM audit library in any of your librar y lists for the DBAM to be working. It works based on the configuration an d the triggers you have setup in DBAM.
We DO have the audit library in our library lists for the same reason that you mentioned, users creating and running WW=92s over the audit files.

I hope this helps. I hope all is well with you and Nancy?
Jim

From: [email protected] [mailto:[email protected]] On Beh alf Of Eric Lehti
Sent: Thursday, August 30, 2012 10:50 AM
To: [email protected]
Subject: Is DBAM library in your production library list? Or Not?


Is DBAM (DataBase Audit Manager) library in your production library list? O r Not?
The A92 DataBase Audit Manager User Guide specifies that it is not necessar y to include the DBAM library in any library list or environment. You speci fy the library name in DBAM setup/configuration when you create a DBAM audi t.
We decided to include the DBAM library (containing audit files) in our prod uction library list for this reason.

We create World Writer queries to audit activity in Audit Log files located in our A92DBAM library. It is more convenient to define the World Writer f ile with *LIBL instead of hard-coding the A92DBAM library name in video 821 01 (file F82101).

 

[Leith]

Re: RE: Is DBAM library in your production library list? Or Not?

Jim is quite correct that the library doesn’t need to be in the library list, but be careful not to move the audit objects from the audit library or to rename the library itself.

These are explicitly declared in the trigger definition and trigger program.

 

[Luke Phillips]

Hi Eric,

Just a question: How do you find DBAM? Most companies are using journaling these days rather than triggers.