Instance level operations which include topology changes might not synchronize with queries in flight

Online Db2 Big SQL console operations, as well as user packages that are running against Db2 Big SQL during online topology changes, might require package rebind.

Symptoms

In db2diag.log the following error message is logged:

2016-05-30-05.13.21.236966-420 I39769180E938         
LEVEL   : Severe
PID     : 33953                
TID     : 140529887078144 PROC : db2sysc 0
INSTANCE: bigsql               
NODE    : 000            
DB      : BIGSQL
APPHDL  : 0-19784              
APPID   : 9.30.105.51.55717.160530121322
AUTHID  : BIGSQL               
HOSTNAME: host1.svl.ibm.com
EDUID   : 285                  
EDUNAME : db2agent (BIGSQL) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 55
sqlerrmc: Rebind Package.  Possibly DROP DBPARTITIONNUM was done.
sqlerrp : SQLRI500
sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000      (4) 0x00000000      (5) 0xFFFFFFF6      (6) 0x00000000
sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)       (7)      (8)      (9)      (10)       (11)
sqlstate:

Resolving the problem

In order to rebind all valid and invalid packages from the CLP by using the bigsql instance user, run the db2rbind command as follows:

db2rbind BIGSQL -l logfile all -u userid -p password

Review the log file that is specified by logfile, and address any issues.