IBM Support

IT36741: CDR LIST CATALOG --REPLICATE OMITS OPTIONS LIKE --MASTER, --ERKEY FOR GENERATED CDR DEFINE REPLICATE COMMANDS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as user error.

Error description

  • cdr list catalog --replicate omits options  like --master,
    --erkey for  generated cdr define replicate commands
    
    Below is the sample output from test instance
    
    <<<<<<<
    cdr define replicate --conflict=ignore --scope=row
    customer_repl \
    "stores1@g_cdr2: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 customer t" \
    "stores1@g_cdr1: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 customer t"
    
    cdr define replicate --conflict=ignore --scope=row  test1_repl \
    "stores1@g_cdr2:informix.test1" "select t.ifx_erkey_1,
    t.ifx_erkey_2, t.ifx_erkey_3, t.c1, t.c2 from test1 t" \
    "stores1@g_cdr1:informix.test1" "select t.ifx_erkey_1,
    t.ifx_erkey_2, t.ifx_erkey_3, t.c1, t.c2 from test1 t" \
    "stores1@g_cdr3:informix.test1" "select t.ifx_erkey_1,
    t.ifx_erkey_2, t.ifx_erkey_3, t.c1, t.c2 from test1 t"
    <<<<<<<<<<<<<<<
    
    cdr list repl customer_repl
    
    DEFINED REPLICATES ATTRIBUTES
    ------------------------------
    REPLICATE:        customer_repl
    STATE:            Active ON:g_cdr2
    CONFLICT:         Ignore
    FREQUENCY:        immediate
    QUEUE SIZE:       0
    PARTICIPANT:      stores1:informix.customer
    OPTIONS:          row,fullrow
    REPLID:           131073 / 0x20001
    REPLMODE:         PRIMARY  ON:g_cdr2
    APPLY-AS:         INFORMIX ON:g_cdr2
    REPLTYPE:         Master
    
    You can see that customer_repl is a master replicate but is not
    listed in the 'cdr define replicate' command generated by 'cdr
    list catalog -r'
    
    Similarly can see from the  replicate definition of test1_repl,
    erkey was used to define the replicate but is not listed in the
    'cdr define replicate' command generated by 'cdr list catalog
    -r'.
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • Inclined to return this defect as not really requiring anything
    to be fixed:
    

APAR Information

  • APAR number

    IT36741

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED USE

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-04-29

  • Closed date

    2022-11-04

  • Last modified date

    2022-11-04

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
04 November 2022