RE: Resets, Cleanups on 4.05cd

I treated the 'clean-up' thing too lightly in my earlier post, but using Al
Mac's pattern, I do roughly the same thing.  I DO have some nightly
auto-runs that clean up the HINUS flag, 'balance' the standard cost fields,
move closed shop orders to a separate file, etc.....

Al Mac's DSPFD *ALL command (see his earlier post) brought to light (out of
the dank, dirty corners of my file library) new and exciting ways to get
back some storage.  I knew the major files that need reorg's or member
deletions, but I did find some new ones, including HPW (72 recs, 52,000!
deleted), BBI, BIP and others.  Thank you, Al :)





-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx]On
Behalf Of Al Mac
Sent: Friday, March 07, 2003 1:11 AM
To: SSA's BPCS ERP System
Subject: Re: Resets, Cleanups on 4.05cd


On a weekly basis, when no other user on BPCS/400, except me on another
session WRKSPLF output review, I run the following sequence:

ORDBAD ... a CL program to run a string of RUNQRY reports listing various
things that can go wrong with our orders, such as IN USE flag locked up.

SFC990C enter enter
ORD990C enter enter (this one often has ORD991 list of deleted customer
orders that some co-workers like to check)
SYS990C enter enter ***
INV971C enter enter (this takes about 3 minutes) ***
INV972C enter enter (ditto) ***
ACR970C  enter enter
ACR972C  enter enter
MRP990C  enter enter

Those marked *** at the end are what we run to fix negatives into MRP or
on-hand not add up
Any time grievances about numbers on INV300 or other screens not adding up
right, those three become high priority to do just as soon as we can get
dedicated BPCS.

I may post other scenarios later.

>I am BPCS/400 Computer Janitor at a 405 CD installation.
>
>I run about 1/3 of them on a weekly basis, when no one else on the system.
>I ran SYS120 last nite, when no one else on the system, to recover 36 K
>disk space from deleted records, since I ran it a week earlier.
>There is a cluster I run any time the on-hand allocations get out of sync
>to a significant degree.
>There are some that we do immediately after INV900 in the month end check
>list, only in a month without a physical inventory.
>I will check the precise list when I at work (I do my e-mail from home).
>
>However, it is rather critical that we handshake on what applications are
>operational at our companies.  Some of these options might be inadvisable
>or irrelevant for mismatch of modules.
>
>We have copied several to our own menus since it is critical what sequence
>they run in.
>Menu SYSC is for SYS stuff run on a regular basis.
>Menu CLOS is for EOM (Close each month)
>Menu FXS is for Fixing things where we give several system helpers access
>to some tasks but want to keep them off the SYS menus.
>
>>Hi Everyone,
>>
>>I was wondering what anyone would recommend for file resets and cleanups.
>>Specifically referring to the SSAZ01 menu of "File resets and Clean Up.
>>
>>The only ones I run on a regular (monthly) basis are:
>>
>>INV970 - Lot Loc. Cont Recs w/o Inv.
>>INV972 - Reset Inventory balance in IIM from ILI
>>
>>...and I run them in that order.
>>
>>I've not yet been frustrated enough to run SYS122. (Clear BPCS Files)
<grin>
>>
>>Paul LaFlamme
>>Manager of MIS
>>Kennedy Die Castings, Inc.
>>
>>Before posting, please take a moment to review the archives
>>at http://archive.midrange.com/bpcs-l.
>
>-
>Al Macintyre

-
Al Macintyre
BPCS/400 Computer Janitor at http://www.globalwiretechnologies.com/
Find BPCS Documentation Suppliers
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html

_______________________________________________
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.