DB2 FOR LUW / DB2FORLUW / A50 - DB2

Start hadr requires instance file lock in exclusive mode.

However, if there is another connection from another member that
holds the instance file lock in shared mode, the start hadr
command would fail with SQL1776N rc7.

The following diagnostic message can be found in db2diag.log:

2018-08-09-16.22.59.315402-240 I391461E622           LEVEL:
Error

PID     : 25626                TID : 140080781977344 KTID : 4535


PROC    : db2sysc 0

INSTANCE: db2inst1             NODE : 000            DB   :
TESTDB

APPHDL  : 0-56                 APPID: *N0.yhao.180809202116

AUTHID  : DB2INST1             HOSTNAME: DB2INST1

EDUID   : 28                   EDUNAME: db2agent (TESTDB) 0

FUNCTION: DB2 UDB, base sys utilities,
sqeLocalDatabase::FirstConnect, probe:9689

MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing
violation."

          DIA8519C A file sharing violation has occurred,
filename was "".

****************************************************************
* USERS AFFECTED:                                              *
* purescale                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to release inclusive of this fix. Refer to SYSROUTE  *
* APAR.                                                        *
****************************************************************

To prevent connections from other members affecting the 'start
hadr' command, we recommend the following steps:

1. db2stop and db2start on the standby instance

2. For each member on the standby instance, issue "db2trc on
-debug DB2.SQLCC.sqlcctcpconnmgr_child.115 -suspend".

This will stop all incoming TCP connections.

3. Start hadr as standby.

4. For each member, issue "db2trc off" to resume the incoming db
connections.

not known / see Local fix

forerunner  : 
follow-up : IT25990 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.08.2018
26.10.2018
12.11.2018