1. Installing and Configuring HA for MaxDB
A. HA for MaxDB Extension Properties
The SUNW.sapdb resource type represents the MaxDB application in a Oracle Solaris Cluster configuration. The extension properties of this resource type are as follows:
The option that is passed to the dbmcli command to start the MaxDB database instance.
Note - For MaxDB version 7.4.3, set this property to db_online.
String
db_online
Not applicable
When disabled
The name of the MaxDB database instance in uppercase. This name is created when MaxDB is installed and configured as explained in Installing and Configuring MaxDB.
String
No default defined
Not applicable
When disabled
The UNIX user identity of the operating system (OS) user who administers the MaxDB database instance. This user's home directory contains the .XUSER.62 file that was created during the installation and configuration of MaxDB. For more information, see Installing and Configuring MaxDB.
String
No default defined
Not applicable
When disabled
Specifies whether the fault monitor fails over the MaxDB resource if the number of attempts to restart exceeds Retry_count within the time that Retry_interval specifies. The possible values of this extension property are as follows:
True – Specifies that the fault monitor fails over the MaxDB resource
False – Specifies that the fault monitor does not fail over the MaxDB resource
Boolean
True
Not applicable
Any time
The full path to the directory that contains the following programs and libraries for the MaxDB application:
Programs that are independent of the database software version
Libraries for the client runtime environment
HA for MaxDB determines the path to the dbmcli command from the value of this property. The dbmcli command resides in the bin subdirectory of the directory that this property specifies.
String
/sapdb/programs
Not applicable
When disabled
The maximum number of restarts by the process monitor facility (PMF) that are allowed for the fault monitor.
Integer
4
No range defined
Any time
The period of time in minutes during which the PMF counts restarts of the fault monitor.
Integer
2
No range defined
Any time
The full path to the directory under which files that store the process identities of MaxDB kernel processes are created. The process identities of MaxDB kernel processes are stored in the following files:
pid-dir/ppid/db-name
pid-dir/pid/db-name
The replaceable items in these file paths are as follows:
pid-dir is the directory that the Pid_Dir_Path extension property specifies
db-name is the name of the MaxDB database instance that the DB_Name extension property specifies
String
/var/spool/sql
Not applicable
When disabled
The timeout value in seconds that the fault monitor uses to probe an MaxDB database instance.
Integer
90
30–99,999
Any time
Determines whether the fault monitor restarts the MaxDB database instance if the parent kernel process is terminated. The possible values of this extension property are as follows:
True – Specifies that the fault monitor restarts the MaxDB database instance if the parent kernel process is terminated
False – Specifies that the fault monitor does not restart the MaxDB database instance if the parent kernel process is terminated
Boolean
False
Not applicable
Any time
The user key of the database user who administers the MaxDB database instance. This user key is created when MaxDB is installed and configured as explained in Installing and Configuring MaxDB.
String
No default defined
Not applicable
When disabled