statut de DB2 HADR en SQL

 
$  db2 "select cast(HADR_LOCAL_HOST as varchar(10)) as local, \
cast(HADR_REMOTE_HOST as varchar(10)) as remote,  \
cast(DB_NAME  as varchar(10)) as db, HADR_STATE, \
HADR_CONNECT_STATUS from SYSIBMADM.SNAPHADR"

LOCAL      REMOTE     DB         HADR_STATE     HADR_CONNECT_STATUS
---------- ---------- ---------- -------------- -------------------
PROD       BACK       DATABASE   PEER           CONNECTED

  1 record(s) selected.