background image

Understanding GroupWise Databases

391

n

ov

do

cx (e

n)

  22
 Ju

n

e 20
09

Each library has its own subdirectory in the gwdms directory. In each library directory, the 

dm

xxnn01-FF

.db

 files contain information specific to that library, such as document properties and 

what users have rights to access the library.

For the location of library databases in the post office, see “

Post Office Directory

” in 

GroupWise 8 

Troubleshooting 3: Message Flow and Directory Structure

. For more post office information, see 

Section 35.3, “Information Stored in the Post Office,” on page 476

.

The actual documents in a library are not kept in the library databases. They are kept in a document 
storage area, which consists of a series of directories for storing documents. Documents are 
encrypted and stored in BLOBs (binary large objects) to make document management easier. A 
document, its versions, and related objects are stored together in the same BLOB.

A document storage area might be located in the post office itself, or in some other location where 
more storage space is available. If it is located in the post office, the document storage area can 
never be moved. Therefore, storing documents in the post office directory structure is not usually 
recommended. If it is stored outside the post office, a document storage area can be moved when 
additional disk space is required.

See 

Chapter 22, “Creating and Managing Libraries,” on page 313

 and 

Chapter 23, “Creating and 

Managing Documents,” on page 351

 for more information about Document Management Services.

25.6  Guardian Databases

The guardian database (

ngwguard.db

) serves as the master copy of the data dictionary information 

for the following subordinate databases in the post office:

Š

User databases (

user

xxx

.db

)

Š

Message databases (

msg

nnn

.db

)

Š

Prime user databases (

pu

xxxxx

.db

)

Š

Library databases (

dmsh.db

 and 

dm

xxnn01-FF

.db

)

The guardian database is vital to GroupWise functioning. Therefore, the POA has an automated 
back-up and roll-forward process to protect it. The POA keeps a known good copy of the guardian 
database called 

ngwguard.fbk

. Whenever it modifies the 

ngwguard.db

 file, the POA also records 

the transaction in the roll-forward transaction log called 

ngwguard.rfl

. If the POA detects damage 

to the 

ngwguard.db

 file on startup or during a write transaction, it goes back to the 

ngwguard.fbk

 

file (the “fall back” copy) and applies the transactions recorded in the 

ngwguard.rfl

 file to create a 

new, valid and up-to-date 

ngwguard.db

.

In addition to the POA back-up and roll-forward process, you should still back up the 

ngwguard.db,

 

ngwguard.fbk

, and 

ngwguard.rfl

 files regularly to protect against media failure. 

Without a valid ngwguard.db file, you cannot access your e-mail. With current 

ngwguard.fbk

 and 

ngwguard.rfl

 files, a valid 

ngwguard.db

 file can be rebuilt should the need arise.

The 

ngwguard.dc

 file is the structural template for building the guardian database and its 

subordinate databases. Also called a dictionary file, the 

ngwguard.dc

 file contains schema 

information, such as data types and record indexes. If this dictionary file is missing, no additional 
databases can be created in the post office.

Summary of Contents for GROUPWISE 8 - DATABASES

Page 1: ...e Databases on page 401 Chapter 28 Maintaining Library Databases and Documents on page 407 Chapter 29 Synchronizing Database Information on page 411 Chapter 30 Managing Database Disk Space on page 415...

Page 2: ...388 GroupWise 8 Administration Guide novdocx en 22 June 2009...

Page 3: ...primary domain is so crucial you should back it up regularly and keep it secure See Section 31 1 Backing Up a Domain on page 423 You can re create your entire GroupWise system from the primary domain...

Page 4: ...There can be as many as 255 message databases in the post office numbered from 0 to 254 Message databases are stored in the ofmsg directory in the post office Outgoing messages from local senders are...

Page 5: ...for more information about Document Management Services 25 6 Guardian Databases The guardian database ngwguard db serves as the master copy of the data dictionary information for the following subordi...

Page 6: ...392 GroupWise 8 Administration Guide novdocx en 22 June 2009...

Page 7: ...esolve most damage to GroupWise databases To further protect your GroupWise system against loss of domain and post office information see Chapter 31 Backing Up GroupWise Databases on page 423 Chapter...

Page 8: ...ve an administrative message informing you that an internal database error has occurred or if you detect database damage and don t want to take users out of GroupWise you can recover the database If n...

Page 9: ...se you are recovering Successful creating ddb NO YES creating ddb Read and copy records from recover ddb into creating ddb Skip invalid records Check the number of records Y in creating ddb Delete cre...

Page 10: ...ase being validated Click OK If recovery is successful the backup database is deleted and the new domain database is renamed to wpdomain db or the new post office database is renamed to wphost db If r...

Page 11: ...ent down unexpectedly The server where the database resides went down unexpectedly You receive an administrative message informing you that an internal database error has occurred or there is database...

Page 12: ...icient disk space for the copy of the database that is created during the rebuild process 4 In ConsoleOne browse to and select the Domain object or Post Office object where you want to rebuild the dat...

Page 13: ...ook the domain index is used and when you display the Address Book for a post office the post office index is used The GroupWise client uses the post office database to list users If you are in the Gr...

Page 14: ...2 June 2009 4 Select Rebuild Indexes for Listing then click Run 5 When prompted make sure the Path to Database is correct If an incorrect path is displayed browse to and select the path to the databas...

Page 15: ...pWise databases To further protect your GroupWise users against loss of mailbox contents see Chapter 31 Backing Up GroupWise Databases on page 423 and Chapter 32 Restoring GroupWise Databases from Bac...

Page 16: ...base Mailbox Library Maintenance verifies that any referenced messages actually exist in the message database In the message database it verifies that any attachments that are referenced actually exis...

Page 17: ...s on page 445 Logging on page 445 Results on page 446 Misc on page 446 Exclude on page 446 Selected options can be saved for repeated use See Saving Mailbox Library Maintenance Options on page 447 6 C...

Page 18: ...mation is lost such as the folder assignments You should never need to select this option for regular database maintenance It is designed for severe problems such as replacing a user database that has...

Page 19: ...base 4 Using the tabs at the bottom of the Mailbox Library Maintenance dialog box set the following options Databases on page 445 Logging on page 445 Results on page 446 Misc on page 446 Selected opti...

Page 20: ...406 GroupWise 8 Administration Guide novdocx en 22 June 2009...

Page 21: ...d A power outage can occur in the middle of a write to a database A hard drive can fail However the GroupWise tools for repairing damaged databases are very effective and should be able to resolve mos...

Page 22: ...ls Mailbox Library Maintenance to fix any problems it finds Otherwise Mailbox Library Maintenance just reports the problems 5 Using the tabs at the bottom of the Mailbox Library Maintenance dialog box...

Page 23: ...on If there are any missing links the missing documents or versions are created from the information contained in the existing version or element for which the link is missing For example if a version...

Page 24: ...m a different document storage area With this option all BLOBs in the library are checked to see which documents are in the area being deleted Reassign Orphaned Documents Documents can occasionally be...

Page 25: ...domain notifies the primary domain of the correct information then the primary domain broadcasts the correct information to all secondary domains Therefore the best place to perform synchronization i...

Page 26: ...ronized rebuilding the post office database wphost db can be preferable to synchronizing individual objects However this process requires exclusive access to the post office database See Section 26 3...

Page 27: ...ormation on page 408 29 4 Synchronizing a Secondary Domain If information for a particular secondary domain does not display the same throughout your GroupWise system you can synchronize the secondary...

Page 28: ...eplicated from the secondary domain database to the primary domain database To synchronize the primary domain from a secondary domain 1 You must have administrative rights to the primary domain direct...

Page 29: ...and Post Office Databases on page 419 Section 30 4 Reducing the Size of Libraries and Document Storage Areas on page 420 See also Section 12 3 Managing Disk Space Usage in the Post Office on page 190...

Page 30: ...OP and IMAP accounts Items Larger Than Shows how many items are larger than the size you specify Reduce Mailbox To Shows how many items need to be expired before the mailbox would be reduced to the si...

Page 31: ...s in the CC line then click Message if you want to include explanatory text 8 Click Run to gather the mailbox statistics and e mail the results to the specified users 30 2 Reducing the Size of User an...

Page 32: ...than the size you specify Trash Older Than Expires items in the Trash that are older than the number of days you specify Reduce Mailbox To Expires items until the mailbox is reduced to the size you s...

Page 33: ...and Post Office Databases As you add information to your system the domain databases wpdomain db and post office databases wphost db increase in size If you delete information the space created in the...

Page 34: ...See also Section 23 4 2 Backing Up and Restoring Archived Documents on page 376 30 4 1 Archiving and Deleting Documents Documents can be archived retained indefinitely or simply deleted The document t...

Page 35: ...the bottom of the Mailbox Library Maintenance dialog box set the following options Databases on page 445 Logging on page 445 Results on page 446 Misc on page 446 Selected options can be saved for rep...

Page 36: ...gs Older Than field The default is 60 days 5 Using the tabs at the bottom of the Mailbox Library Maintenance dialog box set the following options Databases on page 445 Logging on page 445 Results on p...

Page 37: ...post office level information is stored in many different databases The table below summarizes the databases and their locations NetWare Use a Target Service Agent TSAFSGW with a supported backup pro...

