The following example shows a typical SAP MaxDB resource hierarchy:
The dependencies in the above example correspond to the following protected resources:
|LKIP.EXAMPLE.COM||protects the switchable IP address used for client connections|
|sapdb_EXAMPLE /data||protects the database data device space for the EXAMPLE database|
|sapdb_ EXAMPLE /log||protects the database log device space for the EXAMPLE database|
|sapdb_ EXAMPLE /rundirectory||protects the database RUNDIRECTORY for the EXAMPLE database|
|sapdb_ EXAMPLE /sys||protects the database system device space for the EXAMPLE database|
|sapdb_lk/data||protects the independent data path|
|sapdb_lk/dep||protects the dependent path|
|sapdb_lk/prog||protects the independent program path|
In the event of failover, SPS will bring the file system, IP address and database resources (including all the resource dependencies) in service on a backup server. Clients will be disconnected and will need to re-connect to the server. Any SQL statement that has not been committed will need to be re-entered.
Thanks for your feedback.
Post your comment on this topic.