GIS/SI: the DB growth

Last week another client told me that their Sterling B2B Integrator’s DB had been growing uncontrollably. I checked the DataBase Usage section and found that there are too many records to be purged – it meant that something was wrong with the Purge service. When it comes to the purge service, there are not too many options – I immediately checked the Locks and found that there had been 2 locks for about a month. Something went wrong, the Purge service setup these locks but was not able to release them. We unchecked them and 24 hours later it got back to the normal routine. Now it’s time to rebuild the indexes and shrink tables…

Gennady Kim

Advertisements

One thought on “GIS/SI: the DB growth

  1. Pingback: GIS/SI: the DB growth, part 2 | EDI shortcuts

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s