ca.portal.admin

GARBAGE in E-mail's

Discussion created by ca.portal.admin on Aug 8, 2007
Hello Bob:

Those last two E-mail's from Linda Campbell was totally garbage and I
could not read any of them? Interesting enough when someone replied with
her original text I could read it just fine? I get some E-mail from
different people on the list that is garbage, can you fix this?

The last time this happened someone told me to get my E-mail from IDMS-L
and not IDMSVENDOR-L?

I don't know if that's true or not or even how to change it, can you do
this for me?

Bill Allen





************************************** Get a sneak peek of the all-new
AOL at http://discover.aol.com/memed/aolcom30tour
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Avoiding long outages with large databases
"We dealt with a similar situation by creating an archival/retrieval process. In our case we had 15 years worth of narrative data that was a ""requirement"" to keep. So we archived all but the most recent three years of information and implemented a monthly process to archive the oldest data so the area holds a rolling three years of information. So basically the area holds the same number of records from month to month. We also created a retrieval mechanism for the users to request that the archived narrative information for one case be restored overnight. (there are approximately 20 of these request per day) The retrieved information is stored back to a separate database area for a two week period and then is removed.


Prior to implementing this process we had to expand the area ever 3 to 4 months since implementation we have run for 2 years without needing an expansion. As an added benefit the area size was drastically reduced since we removed 12 years worth of data so maintenance on the area is now much easier and less time consuming.

Scott Van Der Heyden
State of Iowa
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Avoiding long outages with large databases
"As Linda has mentioned splitting record types out into their own area
mainly helps your maintenance work. We have successfully taken record
types out of a very large area to put them into their own areas. Then
the area expand downtime becomes a little less and you are not expanding
because of one of many record types has rapid expansion.

If some of your data is of an historic nature then it could belong to a
different record type and also be in its own area. This way your current
data is always available in a smaller more manageable area.

Remember that if you create more records and/or areas you will need to
change program code to reflect the change.

Chris Wood
Alberta Department of Energy
CANADA

Outcomes