Configure each WorkSite Server database belonging to this server.
1. From the WorkSite Service Manager tool, select the WorkSite Server service.
2. From the Properties menu, select Database Properties. The WorkSite Server Database Setup dialog opens.
Figure 7 WorkSite Server Database Setup Dialog Document Date
Options This option determines whether the created and modified dates on a file are set based on information in the file, or by WorkSite.
• Use System Dates: When a file is imported into WorkSite, the "Created"
property is populated with the date and time of when the file was imported to WorkSite. The "Modified" property is updated with the date and time when the file was last modified in WorkSite. This method ignores the original created and modified information of the file. Use System Dates is the default setting.
• Use File Dates: This option saves both the original file dates (created and modified) as well as the dates and times of when the file was imported or modified in WorkSite.
Note. Do not switch these settings back and forth.
Table 4 WorkSite Server Properties Dialog Options Field/Feature Description
Configuring WorkSite Server Service Database Properties
The Database Setup dialog box shows those databases that the WorkSite Server is currently serving. If you have not connected WorkSite Server Service to any databases yet, the list view in this dialog box is blank.
3. Click Add Database, or select an existing database from the list and click Modify. The Database Properties dialog opens.
Figure 8 Database Properties Dialog
4. Enter the database name. You can select it from the list of available ODBC sources, by using the browse button.
5. Enter the Logon ID and Password for the entered or selected ODBC.
6. Select the Enable Cache Fileserver option if you are using WorkSite Server with Caching and want to enable Fileserver caching for this database.
7. In the How many connection section, choose one of the following options:
As Many Connections as Threads—this option configures the WorkSite Server to establish a 1:1 ratio of database connections
The default ratio of threads running on the WorkSite Server to database connections is 1:1. You can customize this ratio to optimize performance on the system. When your WorkSite database is local and heavily used, the recommended ratio of threads to connection is 1:1. When the WorkSite Server is connecting to a remote database or to a database that is infrequently used, you may want to reduce the number of SQL database connections to reduce the number of connections that must be maintained over the WAN. You may also want to customize the number of database connections when the WorkSite Server is connecting to an infrequently used database, such as a read-only repository of old documents. When the ratio of threads to connections is not 1:1, the
number of SQL connections available to the WorkSite Server are pooled and shared among the simultaneous threads running on the WorkSite Server.
Connection Count—Enter the number of SQL database connections that the WorkSite Server service should maintain to this database.
8. In the Designate database as section, select one of the following options:
Preferred Database—Select this option to designate this database as the source for dialog boxes, captions, and roles. Any database that is identified as a Preferred Database can serve as a source for dialog boxes, captions and roles. Each WorkSite Server must be connected to at least one database that is identified as a preferred database. You can specify alternate preferred databases for individual users using the Database
Administration tool.
Web Content—select this option if the WorkSite Server is to be used as the database for the WorkSite web client.
Select the Hidden option if you do not want to display the Web Content database.
9. Click Advanced to set the following options for this library. The Advanced Properties dialog box opens.
Figure 9 Advanced Properties dialog box
Select Prevent flat space filing to force users to file content inside a workspace. When enabled, WorkSite clients will prevent any content from being filing outside a
workspace.
In the Grace period to undeclare (hours) field, select one of the following grace period options.
• No grace period. This option does not provide a grace period to undeclare a declared document. Selecting it denotes that once a document is declared, it cannot be undeclared. This is the default option.
Configure Connections from WorkSite Server to File Servers
• Infinite grace period. This option provides an unlimited period to undeclare a declared document. Selecting it denotes that a normal user can undeclare a declared document irrespective of when the document was declared.
• Specify grace period (hours): Specify the time period within which a normal user can undeclare a declared document. This time period is calculated from when the document was declared. The value set here updates the Undeclare Record registry setting in the following key on the WorkSite Server:
HKEY_LOCAL_MACHINE\Software\Interwoven\WorkSite\imDmsSvc\Databases\
<Database Name>\
In the Locale ID field, enter the numerical identifier for the language of the WorkSite database. WorkSite supports the storage of information in U.S. English plus one additional language. For WorkSite to support this additional language, you must enter the Locale ID of the second language here. The locale ID value must compliment the database collation setting. Refer to the WorkSite Design Guide for more information and for a complete list of Locale IDs. This list can also be found on the Microsoft web site.
The default value is 1033 (U.S. English).
Caution: The Locale ID setting must only be set for a new WorkSite database. Do not alter this setting for an existing (deployed) WorkSite database.
NOTE
For information about configuring the WorkSite Indexer portion of this dialog, refer to the WorkSite Indexer Administration Guide.
10. Click OK to add the database. The database is now added to the list seen in the WorkSite Server Database Setup dialog.
11. Click Close to save the settings.