RE: Going from little to no journalling to MIMIX -- MIDRANGE-L

I can't give any projection as the journal hits will depend a lot on the
nature of your database activity and if you journal everything vs. the
minimum.  See http://www.redbooks.ibm.com/abstracts/tips0626.html and
http://www.redbooks.ibm.com/abstracts/tips0607.html .

That said, how about only keeping the minimum amount of receivers on the
production machine?  Cut your receivers frequently and once you know
MIMIX has shipped the contents to the remote box just delete them.  Back
'em up first if desired or if your audit policy dictates.

We journal the bulk of the main JDE database.  Without the minimizing
techniques above our receiver goes anywhere from 700MB-2.5GB a day with
around 300 concurrent users.  Basically it's small enough that I don't
even think about it.  YMMV of course.

If you're concerned about performance and can stand a risk of losing the
most recent transactions in a catastrophic failure, check this tip about
journal caching: http://www.redbooks.ibm.com/abstracts/tips0627.html

John A. Jones, CISSP
Americas Information Security Officer
Jones Lang LaSalle, Inc.
V: +1-630-455-2787 F: +1-312-601-1782
john.jones@xxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces+john.jones=am.jll.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+john.jones=am.jll.com@xxxxxxxxxxxx] On Behalf
Of rob@xxxxxxxxx
Sent: Thursday, October 26, 2006 2:15 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Going from little to no journalling to MIMIX

Boss wanted some projections on how much disk would be needed on a whole
new lpar for Mimix.  Our current system has little to no journalling and
receivers.  So I basically had to WAG a growth estimate for that of 30%.

Anyone have some before/after RTVDSKINF/PRTDSKINF combos?  I would think
that it might change based on age afterwards, receiver retention policy
and a host of other things I think I'll learn very quickly about.

Here's some projections.  However it may not paste well from Excel into
simply text supported by a list server.

GDIHQ - Current
                                % of          Size in
        Description             Disk  1,000,000 bytes
        User libraries       11.66   551242.5
        User directories       70.89  3351637.58
        Folders and documents   0.02      715.67
        QSYS                    0.13     6304.52
        Other IBM libraries     0.57    27064.37
        Licensed Internal Code  0.09     4443.1
        Temporary space         0.83    39396.16
        Unused space           15.54   734666.63
        System internal objects 0.17     7915.72
        Objects not in a library0.02      712.21
        TOTAL                  99.92  4724098.46


GDIHQ2 - Projected
                               % of         Size in
        Description              Disk 1,000,000 bytes
        User libraries          45.72%   716615.25
        User directories        28.75%   450673.7357    * Minus Domino &

some IXS cards
        Folders and documents    0.05%      715.67
        QSYS                     0.40%     6304.52
        Other IBM libraries      1.73%    27064.37
        Licensed Internal Code   0.28%     4443.1
        Temporary space          2.51%    39396.16
        Unused space            20.00%   313460.1839
        System internal objects  0.51%     7915.72
        Objects not in a library 0.05%      712.21
        TOTAL                  100.00%  1567300.92

        3 IXS cards                     -418051.5047
        New Total                       1149249.415


Subtract these directories         bytes
        /Domino             60,143,998,145
        /DOMFAX01              863,139,842
        /GDDATA             14,754,848,886
        /GDSHELP            23,109,347,466
        /GDSSALES            3,334,388,500
        /INTERNOTES          2,043,500,278
        /LEISERVE            1,027,821,254
        /NOTES01           468,804,094,348
        /QUALITY            36,456,664,248
        /SAMETIME01          1,098,278,047
                         611,636,081,014

Subtract these IXS files           bytes
        CITRIX1             16,680,919,302
        CITRIX2             17,618,601,222
        CITRIX4             17,774,881,542
        GDSBAAN1            11,227,541,508
        GDSEDI1             19,954,612,490
        GDSSQL              26,493,678,342
        HQLINUX          2,109,463,757,082
        PVCSQL              35,113,771,782
                       2,254,327,763,270

Leaving these IXS cards            bytes
        GDSNT              290,574,616,596
        HELPSERV            92,476,888,072

Add this (as yet to be determined) IXS card
        Unknown IXS card    35,000,000,000

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



This email is for the use of the intended recipient(s) only.  If you have 
received this email in error, please notify the sender immediately and then 
delete it.  If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this email without the author's prior permission.  
We have taken precautions to minimize the risk of transmitting software 
viruses, but we advise you to carry out your own virus checks on any attachment 
to this message.  We cannot accept liability for any loss or damage caused by 
software viruses.  The information contained in this communication may be 
confidential and may be subject to the attorney-client privilege. If you are 
the intended recipient and you do not wish to receive similar electronic 
messages from us in future then please respond to the sender to this effect.