Hi Debra,

It can be done - remember you are only archiving old records! But the file
reorgs which normally follow the archiving will not work if anyone else is
using the file. You will need to take the menu option to run the reorgs
afterwards, when nobody is using the files. If you don't do file reorgs, the
SQL will continue to read through all those deleted records, so you won't
gain as much as you ought to.
Triggers - you will have to turn these off before you run the archiving, and
then turn them on again afterwards. Of course, what this means is that if
you want to archive an area of BPCS where triggers are crucial to your
business, and you don't want to turn them off when people are using that
area, then you will HAVE to run the archiving when no users are in that part
of the system!
Hope that is clear!
If you are just using the triggers for monitoring purposes, then maybe you
could turn them off while the archiving is running - it's your judgement.
The other thing to remember is that the archiving runs faster if you give it
plenty of memory, so that it can use the indexes created for it. You may not
be able to do this if people are on the system, and then it may run very
Hope this helps!


Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS ('Locksmith' in the Western
Web: www.smallblue.co.uk and for UPI see
IBM Certified iSeries Systems Professional
Email: Clare.Holtham@xxxxxxxxxxxxxxx

----- Original Message ----- 
From: "Debra Glass" <GlassD@xxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Sent: Wednesday, June 01, 2005 6:55 PM
Subject: [BPCS-L] Small Blue Archiving

> Has anyone used the Small Blue archiving product for BPCS  WHILE USERS ARE
>   We have archived several modules while users are NOT on the system with
good success but would like to proceed with users on the system.  We often
run 24/7 and the modules we'd like to archive are Load Control and ITH.
Both of these modules on our system have triggers that must be updated.  So,
my question is 2 fold...
> Have you used Small Blue while users are hitting the system, especially
ITH files.
> Have you used Small Blue on trigger files with the triggers on.
> We're on 6.1.01.
> Thank you,
> Debra Glass
> Business Systems Analyst, EDI Support
> C B. Fleet Company, Inc.
> (434) 528-4000 x-8342
> glassd@xxxxxxxxxxx
> -- 
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
> Delivered-To: Clare.Holtham@xxxxxxxxxxxxxx

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.