Novell GROUPWISE 7 - DATABASES, Manual

Page 1: ...age Databases on page 385 Chapter 28 Maintaining Library Databases and Documents on page 391 Chapter 29 Synchronizing Database Information on page 395 Chapter 30 Managing Database Disk Space on page 3...

Page 2: ...372 GroupWise 7 Administration Guide novdocx en 11 December 2007...

Page 3: ...he 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 407 You can re create your entire GroupWise system from the primary doma...

Page 4: ...se 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 a...

Page 5: ...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 subor...

Page 6: ...376 GroupWise 7 Administration Guide novdocx en 11 December 2007...

Page 7: ...olve 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 407 and Chapte...

Page 8: ...eive 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...

Page 9: ...ds Check the number of records Y in creating ddb Delete creating ddb creating ddb wpdomain db Try rebuilding wpdomain db Notify the administrator that wpdomain db could not be recovered Rename recover...

Page 10: ...ant to recover the database 4 Click Tools GroupWise Utilities System Maintenance 5 Click Recover Database Run 6 When prompted make sure the Path to Database is correct If an incorrect path is displaye...

Page 11: ...g conditions Objects are not being replicated between domains The agent that writes to the database went down unexpectedly The server where the database resides went down unexpectedly You receive an a...

Page 12: ...fficient 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 d...

Page 13: ...Book 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 G...

Page 14: ...December 2007 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 datab...

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

Page 16: ...box 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 exist in the...

Page 17: ...to perform the Analyze Fix operation Analyze Fix can also be run using the standalone GroupWise Check program See Section 34 1 GroupWise Check on page 423 It can also be scheduled to run on a regular...

Page 18: ...ormation 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 h...

Page 19: ...tabase 4 Using the tabs at the bottom of the Mailbox Library Maintenance dialog box set the following options Databases on page 429 Logging on page 429 Results on page 430 Misc on page 430 Selected op...

Page 20: ...390 GroupWise 7 Administration Guide novdocx en 11 December 2007...

Page 21: ...ted 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 m...

Page 22: ...Databases on page 429 Logging on page 429 Results on page 430 Misc on page 430 Selected options can be saved for repeated use See Saving Mailbox Library Maintenance Options on page 431 6 Click Run to...

Page 23: ...xisting version or element for which the link is missing For example if a version is found that shows no link to a document a document is created from the information contained in the version and the...

Page 24: ...d to see which documents are in the area being deleted Reassign Orphaned Documents Documents can occasionally become orphaned unattached to a user For example this can happen when a user leaves your o...

Page 25: ...perform synchronization from the owning domain the owning domain notifies the primary domain of the correct information then the primary domain broadcasts the correct information to all secondary dom...

Page 26: ...checking the synchronized objects in Address Books and several post offices in your GroupWise system If there are indications that a large number of User or Resource objects need to be synchronized r...

Page 27: ...ccessful by checking the library information when connected to different domains in your GroupWise system See also Section 28 2 Analyzing and Fixing Library and Document Information on page 392 29 4 S...

Page 28: ...sers added to the secondary domain are replicated from the secondary domain database to the primary domain database To synchronize the primary domain from a secondary domain 1 You must have administra...

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

Page 30: ...items need to be expired before the mailbox would be reduced to the size you specify Older larger items are expired before newer smaller items Reduce Mailbox to Limited Size Shows how many items need...

Page 31: ...Click Run to gather the mailbox statistics and e mail the results to the specified users 30 2 Reducing the Size of User and Message Databases When users archive and delete messages in their mailboxes...

Page 32: ...arger Than Expires items that are larger 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...

Page 33: ...nagement assistance see Section 12 3 Managing Disk Space Usage in the Post Office on page 182 30 3 Reclaiming Disk Space in Domain and Post Office Databases As you add information to your system the d...

Page 34: ...e best use of available disk space Section 30 4 1 Archiving and Deleting Documents on page 404 Section 30 4 2 Deleting Activity Logs on page 405 See also Section 23 4 2 Backing Up and Restoring Archiv...

