Progress
Version 9
Product Update Bulletin


Cluster-enabling a Database

Once the database is created and resides on a shared disk, you can enable the database as a cluster resource so that it will fail over properly. The database must not be in use when it is enabled as a cluster resource. Enable the database as a cluster resource with the following command:

procluster db-name enable [-pf params-file] [AI][BI][APW=n][WDOG] 

The database must be located on a shared disk among the cluster nodes. The shared disk must be online for the current node.

db-name

Specifies the fully qualified path of the database you want to enable for fail over.

params-file

Specifies the file containing any parameters that the database requires when started.

AI

Directs PROCLUSTER to enable the after-image files, and an AI writer as resources with a dependency on the database. After-imaging must have previously been enabled on the database.

BI

Directs PROCLUSTER to enable a BI writer as a resource with a dependency on the database.

APW=n

Directs PROCLUSTER to enable n number of asynchronous page writers as a resource with a dependency on the database.

WDOG

Directs PROCLUSTER to enable the Watchdog process as a resource with a dependency on the database.

When you enable a database as a resource using PROCLUSTER enable, Clusters performs the following:

If PROCLUSTER enable is successful, it returns the following message:

The cluster REGISTER command was successful. (10532) 

To verify the success PROCLUSTER enable, examine the database log file (.lg) to see if the following messages occurred:

xx.xx.xx prostrct cluster session begin for userid on CON:. (451) 
xx.xx.xx prostrct cluster session end. (334) 

To verify that the database is created and available on the machine as a cluster resource on Windows, you can use the Cluster Administrator to verify that the fully qualified path of the database is visible within the Virtual Server Group area of the tool. On UNIX, you can use the operating system-specific command to enumerate cluster objects, such as caa_stat on HP Tru64. In the list of enumerated objects, the database with a UUID appended to the end will be listed, with the target and state displayed as offline. The following example shows the caa_stat result:

db_nameE3B35CEF-0000-0000-DC17-ABAD00000000 

where the text is the UUID for the newly created database resource. For more information on cluster administration tools and commands, see your operating system cluster documentation.

NOTE: The PROCLUSTER ENABLE will register the database as a cluster resource, even if there are errors in the command for the helper processes. To correct the errors, you must first use PROCLUSTER DISABLE to unregister the database, then use PROCLUSTER ENABLE to re-register without errors.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095