SUNW.sapdb

, sapdb

- resource type implementation for Oracle Solaris Cluster HA for SAP MaxDB

Description

The SUNW.sapdb resource type represents the SAP MaxDB application in an Oracle Solaris Cluster configuration. The SAP MaxDB application requires the SAP xserver system. Therefore, you must set a dependency between the SAP MaxDB resource group and the SAP xserver resource group. Create this dependency when you register and configure the Oracle Solaris Cluster HA for SAP MaxDB data service. See Registering and Configuring HA for SAP MaxDB in Oracle Solaris Cluster Data Service for SAP MaxDB Guide.

Standard properties and extension properties that are defined for the SUNW.sapdb resource type are described in the subsections that follow. To set these properties for an instance of the SUNW.sapdb resource type, use the clresourcetype(1CL) command.

Standard Properties

Standard resource properties are overridden for this resource type as follows:

Retry_Count

Maximum

10

Default

2

Tunable

Any time

Retry_Interval

Maximum

3600

Default

850

Tunable

Any time

Thorough_Probe_Interval

Maximum

3600

Default

120

Tunable

Any time

For a description of these standard resource properties, see r_properties(5).

Extension Properties

The extension properties of this resource type are as follows:

dbmcli_Start_Option

The option that is passed to the dbmcli command to start the SAP MaxDB database instance.

---

Note - For MaxDB version 7.4.3, set this property to db_online.

---

Data type

String

Default

db_online

Range

Not applicable

Tunable

When disabled

DB_Name

The name of the MaxDB database instance in uppercase. This name is created when MaxDB is installed and configured. See Installing and Configuring SAP MaxDB in Oracle Solaris Cluster Data Service for SAP MaxDB Guide.

Data type

String

Default

No default defined

Range

Not applicable

Tunable

When disabled

DB_User

The UNIX user identity of the operating system (OS) user that 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. See Installing and Configuring SAP MaxDB in Oracle Solaris Cluster Data Service for SAP MaxDB Guide.

Data type

String

Default

No default defined

Range

Not applicable

Tunable

When disabled

Failover_enabled

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

Data type

Boolean

Default

True

Range

Not applicable

Tunable

Any time

---

Note - The Failover_mode=RESTART_ONLY setting matches the behavior of the Failover_enabled=False setting. The Failover_mode=LOG_ONLY setting goes a step further and prevents resources from restarting. Use the Failover_mode property instead of the Failover_enabled extension property to better control failover behavior. For more information, see the descriptions of the LOG_ONLY and RESTART_ONLY values for Failover_mode in r_properties(5).

---

Independent_Program_Path

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

Oracle Solaris Cluster 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.

Data type

String

Default

/sapdb/programs

Range

Not applicable

Tunable

When disabled

Monitor_retry_count

The maximum number of restarts by the process monitor facility (PMF) that are allowed for the fault monitor.

Data type

Integer

Default

4

Range

No range defined

Tunable

Any time

Monitor_retry_interval

The period of time in minutes during which the PMF counts restarts of the fault monitor.

Data type

Integer

Default

2

Range

No range defined

Tunable

Any time

Pid_Dir_Path

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

Data type

String

Default

/var/spool/sql

Range

Not applicable

Tunable

When disabled

Probe_timeout

The timeout value in seconds that the fault monitor uses to probe an MaxDB database instance.

Data type

Integer

Default

90

Range

30–99,999

Tunable

Any time

Restart_if_Parent_Terminated

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

Data type

Boolean

Default

False

Range

Not applicable

Tunable

Any time

User_Key

The user key of the database user that administers the MaxDB database instance. This user key is created when MaxDB is installed and configured. See Installing and Configuring SAP MaxDB in Oracle Solaris Cluster Data Service for SAP MaxDB Guide.

Data type

String

Default

No default defined

Range

Not applicable

Tunable

When disabled

Examples

Example 1 Creating a SUNW.sapdb Resource

# clresource create -g sapdbrg -t SUNW.sapdb \\ 
-p DB_Name=TST -p DB_User=dbadmin -p User_Key=DEFAULT \\ 
-p resource_dependencies=hsprs sapdbrs

This example shows the creation of a SUNW.sapdb resource that has the following characteristics:

• The resource is named sapdbrs.

• The resource is a member of a resource group that is named sapdbrg. The creation of this resource group is not shown in this example.

• The resource is an instance of the SUNW.sapdb resource type. The registration of this resource type is not shown in this example.

• The MaxDB database instance that is associated with this resource is named TST.

• The UNIX user identity of the OS user that administers the MaxDB database is dbadmin.

• The user key of the database user that administers the MaxDB database is DEFAULT.

• The MaxDB resource depends on an HAStoragePlus resource that is named hsprs. The creation of the hsprs resource is not shown in this example.

This example does not show the creation of the logical host resource that the MaxDB resource uses.

Attributes

See attributes(5) for descriptions of the following attributes:

See Also

clresourcegroup(1CL)clresourcetype(1CL), clresource(1CL), attributes(5), r_properties(5), SUNW.sap_xserver(5).

Oracle Solaris Cluster Data Service for SAP MaxDB Guide