The isalive and looksalive parameters query the cluster manager software about the state of a database. With Isalive, the query is made to the active system and the check is known to be accurate. With Looksalive, on systems where the cluster manager maintains a cache of the cluster state, PROCLUSTER will query the cache instead of the active system. There is a small window of opportunity where the cache and the system could be out of sync.
To determine if a resource looks operational, enter the following command:
procluster db-name looksalive
The looksalive exit status returns the following text if the database looks alive:
Resource: db-name State: Looks Alive
The value of Looks Alive is only returned when the database is enabled and started. All other states return the following, where db-name is the fully qualified path of the database:
Resource: db-name State: Not Alive
To determine if a resource is actually operational, enter the following command:
procluster db-name isalive
The isalive exit status returns the following text if the database returns a successful query:
