Removing messages from the message and user database with GWCheck.

(Last modified: 01Nov2004)

This document (10052747) is provided subject to the disclaimer at the end of this document.

goal

Using SUBJECTLIST or SUBJECTPURGE with standalone GWCHECK.

fact

Novell GroupWise 6.5

Novell GroupWise 6.0

Novell GroupWise 5.5.4

Novell GroupWise 5.5.4.1

Novell GroupWise GWCheck

SUBJECTPURGE

SUBJECTLIST

symptom

Message or user database is very large

Groupwise Message Databases are very large

fix

GroupWise 6 and Groupwise 6.5 Users:

1. Please use the latest version of GWCheck included in the latest support pack. This ensures that the latest fixes are being utilized to resolve database issues.

2. Launch GWCheck.

3. Fill in the Path to the Post Office.

4. Fill in the Post Office name as it appears in ConsoleOne.

5. Select Object Type and type in the ballooned db name in question. For Example, if msg2.db was the database in question: msg2.db

     Under the drop-down Action menu choose Analyze / Fix Databases, and check only "Contents" and "Fix problems."

6. At the bottom right of the GWCheck Screen select the Misc. tab.

7. In the Support Options: type in SUBJECTLIST (all caps). This will create a file called SUBDUMP in the same folder that you are running GWCheck from.

8. After the GWCheck finishes, review the subdump file for suspected repeating messages.

9. Re-run GWCheck with the same options as listed and remove SUBJECTLIST from Misc Support Options and type SUBJECTPURGE = subject line of repeating message.

10. Finally re-run GWCheck and select as the Action Expire/Reduce and select Reduce Only to shrink the database size.

*****************************************
In situations where a user has received the same message thousands of times you can do the following.
1. Run Analyze/Fix Database on Contents and Fix problems against the user and message database. (This will clean all of the records out of the database).

Note: Under Object type, choose User/Resource, and enter the USERID of the user with the problem.

In some cases where the user or message database is very large the above options can take a day or more to complete.

GroupWise version 5.x

Run GWCHECK with the following steps:

1. Create a text file named GWCHECK.CFG file in the directory where GWCheck is run from.

2. In the GWCHECK.CFG file put SUBJECTPURGE on the first line. On the second line, put whatever the subject of the problem message is. Press enter after the subject line. Note that the GWCHECK job will only extract the first 27 characters of the subject. Spaces are also considered characters.

3. Run Analyze/Fix Database on Contents and Fix problems against the message database. (This will clean all of the records out of the database). Note: Under Object type, choose User/Resource, and enter the message database (ie MSG12.DB). To determine what message database the message is contained in, right click the message in the GroupWise Client, and choose Properties. The number between the colons, at the top of the page, represents the message database number.

4. Delete GWCHECK.CFG (this should get automatically deleted by GWCHECK).

5 Run a Reduce on the database that is so large. This will get the space back.

NOTE: Before running a SUBJECTPURGE, you may want to backup the message database. Also, you may want to run a SUBJECTLIST prior to the SUBJECTPURGE, to verify the subjects in the database before deleting. To run SUBJECTLIST, do the following:
1. Create a text file named GWCHECK.CFG file in the directory where GWCheck is run from.
2. Put SUBJECTLIST on the first line of the GWCHECK.CFG file (Do not put anything else in the file).
3. Run Analyze/Fix Database on Contents and Fix problems against the message database. This will create a file named SUBDUMP. In this file you will find every subject that is in that message database.
4. Delete GWCHECK.CFG (this should get automatically deleted by GWCHECK).

NOTE:
- For GroupWise 5.5, SUBJECTPURGE is only available in GWCHECK 5.5.4 (GW 5.5 SP4) and later.
- For GroupWise 5.5 Enhancement Pack, SUBJECTPURGE is only available in GWCHECK 5.5.4.1 (GW 5.5 EP SP2) and later.
- For GroupWise 6.0 or 6.5, SUBJECTPURGE is only available in GWCHECK 6.0.1 (GW 6.0 SP1) and later or 6.5. (See separate instructions below.)

*****************************************
In situations where a user has received (for whatever reason) the same message thousands of times you can do the following.

Run GWCHECK with the following steps:

1. Create a text file named GWCHECK.CFG file in the directory where GWCheck is run from.

2. In the GWCHECK.CFG file put SUBJECTPURGE on the first line. On the second line, put whatever the subject of the problem message is. Press enter after the subject line.

3. Run Analyze/Fix Database on Contents and Fix problems against the user and message database. MAKE SURE YOU HAVE BOTH USER AND MESSAGE SELECTED. You can cause problems with remote/caching modes and archives if you do not select both user and message. Note: Under Object type, choose User/Resource, and enter the USERID of the user with the problem.

4. Run a GWCHECK Reduce on the user or message database that is large. This will get the space back.

5. Delete GWCHECK.CFG (this should get automatically deleted by GWCHECK).

document

Document Title:	Removing messages from the message and user database with GWCheck.
Document ID:	10052747
Solution ID:	NOVL9882
Creation Date:	05May2000
Modified Date:	01Nov2004
Novell Product Class:	Groupware NetWare

disclaimer

The Origin of this information may be internal or external to Novell. Novell makes all reasonable efforts to verify this information. However, the information provided in this document is for your information only. Novell makes no explicit or implied claims to the validity of this information.
Any trademarks referenced in this document are the property of their respective owners. Consult your product manuals for complete trademark information.