Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Mapper database statistics

Mapper database statistics

Mapper database statistics

First off, let me say that I don't know much about Mapper or Mapper programming. We've inherited a problem with the database. The stats say that it is at 93%. I was told by the "Mapper Admin" that when the database reaches 95% we should start to panic. Unfortunately, the "Mapper Admin" doesn't know much about Mapper either. I've increased the amount of drawers per cabinet in several of the larger cabinets to no avail. There is plenty of disk space, but I can't find a solution to this problem. Here is a link to the "system information" http://img01.picoodle.com/img/img01/8/4/23/dmajagah/f_SystemInfom_f16973f.jpg

Any and all input on this would be greatly appreciated.

RE: Mapper database statistics

I assume this is MAPPER on a Windows machine?

What you need to do is to purge the database- do a full backup and verify it.  This is best done from the mapadmin interface.

Note how many blocks your files are- you'll want to increase the size of the master file (or add another file) by at least 50%.

Then, again in the mapadmin interface,

- connect to the site, select "properties".
- in the "initialisation" panel, set the "initialize database on next start" checkbox, and put the path of the purgefile in there that you created in the first step.

-stop the site.

You then have two options:

You can (1) delete the master file, and re-create it larger, or you can (2) add an additional file.  In all honesty, it makes little difference.

Then right-click on the stopped site.

(1) Click on the master file and select "delete".

Then click on the "database files" and add a file.
Call it MSTR.  Put in the number of blocks (as before +50%).

Wait while it initialises.

(2) Click on "database files" and add another file. Call it anything you want, or accept the default.  Make it at least 50% the size of the master file.

Wait while it initialises.

(1)(2) - start the site.

It will initialise the database from the saved purge, but with new file sizes.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close