What regular database maintenance is necessary on a GroupWise System?

  • 10008201
  • 1.0.432769.1849798
  • 29-Oct-1998
  • 16-Mar-2005

Archived Content: This information is no longer maintained and is provided 'as is' for your convenience.


What regular database maintenance is necessary on a GroupWise System?


Novell GroupWise 4.1

Novell GroupWise 5.0

Novell GroupWise 5.1

Novell GroupWise 5.2

Novell GroupWise 5.5

Novell GroupWise 6

Novell GroupWise 6.5

Novell NetWare Administrator

GroupWise Post Office Agent GWCheck Process

GroupWise Stand Alone GWCHK32.EXE


Novell recommends to setup Schedule Events for the POA from ConsoleOne or NWADMN32 (depending on the GroupWise database versions).

The type of events to setup will be Structure and Contents checks on the message store of your post offices.

If the Access Mode to the post office is Client/Server (TCPIP connection between the GroupWise client and POA) then a Weekly Structure and Index check should be sufficient and a monthly Contents check. However, if your are seeing weekly/daily corruption of post office databases then you should change the Structure checks to run daily (don't check Index for daily event because it may not finish if you have a large post office).

If the Access Mode is Direct Mode (a UNC or drive letter connection to the post office directory) run a Structure check event daily and a Structure and Index Check weekly. A Contents check should be done weekly as well. Post office databases are more susceptible to database corruption when the GroupWise client accesses the post office in Direct Mode.

Implement an Expire/Reduce Event:
To keep your message store from getting out of control a business should implement some email retention policy (the amount of time users can keep/retain messages, appointments, notes, and tasks). This is up to the business to determine. Novell does not make any recommendations due to the varying needs of customers. The size and amount of messages in a post office can lead to performance issues. The larger the databases the more time it takes to complete database maintenance and backups. The database maintenance or backups may not complete by the time your users come to work and impact their use of GroupWise.


Top Down rebuild with NetWare Administrator (or your current version of NWAdmin for GroupWise)

This is highly recommended whenever a server abends containing the GroupWise data store which most likely was compromised from the abend on your system. Also recommended for periodical maintenance.

NOTE: Before proceeding make sure you have a current backup of the entire GroupWise system.

1) Rebuild the Primary Domain and any Secondary Domains
Note: All GroupWise Agents or Gateways accessing the domain database must be shut down

        a)        Highlight the Domain object in the NDS View
        b)        Select Tools | GroupWise Utilities | System Maintenance
        c)        Select "Rebuild Database" and then RUN

2) Rename any/all WPHOST.DB files in the Post Office directories
Note: All users must be out and no processes (including all GroupWise Agents) accessing GroupWise can be running)

3) Rebuild all Post Offices in each domain

        a)        Highlight the Post Office object in the NDS View
        b)        Select Tools | GroupWise Utilities | System Maintenance
        c)        Select "Rebuild Database" and then RUN.

** At this point you can start the GroupWise Agents and allow users to login to GroupWise

4) To complete the top down rebuild using NetWare Administrator:

        a)        Select the post office in the NDS View
        b)        Select Tools | GroupWise Utilities | Mailbox/Library Maintenance
        c)        Select Structural Rebuild from the Action pull down, then select Run

Steps to complete the top down rebuild using GroupWise Stand-alone GWCheck (GWCHK32.EXE):

        a)        Select the path to the post office and type in the name of that same post office
        b)        Select "User/Resource" and type the word "All" in the box below
        c)        Select "Structural Rebuild" from the Action pull down, then select Run
        d)        When this completes, go back to the Action pull down and select "Analyze and Fix"
        e)        Unselect "Structure", select only "Contents" and "Fix Problems", then select Run


If you want or need to recover some disk space:

        a)        Select Expire and Reduce Messages
        b)        Since "Reduce Only" is selected by default, select Run

This recovers disk space left in the databases (User.db & Msg.db) when message items are deleted by the users

The expire option will allow you to expire message items older than the date you specify. Use caution when running this option, as once message items are expired they CANNOT be undeleted. They can only be recovered by restoring system backups.

To do a top down rebuild of a GroupWise 4.1a system see Top Down Rebuild a GroupWise 4.1a system [no longer available].