home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT37197 Status: Closed

CDR LIST CATALOG IS NOT SHOWING 'REPLICATION TO SPL ROUTINE' WHICH WAS
DEFINED IN CDR DEFINE REPL

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
Customer has defined cdr define replicate with below command and
have used --jsonsplname=sp_data_change_capture

$ cat cdr_jsonspl_test.sh
cdr define replicate --conflict=always --ats --ris --scope=row
--jsonsplname=sp_data_change_capture repl_customer 
"stores_demo@g_informix:informix.customer" "select
t.customer_num, t.fname, t.lname, t.company, t.address1,
t.address2, t.city, t.state, t.zipcode, t.phone from
informix.customer t" 
"R stores_demo@g_loopback:informix.customer" "select
t.customer_num, t.fname, t.lname, t.company, t.address1,
t.address2, t.city, t.state, t.zipcode, t.phone from
informix.customer t"

$ sh cdr_jsonspl_test.sh
Interpreting this replicate as a master replicate.
Verification of stores_demo@g_informix:informix.customer started
Verification of stores_demo@g_informix:informix.customer is
successful
Verification of stores_demo@g_loopback:informix.customer started
Verification of stores_demo@g_loopback:informix.customer is
successful

but cdr list catalog is showing [17] [16] [15]

$ cdr list catalog --repl
#
# cdr define replicate commands.
#
cdr define replicate --conflict=always --ats --ris --scope=row
[17] [16] [15]  repl_customer 
"stores_demo@g_informix:informix.customer" "select
t.customer_num, t.fname, t.lname, t.company, t.address1,
t.address2, t.city, t.state, t.zipcode, t.phone from
informix.customer t" 
"R stores_demo@g_loopback:informix.customer" "select
t.customer_num, t.fname, t.lname, t.company, t.address1,
t.address2, t.city, t.state, t.zipcode, t.phone from
informix.customer t"

which means '--jsonsplname=sp_data_change_capture' becomes '[17]
[16] [15]' in cdr list catalog.

$ cdr list repl

CURRENTLY DEFINED REPLICATES
-------------------------------
REPLICATE:        repl_customer
STATE:            Inactive ON:g_informix
CONFLICT:         Always Apply
FREQUENCY:        immediate
QUEUE SIZE:       0
PARTICIPANT:      stores_demo:informix.customer
OPTIONS:          row,ris,ats,fullrow,loopback,repl2spl
REPLID:           65563 / 0x1001b
REPLMODE:         PRIMARY  ON:g_informix
APPLY-AS:         INFORMIX ON:g_informix
REPLTYPE:         Master

SPL routine (sp_data_change_capture):

CREATE TABLE data_change_log (data BSON);
CREATE INDEX data_change_log ON data_change_log
    (BSON_VALUE_BIGINT(data, 'commit_time')) USING BSON;
CREATE PROCEDURE sp_data_change_capture (data jSON)
    INSERT INTO data_change_log VALUES (data);
END PROCEDURE;
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC7.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC7.                        *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC7.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC7.                        *
****************************************************************
Comment
Fixed in Informix Server 14.10.xC7.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.06.2021
02.11.2021
02.11.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)