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
- Upgrade Note
- If
you are upgrading from a DB2 Version 9.8 Fix Pack 4 pureScale environment
or earlier, the value of hadr_db_role is set
to the value on member 0.
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.