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.
Post your comment on this topic.