Page 35: ...nu select Archive Delete Documents 4 Using the tabs at the bottom of the Mailbox Library Maintenance dialog box set the following options Databases on page 429 Logging on page 429 Results on page 430...

Page 36: ...Logs 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 429 Logging on page 429 Results on...

Page 37: ...cal 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 GWTSA on NetWare 5 1 or TSAFSGW...

Page 38: ...ltiple 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 initiall...

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

Page 40: ...410 GroupWise 7 Administration Guide novdocx en 11 December 2007...

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

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

Page 43: ...2 Restoring a User s Mailbox Items on page 415 Section 32 5 3 Letting Client Users Restore Their Own Mailbox Items on page 416 32 5 1 Setting Up a Restore Area A restore area is only as useful as the...

Page 44: ...n see Section 34 2 Target Service Agents on page 434 or For a post office on Linux specify the full path to an existing or new directory in the Linux Path field so that the Linux POA can locate the re...

Page 45: ...hts are not required 11 Continue with Section 32 5 2 Restoring a User s Mailbox Items on page 415 or Section 32 5 3 Letting Client Users Restore Their Own Mailbox Items on page 416 as needed 32 5 2 Re...

Page 46: ...eeded The backup copy of your mailbox offers basic features such as Read Search and Undelete so that you can locate and retrieve the items you need 5 When you are finished restoring items to your live...

Page 47: ...s 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...

Page 48: ...418 GroupWise 7 Administration Guide novdocx en 11 December 2007...

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

Page 50: ...on 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 whet...

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

Page 52: ...ions 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...

Page 53: ...ck 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...

Page 54: ...381 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...

Page 55: ...for that user For more information see Section 27 2 Performing a Structural Rebuild of a User Database on page 387 and Section 27 3 Re creating a User Database on page 388 34 1 2 Using GWCheck on Win...

Page 56: ...he client user needs to copy the files from the GWCheck directory novell groupwise gwcheck to the main GroupWise directory novell groupwise To run GWCheck 1 From the Start menu click Run then browse t...

Page 57: ...l groupwise gwcheck bin directory 4 Enter gwcheck to start GWCheck 5 To view online help in GWCheck click Help 6 Continue with Performing Mailbox Library Maintenance Using GWCheck Using Text Based GWC...

Page 58: ...y 8 Enter gwcheckt options_file to run text based GWCheck If you did not copy the options file to your home directory on the text only server specify the full path to the options file Over time a coll...

Page 59: ...on page 429 Results on page 430 Misc on page 430 Exclude on page 430 Databases To select the types of database to perform the Mailbox Library Maintenance check on click Databases Figure 34 1 Databases...

Page 60: ...ers 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 options p...

Page 61: ...you do not want to use the default of gwcheck opt 4 Click Save Retrieving Mailbox Library Maintenance Options 1 In the Mailbox Library Maintenance dialog box click Retrieve 2 Browse to and select your...

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 431 34 1 8 GWCheck Startup Switches The fol...

Page 63: ...y just the filename If it is in a different directory you must specify the full pathname For example to start GWCheck with saved settings you would use Linux GWCheck Windows GWCheck Syntax lang code l...

Page 64: ...t A TSA serves as an intermediary between specific data types and a general backup engine GroupWise Target Service Agent GWTSA has long been included with GroupWise and must be used to back up GroupWi...

Page 65: ...WTSA works with other backup software on NetWare For a complete and current list of compatible backup software use the Partner Product Guide http www novell com partnerguide GWTSA has no user interfac...

Page 66: ...ge 448 Running GWTSA GWTSA should be used on NetWare 5 1 only The gwtsa nlm program file is automatically installed along with the GroupWise agents POA and MTA During agent installation a gwtsa ncf fi...

Page 67: ...or to other temporary locations where you want to restore data By default GWTSA places temporary files in the sys system temp directory during the backup process This minimizes the time that the backu...

Page 68: ...ach post office restore area and any other temporary location to which you want to restore GroupWise data outside the standard GroupWise directory structure Example home sys gwsystem dev ll Sets the l...

Page 69: ...ts GroupWise database lock backup unlock functionality so that you can back up a running GroupWise system Provides time stamping of GroupWise 6 5 3 and later user databases userxxx db so that the Allo...

Page 70: ...but its presence running along with other backup software provides GroupWise options in the backup software that would not otherwise be available As a Target Service Agent TSAFSGW supports any featur...

Page 71: ...being written during the backup locked files under the offiles directory in the post office cannot be excluded but error messages generated by them can be ignored NetWare Running TSAFS and TSAFSGW Run...

Page 72: ...e 6 5 Support Pack 4 GroupWise functionality is always enabled and you do not need to use the EnableGW switch 6 Continue with Running TSAFSGW on NetWare on page 442 Running TSAFSGW on NetWare The tsaf...

Page 73: ...lowing list of directory names to your backup program for display PO development DMS lib0001 BLB design_store DMS lib0002 BLB training_store You can then easily select what you want to back up You can...

Page 74: ...SLES 9 you can copy the novell sms RPM from the agents linux directory of the GroupWise 7 Administrator for Linux CD or from the GroupWise software distribution directory to the server where you want...

Page 75: ...rectory along with one or more home switches to specify the domains and post offices to back up 1 Make sure you are logged in as root 2 Change to the directory where the SMS executables are located cd...

Page 76: ...e rather than the object name You can then easily select what you 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 locatio...

Page 77: ...to opt novell groupwise agents lib must be copied to opt novell lib on the target server A symbolic link must be created from libtsafsgw so to libtsafsgw so version_number on the target server You ca...

Page 78: ...ise user databases include the dates when they were last backed up restored and retained The following sections provide information about the utility Section 34 3 1 GWTMSTMP Functionality on page 449...

Page 79: ...e GWTMSTMP to make sure that user databases are time stamped so that items will not be prematurely purged Restore If you use the GWTSA on NetWare 5 1 or TSAFS on NetWare 6 x OES or Linux to restore a...

Page 80: ...gents POA and MTA You can copy it to additional locations if needed To check the existing time stamp on all GroupWise user databases in a post office use the following command Syntax gwtmstmp p post_o...

Page 81: ...set A basic backup time stamp can also be set in ConsoleOne Select a Post Office object then click Tools GroupWise Utilities Backup Restore Mailbox On the Backup tab select Backup then click Yes More...

Page 82: ...times are displayed For example If no other operational switch is used get is assumed The following example returns the same results as the above example NetWare GWTMSTMP Linux GWTMSTMP Windows GWTMST...

Page 83: ...laced on user databases NetWare gwtmstmp p j dev Linux gwtmstmp p gwsystem dev Windows gwtmstmp p j dev NetWare GWTMSTMP Linux GWTMSTMP Windows GWTMSTMP Syntax set s set set NetWare gwtmstmp p j dev b...

Page 84: ...dd yyyy date mm dd yyyy Example date 01 03 2007 d 05 18 2007 date 05 18 2007 date 04 12 2007 NetWare gwtmstmp p j dev restore date 06 14 2007 Linux gwtmstmp p gwsystem dev restore date 06 15 2007 Win...

Page 85: ...Troubleshooting 3 Message Flow and Directory Structure DBCopy does not copy some directories Post office queue directories wpcsin and wpcsout Only post office data files and directories are copied Qu...

Page 86: ...commands to provide the date mm dd yyyy of the previous copy This causes DBCopy to copy only files that have been modified since the previous copy like an incremental backup DBCopy creates a log file...

Page 87: ...ul to set up a cron job to run DBCopy regularly at a time of day when your system is not busy 34 4 3 Using DBCopy on Windows 1 At a command prompt change to the directory where you installed the Group...

Page 88: ...ifies verbose logging DBCopy creates a log file named mmddgwbk nnn The first 4 characters represent the date A three digit extension allows for multiple log files created on the same day The log file...

Page 89: ...Standalone Database Maintenance Programs 459 novdocx en 11 December 2007 NetWare DBCopy Linux DBCopy Windows DBCopy Syntax v v v...