How the Database Probe Function Is Configured
A feature of the Solaris Cluster software, the database Probe function allows the Cluster to verify that an application is still working correctly and still accessible.
To determine how the probe script operates, examine the IngresSCAgent/bin/ingres_probe file.
To enable the Ingres High Availability Option database probe, you must define the variables User, Database, Table, and Probe_timeout.
An optional variable Envfile specifies an external script that can be used to set up additional script variables during the database probe.
To use the ingres_probe feature you must first create a database with a table that contains the column "cluster_monitor". The owner of the database and table must also be defined if it does not already exist.
The following commands are an example of how to create the necessary database and table:
$ sql iidbdb
* CREATE USER User \g
* COMMIT \g \q
$ sql Database -uUser
* CREATE TABLE User.Table ( cluster_monitor DATE ) ; \g
* INSERT INTO User.Table (cluster_monitor) VALUES (DATE('NOW')); \g
* COMMIT \g \q