ISTech Support Forum

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

Message started by aricon on 06/09/05 at 07:28:47

Title: Re: Maintenance Tasks
Post by aricon on 06/09/05 at 07:28:47

Re-indexing the files is about the only DB maintenance that you can really do. And no you cannot use SQL Server. DBA is NOT a relational DB, it is transactional. And nothing you could do with SQL would have any positive effect upon the DBA data files.

Title: Re: Maintenance Tasks
Post by emiller77 on 06/13/05 at 22:36:57

I guess I do not understand SQL server is a transactional database also along with being a relational database. Please explain your answer. I am a little rusty with SQL server I haven't really used it in about a year.

Title: Re: Maintenance Tasks
Post by aricon on 06/14/05 at 05:12:32

All relational DB's have a transactional component to the functionality including Pervasive. The design of DBA however uses data FILES not data tables within a single "file" the way that a relational DB does. And DBA only uses the transactional parts of the Pervasive engine.

Basically I cannot see any purpose whatsoever to uses SQL Server to try to do anything with the DBA data files.

Title: Re: Maintenance Tasks
Post by kevind on 06/14/05 at 06:20:50

The only additional activity I can think of is to purge old, un-needed records (closed SO, Closed PO's, Closed WO's) and consolidate transaction files (inventory transaction, general ledger transacton) before re-indexing.

Re-indexing not only rebuilds the internal table indexes, but, in the process, it recovers drive space from purged records. The data files become smaller to the operating system.

As Loren pointed out, DBA uses only the transactional component of pervasive. Because of this, the programs are written to sequentially step through each individual record of a table to process the data in that table. Sometimes it steps through by following an index so that the records of interest get read right away (say, by date). Other times, every record of the data file is read and compared with the selection criteria. With Fewer records to read, programs that step through every record will take less time to run.

Title: Re: Maintenance Tasks
Post by klconard on 06/15/05 at 05:11:00

What files need to be re-indexed when you purge old PO's & SO's. I've been archiving my WO's and Lynn gave me the list of those files.

Title: Re: Maintenance Tasks
Post by aricon on 06/15/05 at 09:10:48

PO's would be BKAPHPO and BKAPHPOL and SO's would be BKARHINV and BKARHIVL.

Title: Re: Maintenance Tasks
Post by Lynn Pantic on 06/15/05 at 11:32:31

Actually, no. BKARHINV and BKARHIVL are posted invoices. If you purge closed Sales Orders, the files are BKARINV and BKARINVL. Also BKARDESC if you use Notes.

Title: Re: Maintenance Tasks
Post by aricon on 06/15/05 at 11:53:01

Ooops, my bad... :o

Title: Re: Maintenance Tasks
Post by Lenette on 06/23/05 at 07:12:35

Is there a place where all these files to be reindexed can be found. I recently purges all 2002 SO, WO & PO.

I have reindexed the following:
BKAPHPO
BKAPHPOL
BKARDESC
BKARHINV
BKARHIVL
BKARINV
BKARINVL

Did I miss any??
Lenette

Title: Re: Maintenance Tasks
Post by aricon on 06/27/05 at 06:27:18

Yes, you missed the work order files....

Title: Re: Maintenance Tasks
Post by Lenette on 06/27/05 at 06:55:57

Okay... Lorne....

Maybe I should have re-worded my questions...
What files did I miss??

Lenette ;D

Title: Re: Maintenance Tasks
Post by aricon on 06/27/05 at 12:55:30

Look for all the files that start with WO (ie. WOROUT, WORKORD, etc.)

Title: Re: Maintenance Tasks
Post by Lynn Pantic on 06/27/05 at 13:02:45

Plus (in the infinite wisdom of whoever first set up the Work Order system) OUTPROC.

Also the Data Collection labor files if you use DC or WO-M to enter labor - BKDCLAB, BKDCPLAB and BKDCTLAB.

Title: Re: Maintenance Tasks
Post by Lenette on 06/28/05 at 09:41:41

THANKS FOR ALL THE INFO.

Maybe auto-reindexing could be added to your "list".

:) lenette

Title: Re: Maintenance Tasks
Post by Lynn Pantic on 06/28/05 at 10:16:44

Already have a multi-file reindexing add-on that comes with preset lists. $49.95