DB2 Version 10.1 for Linux, UNIX, and Windows

hadr_db_role - HADR database role configuration parameter

This parameter indicates the current role of a database, whether the database is online or offline.

Configuration type
Database
Applies to
  • Database server with local and remote clients
  • Database server with local clients
Parameter type
Informational
Valid values are: STANDARD, PRIMARY, or STANDBY.
Note: When a database is active, the HADR role of the database can also be determined using the GET SNAPSHOT FOR DATABASE command.