The QHASM.Cluster_Info service contains information about a cluster.
The values returned for the columns in this view contain information from the DSPCLUINF CL command but represents them differently.
Authorization
The authorization ID of the statement must include the following privileges:
Authorization as required by PowerHA product functionality.
*OBJOPR and *READ authority on QHASM/CLU_INF.
Input/output system configuration (*IOSYSCFG) special authority.
Result Table
The table describes the columns in the view. Here the system name used is CLU_INF. The schema is QHASM.
Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
CLUSTER | CLUSTER | VARCHAR(10) | The name of the cluster |
CONSISTENT_INFORMATION | CLUSTS | VARCHAR(3) | Indicates whether or not the displayed information is consistent with other nodes in the cluster. YES The information is consistent for all active nodes in the cluster. NO The information retrieved from the node running the command may not be consistent with all the active nodes in the cluster. In order to obtain consistent information run the command on an active node, or start this node and run the command again. |
CURRENT_CLUSTER_VERSION | CLUVER | INTEGER | The version at which the nodes in the cluster are actively communicating with each other. This value in conjunction with the potential node version determines what nodes can join in the cluster. This value also determines the cluster's ability to use new functions supported by the node's potential node version. |
CURRENT_CLUSTER_MODIFICATION | CLUMODLVL | INTEGER | The modification level of the current cluster version. The modification level further identifies the version at which the nodes in the cluster communicate. |
CURRENT_POWERHA_VERSION | HAVER | INTEGER | The version at which the nodes in the cluster which are known by the PowerHA product are actively communicating with each other. Nodes are known by the PowerHA product if the PowerHA product is installed on the node in the same cluster and the potential PowerHA version of the node is compatible with the current PowerHA version. This value also indicates what function is supported by the known PowerHA nodes |
CURRENT_POWERHA_MODIFICATION | HAMODLVL | INTEGER | The modification level at which the nodes in the cluster which are known by the PowerHA product are actively communicating with each other. |
CURRENT_POWERHA_FIX_LEVEL | HAFIXLVL | INTEGER | The fix level at which the nodes in the cluster which are known by the PowerHA product are actively communicating with each other. |
CURRENT_POWERHA_MODIFICATION_PROGRAMMER | HAMODPGMR | INTEGER | This field should be used for verifying code compatibility between PowerHA modification levels and applications using the PowerHA functionality provided in the modification. This value is for programmer use and different from the displayed modification level on DSPCLUINF. |
CLUSTER_MESSAGE_QUEUE | CLUMSGQ | VARCHAR(10) Nullable | Specifies the message queue to receive messages relating to cluster-level or node-level events. Messages relating to failover will be sent to this queue. Contains the null value if no cluster message queue is specified. |
CLUSTER_MESSAGE_QUEUE_LIBRARY | CLUMSGQLIB | VARCHAR(10) Nullable | Specifies the name of the library that contains the cluster message queue. Contains the null value if no cluster message queue is specified. |
FAILOVER_WAIT_TIME | FLVWAITTIM | INTEGER | Number of minutes to wait for a reply to the failover message that was enqueued on the cluster message queue. -1 Wait forever until a reply is given to the failover message. 0 Proceed without user intervention. >=1 Number of minutes to wait for a reply to the failover message. If no reply is received in the specified number of minutes, the failover default action field will be looked at to decide how to proceed. |
FAILOVER_DEFAULT_ACTION | FLVDFTACN | VARCHAR(8) | Indicates what clustering should do when a reply to the failover message on the cluster message queue is not received within the time limit specified for the failover wait time parameter. *PROCEED Proceed with failover. *CANCEL Do NOT attempt failover. |
Examples
Example 1 - Get the name of the local cluster
Get the name of the cluster that the local node is a part of:
SELECT CLUSTER FROM QHASM.CLUSTER_INFO
Example 1 - Sample Output
CLUSTER |
|---|
MYCLU |
SQLSTATE Values
Errors and warnings returned by this function are returned as SQL state values. SQLSTATE values returned by this view are:
SQLSTATE | Message |
|---|---|
42501 | Not authorized to object CLU_INF in QHASM type *FILE |
42501 | NOT AUTHORIZED TO LIBRARY &1 |
42502 | CURRENT USER DOES NOT HAVE *IOSYSCFG SPECIAL AUTHORITY |
560CR | NO VALID LICENSE FOR IBM POWERHA FOR I FOUND |
58004 | AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION |