Return
-
Title
SQL1776N The command cannot be issued on an HADR database. Reason code = "1". -
Description
HADR DB2 Backups Ocassionally falils with SQL1776N The command cannot be issued on an HADR database. Reason code = "1". -
Cause
IBM DB2 does not support the backup of Standby databases in an HADR environment.During such a backup operation,the Netvault Plug-in for DB2 may fail with thefollowing error message:SQL1776N. The command cannot be issued on an HADR database. Reason code = 1. -
Resolution
This is observed in HADR where " During the takeover, the virtual IP and HA proxy are moved to the new node and then the DB2 HADR takeover is performed, Meaning the DB2 is on from the Standbyserver and backup attempt during the time will fail with such error.
Standby databases can be backedup and configured via netvault plugin to avoid backup failure during standby ON StateIBM reference to check the current state of HADR database serverwhen run on the primary, the cmwo_db2hadr_status command will show HADR_ROLE=PRIMARY for all databases, HADR_STATE=PEER for the first HADR standby (also known as the principal standby), and HADR_STATE=REMOTE_CATCHUP for all other HADR standbys. When run on a standby node, the HADR_ROLE will be STANDBY, and the HADR_STATE will be PEER or REMOTE_CATCHUP. The cmwo_db2hadr_status command will display summary output similar to the following output:*** Summary: ***All databases are PRIMARYDB2 HADR looks OKAY.