IBM Data and AI Ideas Portal for Customers


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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


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
    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.