RE: Audit log retention & disk space

Yes, this "COMMON" thing I keep hearing about. ;) I was actually going to go on my own dime this year, but it conflicts with my nephew's HS graduation.

I figure 12 months of audit journal receivers would take about 31% of total disk space.




-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Monday, February 20, 2017 11:56 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Audit log retention & disk space

Nothing jumped out at me. And I did a little looking.
If you can pin Larry Youngren down (he's often at COMMON) he really knows journalling. Generated a patent or two...

Aw, come on, journal receivers really don't take that much space, do they?
:-)
% of Size in
Library Owner Disk 1000 bytes
#MXJRN MIMIXOWN 40.19 2307471319.0
QGPL QSYS 10.04 576578322.4
ERPLXF SSA 9.80 562905935.9
ERPLXSAVF SSA 2.88 165088206.8
ERPLXUSRF SSA 1.30 74367381.5
YEAREND SSA 1.24 71059025.9
QPFRDATA QSYS 1.10 63408488.4
GDIDIVF SSA 1.04 59857735.7
ROUTINES ROB .87 50072121.3
EXPRESS SSA .86 49544912.9
EXPRESSD SSA .83 47781310.5
...




Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: "MIDRANGE-L (midrange-l@xxxxxxxxxxxx)" <midrange-l@xxxxxxxxxxxx>
Date: 02/20/2017 11:57 AM
Subject: Audit log retention & disk space
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



It's been recommended that we retain our audit log journal receivers on
DASD to 3-12 months. I figured the amount of disk required for that, and
it's not good. I know that DB journals have ways to reduce their size. Is
there anything similar for the audit journals? Other than changing what's
logged, any way to reduce their size?

TIA