DKNFs even *with* -p [long; lots o' code]

[Jay R. Ashworth]

On Tue, Jun 19, 2007 at 03:36:41PM -0400, Bruce Easton wrote:
> Jay R. Ashworth wrote Monday, June 18, 2007 11:26 AM:
[ 215 lines of unnecessary quoting elided ]
> 
> Jay - how is the "push" process called?

>From 'pullinv(1l)':

============================================================================
rm -f /appl/acsi/filepro/InvImp/lockf*

cd /home/samba/dbexport

# fix case for foxcopy
echo Y | foxcopy inventory InvImp
sleep 2

# archive
mv inventory.dbf old/inventory.dbf.`date +%Y%m%d`

# go to fp file, move data to qualifier, and touch to keep filepro
# happy
cd /appl/acsi/filepro/InvImp
mv key keyybc
mv data dataybc
touch key data

# zero bulk item quantities
dreport sviinvtr -f zerobulk -s bulkitem -h "Zeroing quantities on bulk
items"

# cleanup indexes and push to sviinvtr/sviinvfr
dxmaint InvImp -ra -e -m ybc
dreport InvImp -f push -a -m ybc -h "Pushing inventory records"
============================================================================

On Tue, Jun 19, 2007 at 03:55:54PM -0400, Bruce Easton wrote:
> Bruce Easton wrote Tuesday, June 19, 2007 3:37 PM:
> > Jay R. Ashworth wrote Monday, June 18, 2007 11:26 AM:
[ 220 lines of unnecessary quoting elided ]
>
> Also - is prc.whack identicall for both files sviinvtr and sviinvfr?

The prc tables are identical; the selection sets differ only in the
applicable field numbers.


On Tue, Jun 19, 2007 at 04:14:24PM -0400, Bruce Easton wrote:
> Bruce Easton wrote Tuesday, June 19, 2007 3:56 PM:
> > Bruce Easton wrote Tuesday, June 19, 2007 3:37 PM:
> > > Jay R. Ashworth wrote Monday, June 18, 2007 11:26 AM:
[ 229 lines of unnecessary quoting elided ]
>
> Jay - what do you mean by:
> 
> > > > I'm in a loop, working on the second table to get it exactly right, so
> > > > I have to run the first one multiple times as well.
> ?

I mean that I won't normally be running prc.whack in production,
because prc.push is equipped to deal with the idea that the item may
already exist -- we're shadowing an already installed system, and he
gives us a full inventory dump daily.

But since prc.whack and prc.push are the only things writing records in
those files at them moment, it seemed pertinent to mention it.

> Have you removed and rebuilt indexes from scratch and rebuilt freechain?

That I haven't, no.  I guess that's next.

See other thread.

Cheers,
-- jra
-- 
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274