Rebuild Sections

Sheila Foss · October 08, 2009, 01:50:19 PM

Hey, this is a real legit help question.

How long does Rebuild Sections take? We never ran it before, but this morning, no data carries over into summary, certs, binders, Real Time, etc.

So, now we are running it.....................how many days will it take?

Sheila Foss · October 08, 2009, 02:01:45 PM

oops, there you go, need to be under help, NOT forum help

Jim Jensen · October 08, 2009, 02:22:21 PM

and this forum has no mod to move it...

I can't speak to yours, since I can't see how many users you have (and thus the size of DBs), but ours doesn't take terribly long, maybe 10 minutes. However if you've never run it and your DBs are large, it may take a long time. I have it run once a week or more in night utilities, usually every Saturday morning.

Sheila Foss · October 08, 2009, 03:22:55 PM

Well, it's been running since about 9-9:30 this morning. I know we have data since 1995 in it, then added that other agency data by conversion in July, so I don't know how large they would be now.

I do know we have had to do a lot of renaming. Who looks for customers by the first name? or the first name of the person in the ATT: line? Plus, there was no break out of personal/commercial lines client codes. It was entered by how the person felt like putting it in. A BOP is on the same policy list as the personal auto and homeowner. $:-\$

I would think the basic premise is to file as if you were looking it up in a phone book.

A lot of moving the policies, they had the auto, we write the home, so have been doing a lot of merging. Well, I will probably have to leave it running through the night.

Sheila Foss · October 09, 2009, 08:28:00 AM

It's still running. I just wish it would show what customer account it was on, hopefully it's near the end of the alphabet.

We have had a lot of accounts to move to history, then delete from the current policy list, plus moving of policies, so this was bound to happen.

Jim Jensen · October 09, 2009, 09:33:28 AM

Once its done, you might look to run night utilities with it once a week. Surely it will run faster and you could set it for a weekend, like run on Sunday.

Charlie Charbonneau · October 09, 2009, 09:44:24 AM

like I tell my users with defrag... it's like a kids room... the more often it's "cleaned" the faster it will be to clean it...

Sheila Foss · October 09, 2009, 09:56:20 AM

On Friday nights we do a pack, will setting it up to run at that time be done before or after reindexing?

Bob · October 09, 2009, 11:53:44 AM

Defrag??? Is this a Halo trick?

Bloody Jack Kidd · October 09, 2009, 12:06:29 PM

Quote from: Bob Connor on October 09, 2009, 11:53:44 AM

Defrag??? Is this a Halo trick?

no... that's teabagging

Charlie Charbonneau · October 09, 2009, 12:12:44 PM

Lmao!! That's usually done AFTER the fragging... Not that I would know anything about that...

Jim Jensen · October 09, 2009, 12:56:48 PM

Quote from: Sheila Foss on October 09, 2009, 09:56:20 AM
On Friday nights we do a pack, will setting it up to run at that time be done before or after reindexing?

I don't know for certain, but I believe the rebuild sections will run after the reindex/pack. I also run validate balances on the weekend utilities.

Sheila Foss · October 09, 2009, 01:28:36 PM

I remember we used to rebuild, but we had some problem, and support advised discontinuing it. Maybe now we are on v9.4, we can safely do it on a regular basis.

Of course, we don't usually have such heavy database changes. Having three agencies moved in here since last December, is really straining our office.