ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> File Maintenance Functions
http://www.istechforum.com/YaBB.pl?num=1154438261

Message started by julian on 08/01/06 at 05:17:41

Title: File Maintenance Functions
Post by julian on 08/01/06 at 05:17:41

I have a similar problem with two of the file maintenance functions I ran.

1. I ran SM-J-D Consolidate Inventory Transactions. We had transactions dating back to 2003 and I consolidated up to 1/1/2006. My problem is that after doing that, my INVTXN_B file increased by a bit more than 25%. :o

2. I also ran SM-J-J Purge Closed Sales Orders. It also increased both BKARINV, and BKARINVL.

I've started to look through INVTXN to see whats in there, but there are only a few records dating back to before 2006 still in there. I may run a full comparison of the old file and the new one to see exactly what's different.

Anybody have any ideas? Anybody run these programs succesfully?

I'm running 2004.1 right now. I plan to be running EVO in a couple weeks; will that help this problem?

Thanks!!

Julian

Title: Re: File Maintenance Functions
Post by julian on 08/01/06 at 08:51:51

I've run some queries on INVTXN and here's the data.

before consolidate inventory transactions:
file size: 156MB

Code:

SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE <= '2006-01-01'

result: 204733

Code:

SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE >= '2006-01-01'

result: 78883

after consolidate inventory transactions:
file size: 216MB

Code:

SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE <= '2006-01-01'

result: 5360

Code:

SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE >= '2006-01-01'

result: 78883 (same)

It does speed up the time it takes to run the first query, and that's all I'm really concerned with. It sure is strange however... ???

Title: Re: File Maintenance Functions
Post by dameng on 08/08/06 at 14:26:18

you need to use the Pervasive Rebuild utility, and Rebuild the INVTXN file, which will adjust the physical size due to the record consoldation.

don't forget to make a backup, prior to using the Rebuild utility.

Title: Re: File Maintenance Functions
Post by julian on 08/09/06 at 07:27:08

Nice. That did the trick... Thanks Dave!

;D