Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

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

560CR

POWERHA FOR I ENTERPRISE EDITION NOT INSTALLED ON NODE &1

560CR

GRACE PERIOD EXPIRED FOR POWERHA FOR I ENTERPRISE EDITION ON NODE &1

560CR

USAGE LIMIT EXCEEDED FOR POWERHA FOR I ENTERPRISE EDITION ON NODE &1

560CR

POWERHA FOR I STANDARD EDITION NOT INSTALLED ON NODE &1

560CR

GRACE PERIOD EXPIRED FOR POWERHA FOR I STANDARD EDITION ON NODE &1

560CR

USAGE LIMIT EXCEEDED FOR POWERHA FOR I STANDARD EDITION ON NODE &1

560CR

POWERHA FOR I STANDARD EXPRESS NOT INSTALLED ON NODE &1

560CR

GRACE PERIOD EXPIRED FOR POWERHA FOR I STANDARD EXPRESS ON NODE &1

560CR

USAGE LIMIT EXCEEDED FOR POWERHA FOR I STANDARD EXPRESS ON NODE &1

58004

AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION