IT32719: HADR STANDBY FAILS WITH "BAD ENTRY STATE" REPORTED FROM SQLRLC_AUTH_GR_PROCESS_ENTRY_STATE

APAR status

• Closed as program error.

Error description

• This problem only affects HADR standby with both DB2_HADR_ROS
  and DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW register variables
  enabled.
  
  The standby database might encounter abnormal termination, with
  the following message from db2diag.log:
  
  2020-04-28-15.50.06.929421-240 I1260104E556     LEVEL: Severe
  PID  : 99310        TID : 139831770343168 PROC : db2sysc 0
  INSTANCE: xxx       NODE : 000      DB : xxx
  APPHDL : 0-293        APPID: *LOCAL.DB2.200428195006
  HOSTNAME: xxx
  EDUID : 394         EDUNAME: db2redom (xxx) 0
  FUNCTION: DB2 UDB, catcache support,
  sqlrlc_auth_gr_process_entry_state, probe:20
  MESSAGE : bad entry state
  DATA #1 : Hexdump, 4 bytes
  0x00007F2BABED1D34 : 0500 0000                 ....
  
  2020-04-28-15.50.06.929627-240 I1260661E940     LEVEL: Error
  PID  : 99310        TID : 139831770343168 PROC : db2sysc 0
  INSTANCE: xxx       NODE : 000      DB : xxx
  APPHDL : 0-293        APPID: *LOCAL.DB2.200428195006
  HOSTNAME: xxx
  EDUID : 394         EDUNAME: db2redom (xxx) 0
  FUNCTION: DB2 UDB, catcache support, sqlrlc_broadcast, probe:0
  MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
       "SQLCA has already been built"
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA  sqlcabc: 136 sqlcode: -901 sqlerrml: 15
  sqlerrmc: bad entry state
  sqlerrp : SQLRC008
  sqlerrd : (1) 0x801A006D   (2) 0x00000000   (3) 0x00000000
        (4) 0x00000000   (5) 0xFFFFFFEC   (6) 0x00000000
  sqlwarn : (1)   (2)   (3)   (4)    (5)   (6)
        (7)   (8)   (9)   (10)    (11)
  

Local fix

• On standby server, run: db2set
  DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW=OFF
  Note: Changes to this variable will take effect after deactivate
  and activate of the standby database.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to db2_v111m4fp6 or later                            *
  ****************************************************************
  

Problem conclusion

• Upgrade to db2_v111m4fp6 or later
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IT32751

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels