INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

A parallel shard query when run from a Secondary server fails
with error code clixnotactive when connecting to the local
server.

DBSERVERNAME serv_1
SHARD_ID  1

DBSERVERNAME serv_2
SHARD_ID  1

DBSERVERNAME serv_3
SHARD_ID  3

DBSERVERNAME serv_4
SHARD_ID  3

clust_a_grp            group  -         -         i=1
serv_1 onsoctcp        vmwood177          12161
g=clust_a_grp
serv_2 onsoctcp        vmwood177          12162
g=clust_a_grp

clust_b_grp            group  -         -         i=2
serv_3 onsoctcp        vmwood177          12163
g=clust_b_grp
serv_4 onsoctcp        vmwood177          12164
g=clust_b_grp

And there is an error message in the online.log:

09:26:19  Error code on connect -9
09:26:19  Error code on connect -9
09:26:19  Error code on connect -9





############
Secondary
############
onstat -g shard

IBM Informix Dynamic Server Version 12.10.FC8 -- Read-Only (Sec)
-- Up 00:25:45 -- 156276 Kbytes
andy shard_nl:informix.lightning  key:country EXPRESSION:DELETE
SHARD OPTIMIZATION:ENABLED
Matching for delete:observed
   clust_a_grp (65540) country IN (1,2,3,4,5)
   clust_b_grp (65541) country IN (6,7,8,9)

echo "set environment USE_SHARDING 'on'; select * from
lightning" | dbaccess shard_nl

Database selected.


Environment set.


26972: Sharding Internal Error.
Error in line 1
Near character position 58

****************************************************************
* USERS AFFECTED:                                              *
* All platforms                                                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9                      *
****************************************************************

not known / see Local fix

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

10.01.2017
11.07.2017
11.07.2017

12.10.xC9