Page 38: ...iple libraries and each library can have multiple document storage areas so make sure you have identified all document storage areas in your library document backup procedure After you have initially...

Page 39: ...amaged or become inaccessible due to a hard disk failure See also Section 32 3 Restoring a Library on page 428 31 4 Backing Up Individual Databases If you need to back up individual databases separate...

Page 40: ...426 GroupWise 8 Administration Guide novdocx en 22 June 2009...

Page 41: ...in Section 31 1 Backing Up a Domain on page 423 to restore the domain database into the domain directory 3 Restart the MTA for the domain 4 To update the restored domain database with administrative...

Page 42: ...se Check GWCheck See Chapter 28 Maintaining Library Databases and Documents on page 407 and Section 34 1 GroupWise Check on page 439 If damage to the library is so severe that rebuilding databases is...

Page 43: ...Mailbox Items on page 431 NOTE Setting up a restore area enables users to restore deleted mailbox items messages appointments tasks and so on but not deleted contacts entries in Contacts folders and...

Page 44: ...451 5 For a restore area on Linux also specify the full path to the existing or new directory in the Linux Path field so that the Linux POA can locate the restore area ConsoleOne needs the UNC path t...

Page 45: ...s on page 431 as needed 32 5 2 Restoring a User s Mailbox Items After you have set up a restore area and placed a backup copy of a post office into it you can restore a user s mailbox items for the us...

Page 46: ...shed restoring items to your live mailbox click File Open Backup again to remove the check mark from the Open Backup option and return to your live mailbox 32 6 Recovering Deleted GroupWise Accounts I...

Page 47: ...GroupWise account into the GroupWise system However this does not restore ownership of resources nor does the account s mailbox contain any item at this point 9 If the restored user owned resources m...

Page 48: ...434 GroupWise 8 Administration Guide novdocx en 22 June 2009...

Page 49: ...p or purchase a third party non GroupWise application that performs this service Section 33 1 How Message Retention Works on page 435 Section 33 2 Acquiring a Message Retention Application on page 437...

Page 50: ...Application Does Different message retention applications might vary slightly in their approach to retaining messages This section provides a general approach to message retention To determine whethe...

Page 51: ...ssages 3 and 7 have dates that fall after the new time stamp May 8 2009 12 00 00 so they would not be retained until the next time the message retention application ran against the mailbox 33 2 Acquir...

Page 52: ...ns dialog box 2 Click Environment to display the Environment Options dialog box then click the Retention tab 3 Turn on the Enable Message Retention Service setting 4 If you want to lock the setting at...

Page 53: ...utility runs on Windows Linux and Macintosh You should match the platform of GWCheck to the platform where the databases are located Windows GWCheck processes databases on NetWare and Windows Linux G...

Page 54: ...97 Case 2 Missing Entry in the Guardian Database ngwguard db In this example a GWCheck is run either against all users on the post office or against one user ABC A user s FID is found and the user s d...

Page 55: ...ents Check until after a Structural Rebuild or Re create User Database has been run for that user For more information see Section 27 2 Performing a Structural Rebuild of a User Database on page 403 a...

Page 56: ...oupwise gwcheck directory For additional information about SetupIP and GWCheck see GWCheck on page 1131 If the client was installed using the GroupWise Windows client Setup program or the defaults are...

Page 57: ...on directory if it is has been updated or on the GroupWise 8 DVD or downloaded GroupWise 8 image if an updated software distribution directory is not available 2 Install GWCheck rpm i groupwise gwchec...

Page 58: ...upwise gwcheck bin directory 7 Change to the opt novell groupwise gwcheck bin directory 8 Enter gwcheckt options_filename to run text based GWCheck If you did not copy the options file to your home di...

Page 59: ...rol the checking process Databases on page 445 Logging on page 445 Results on page 446 Misc on page 446 Exclude on page 446 Databases To select the types of database to perform the Mailbox Library Mai...

Page 60: ...ual Users to send each user the results that pertain to him or her Click Message to include a message with the results file Misc If you need to run a Mailbox Library Maintenance check with special opt...

Page 61: ...ck opt 4 Click Save The GWCheck options file is created in XML format on all platforms Therefore you can create the GWCheck options file on any platform and use it on any platform interchangeably Retr...

Page 62: ...If you want to include the path to an archive database use the pa switch 3 To create an options file see Saving Mailbox Library Maintenance Options on page 447 34 1 8 GWCheck Startup Switches The fol...

Page 63: ...the default directory you must specify the full pathname For example to start GWCheck with saved settings you would use Linux GWCheck Windows GWCheck Syntax lang language_code lang language_code Lang...

Page 64: ...eck opt gwsystem post1 gwcheck opt Windows gwcheck opt gwcheck opt gwcheck opt gwsystem post1 gwcheck opt Linux GWCheck Windows GWCheck Syntax pa path_to_archive pa path_to_archive Linux gwcheck opt g...

Page 65: ...TSAFS and TSAFSGW on page 456 Section 34 2 6 TSAFSGW Startup Switches on page 459 34 2 1 System Requirements TSAFS and TSAFSGW are available on NetWare 6 5 and Novell Open Enterprise Server OES NetWa...

Page 66: ...SGW supports any feature that your backup software supports So if your backup software supports full incremental and differential backups or working set and copy jobs so does TSAFSGW If TSAFS is not a...

Page 67: ...e cannot be excluded but error messages generated by them can be ignored 34 2 4 NetWare Running TSAFS and TSAFSGW Running TSAFS on NetWare on page 453 Running TSAFSGW on NetWare on page 454 Running TS...

Page 68: ...AFSGW on NetWare on page 454 Running TSAFSGW on NetWare The tsafsgw nlm program file is automatically installed along with the GroupWise agents POA and MTA During agent installation a tsafsgw ncf file...

Page 69: ...ant to back up You can also add instances of the home switch to point to restore areas for post offices or to other temporary locations where you want to restore data By default TSAFSGW copies each da...

Page 70: ...ory to the server where you want to set up backups then use the following command to install it on SLES 9 rpm ivh novell sms 1 0 0 nn i586 rpm After the novell sms package is installed use the followi...

Page 71: ...gged in as root 2 Change to the directory where the SMS executables are located cd opt novell sms bin 3 Use the following command to specify GroupWise locations to back up Syntax smsconfig l tsafsgw h...

Page 72: ...want to back up You can also add instances of the home switch to point to restore areas for post offices or to other temporary locations where you want to restore data By default TSAFSGW places each...

Page 73: ...t server as described in Running TSAFS on Linux on page 456 The libtsafsgw so version_number file that is installed with the agents to opt novell groupwise agents lib must be copied to opt novell lib...

Page 74: ...ge from 1 to 9 The higher the number the more data is collected The log file is created in the directory specified by the logpath switch For example to specify the most verbose log level you would use...

Page 75: ...page 463 Section 34 3 5 GWTMSTMP Startup Switches on page 464 34 3 1 GWTMSTMP Functionality GWTMSTMP places date and time information on user databases userxxx db in order to support message backup re...

Page 76: ...ny messages with dates that are newer than the retention time stamp cannot be purged from the database You can also use GWTMSTMP to manually add a retention time stamp 34 3 2 Running GWTMSTMP on NetWa...

Page 77: ...a Post Office object then click Tools GroupWise Utilities Backup Restore Mailbox On the Backup tab select Backup then click Yes More specialized functionality is provided through additional GWTMSTMP s...

Page 78: ...the post office directory where the user databases to time stamp are located This switch is required backup restore and retention Specifies the time stamp on which to perform the operation If no time...

Page 79: ...set the backup time stamp you would use NetWare GWTMSTMP Linux GWTMSTMP Windows GWTMSTMP Syntax backup restore retention b backup r restore n retention backup restore retention NetWare gwtmstmp p j d...

Page 80: ...p set NetWare gwtmstmp p j dev set Linux gwtmstmp p gwsystem dev s Windows gwtmstmp p j dev set NetWare GWTMSTMP Linux GWTMSTMP Windows GWTMSTMP Syntax clear c clear clear NetWare gwtmstmp p j dev cle...

Page 81: ...hh mm am pm time hh mm am pm time hh mm am pm Example time 11 30pm t 2 00am time 2 00am time 6 15pm NetWare gwtmstmp p j dev restore time 4 45pm Linux gwtmstmp p gwsystem dev r t 4 45pm Windows gwtms...

Page 82: ...ctory in wpgate Only gateway files are copied from each gateway directory Queue directories of gateway directories are not copied For example under gwia and webac70a gateway files are copied but no ga...

Page 83: ...ware distribution directory if you have created one or on the GroupWise 8 DVD or downloaded GroupWise 8 image 2 Install DBCopy rpm i groupwise dbcopy version mmdd i386 rpm 3 Change to the opt novell g...

Page 84: ...tension allows for multiple log files created on the same day The log file is created at the root of the destination directory Include the v switch in the dbcopy command to enable verbose logging for...

Page 85: ...of the previous copy of the data This causes DBCopy to copy only files that have been modified since the previous copy like an incremental backup There is no default date you must specify a date k mi...

Page 86: ...is the second pass of the migration process t Specifies the number of threads that you want DBCopy to start for copying data The default number of threads is 5 u migration only Specifies the TCP port...

Reviews: