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:
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:
To verify the success PROCLUSTER enable, examine the database log file (
.lg
) to see if the following messages occurred:
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 thecaa_stat
result:
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 |