Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Not under consideration
Created by Guest
Created on Mar 13, 2020

DR4A V1.2 Sequence not replicated

After insert on capture side on table with autonumber column, data is inserted, but sequence is not replicated on apply side.

You can follow the following steps to recreate the scenario.

CREATE LARGE TABLESPACE "TSD_DBA_TEST"

IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"

PAGESIZE 32 K

MANAGED BY AUTOMATIC STORAGE

AUTORESIZE YES

INCREASESIZE 10 PERCENT

EXTENTSIZE 32

BUFFERPOOL "IBMDEFAULTBP"

OVERHEAD INHERIT

TRANSFERRATE INHERIT

DATA TAG INHERIT

USING STOGROUP "IBMSTOGROUP";

CREATE LARGE TABLESPACE "TSI_DBA_TEST"

IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"

PAGESIZE 32 K

MANAGED BY AUTOMATIC STORAGE

AUTORESIZE YES

INCREASESIZE 10 PERCENT

EXTENTSIZE 32

BUFFERPOOL "IBMDEFAULTBP"

OVERHEAD INHERIT

TRANSFERRATE INHERIT

DATA TAG INHERIT

USING STOGROUP "IBMSTOGROUP";

CREATE TABLE "PRD_DBA"."PETRA_TEST_AUTONUM" (

"ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE NO CACHE NO ORDER ),

"NUM" SMALLINT NOT NULL,

"TEXT" CHAR(10 CODEUNITS32)

)

ORGANIZE BY ROW

DATA CAPTURE NONE

IN "TSD_DBA_TEST" INDEX IN "TSI_DBA_TEST"

DISTRIBUTE BY HASH ("NUM")

COMPRESS YES STATIC;

ALTER TABLE "PRD_DBA"."PETRA_TEST_AUTONUM" ADD CONSTRAINT "PK_PETRA_TEST_AUTONUM" PRIMARY KEY

("NUM") NOT ENFORCED;

COMMENT ON TABLE "PRD_DBA"."PETRA_TEST_AUTONUM" IS

'Petra: TESTNA_TABELA';

On capture side we inserted 2 records:

INSERT INTO "PRD_DBA"."PETRA_TEST_AUTONUM" (NUM, TEXT) VALUES (1, 'a');

INSERT INTO "PRD_DBA"."PETRA_TEST_AUTONUM" (NUM, TEXT) VALUES (2, 'b');

Then we insert 3 records on apply side:

INSERT INTO "PRD_DBA"."PETRA_TEST_AUTONUM" (NUM, TEXT) VALUES (3, 'C');

INSERT INTO "PRD_DBA"."PETRA_TEST_AUTONUM" (NUM, TEXT) VALUES (4, 'D');

INSERT INTO "PRD_DBA"."PETRA_TEST_AUTONUM" (NUM, TEXT) VALUES (5, 'E');

As we see on results of insert on apply side below, replication does not consider autonumber from capture side. We ran the following query on the apply side:

select *

FROM "PRD_DBA"."PETRA_TEST_AUTONUM"

order by id

The result of the select:

ID NUM TEXT

-- --- ----------

1 3 C

1 1 a

2 4 D

2 2 b

3 5 E

A workaround suggested by the development team (Senthil C., Nishant M.) is to use odd/even numbering on capture/apply side. However, this requires manual steps from the DBA. Since there will be a large number of tables used on our DWH environment, we expect the solution to be automatic.

As per agreement with DR4A dev team and case TS003221534 this request was opened.

Needed by Date Mar 26, 2020
  • Guest
    Reply
    |
    May 28, 2021

    Dear Madam/Sir,

    Thank you for your e-mail, but unfortunately I am no longer available at this email, or organization.

    If you need immediate assistance, please contact Mitja Makovec (mitja.makovec@nlb.si)

    BR,

    Petra Kakovi� Bizjak

    ==========================================================================================
    To elektronsko sporo�ilo in vse morebitne priloge so poslovna skrivnost in namenjene izklju�no naslovniku. �e ste sporo�ilo prejeli pomotoma, Vas prosimo, da obvestite po�iljatelja, sporo�ilo pa takoj uni�ite. Kakr�nokoli razkritje, distribucija ali kopiranje vsebine sporo�ila je izrecno prepovedano. Ni nujno, da to sporo�ilo odra�a uradno stali��e dru�be.
    Elektronsko sporo�ilo je pregledano z antivirusnim programom.

    This e-mail and any attachments may contain confidential and/or privileged information and is intended solely for the addressee. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. This e-mail may not necessarily reflect the official viewpoint of the company.
    E-mail message is scanned by Anti-Virus Software.