ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> DBA administrator duties
http://www.istechforum.com/YaBB.pl?num=1136470346

Message started by Tag4k on 01/05/06 at 06:12:26

Title: DBA administrator duties
Post by Tag4k on 01/05/06 at 06:12:26

We have been running DBA for over 2 years. I would like to keep the system healthy by "cleanup" of some files by archiving and/or purging. In addition, I need to know both how and when to reindex files. Does anyone have some documentation from either DBA, Pervasive, IsTechSupport or a in-house written procedure to describe a recommended approach to keeping a system properly maintained? I realize that some of this depends on size of company and transaction volume. A general outline would certainly be a great starting point.

Title: Re: DBA administrator duties
Post by Lenette on 01/05/06 at 11:58:16

I would like something like this as well. We've got 3-1/2 years under our belt and I have only purged 2002 (since it was a partial year... with lots of errors).

Title: Re: DBA administrator duties
Post by CCKEITH on 01/12/06 at 09:01:25

I would really appreciate this information also.

Title: Re: DBA administrator duties
Post by deburr on 01/12/06 at 09:21:49

Count me in too. We have been using DBA for over 10 years. With an average 200 sales orders a week and almost as many inventory items, I think we could use a little dusting and cleaning too.

Title: Re: DBA administrator duties
Post by Lynn Pantic on 01/12/06 at 10:16:37

This will be a topic of discussion in Phoenix and there will be information posted on the web site after the forum for those of you unlucky enough to miss the fun in the sunny southwest.

Title: Re: DBA administrator duties
Post by ddlong on 03/22/06 at 07:18:19

Is there anything posted yet on this. Also how often do you expect to have training sessions?

Darla Long

Title: Re: DBA administrator duties
Post by Theran on 06/10/07 at 13:36:21

Was a suggested procedure ever posted on this subject? If so, where?

Title: Re: DBA administrator duties
Post by GasGiant on 06/11/07 at 04:52:21

This would be a great topic for the Wiki

Title: Re: DBA administrator duties
Post by Betty_Musser on 09/17/07 at 13:30:57

This would be most useful!!

Title: Re: DBA administrator duties
Post by CCKEITH on 11/05/07 at 10:09:55

I second that!

Title: Re: DBA administrator duties
Post by ZoomZoom on 11/12/07 at 07:25:47

this thread is closing in on two years old...has info been published?

Phil

Title: Re: DBA administrator duties
Post by RPCAdmin on 11/12/07 at 08:05:39

Not that I am aware of. It is very possible that every installation has some quirks or special considerations, but it seems it wouldn't be very hard to come up with a list of "You really should do this every x weeks" and " It would be nice if you do this every x weeks" list.

Title: Re: DBA administrator duties
Post by GasGiant on 11/12/07 at 09:18:10

The help file has a document named "Important Times" that should be a good start. The non-Accounting section helped me to develop my weekly, monthly, quarterly routines that I run here.