Infosphere CDC

David Steibing

Infosphere CDC

Hello,

 

I am trying to add a mapping of a table from one subsystem to another, this is something that I have done dozens of time without issue however I am receiving an error on a particular table where I am receiving a CDC0068E and CDC1502E. These errors state that the structure has changed since it was selected where I know it hasn't. Has anyone seen this issue and what was the resolution. Thanks

Jørn Thyssen

RE: Infosphere CDC
(in response to David Steibing)

Hi

Does this solve the issue?

https://www-01.ibm.com/support/docview.wss?uid=swg21468454

http://www-01.ibm.com/support/docview.wss?uid=swg21980755

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2018 IBM Champion.

Views are personal. 

David Steibing

[External] Infosphere CDC
(in response to Jørn Thyssen)
The error occurs when I am trying add the table for replication. I have seen the below documentation and that is describing when the table already exists in the subscription.

From: Jørn Thyssen <[login to unmask email]>
Sent: Saturday, March 02, 2019 12:02 PM
To: [login to unmask email]
Subject: [External] [DB2-L] - RE: Infosphere CDC


ATTENTION: This email message is from an external sender. Do not open links or attachments from unknown sources. To report suspicious email, forward the message as an attachment to [login to unmask email]<mailto:[login to unmask email]>.

Hi

Does this solve the issue?

https://www-01.ibm.com/support/docview.wss?uid=swg21468454

http://www-01.ibm.com/support/docview.wss?uid=swg21980755



Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2018 IBM Champion.

Views are personal.

-----End Original Message-----

Stacey Konopaske

[External] Infosphere CDC
(in response to David Steibing)
I have run into this also – on DB2 z I had the issue if the source table was in AREO status - a reorg of the source table resolved the problem.

Thanks,


Stacey Konopaske
Enterprise Data Services
Global Infrastructure Services Group
CIGNA Systems Division
(860) 298-2731 (3-2731)
[login to unmask email]<mailto:[login to unmask email]>
https://confluence.sys.cigna.com/pages/viewpage.action?pageId=169340419
Confidential, unpublished property of Cigna. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. © Copyright 2019 Cigna.


From: Steibing, David [mailto:[login to unmask email]
Sent: Monday, March 04, 2019 8:58 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: [External] Infosphere CDC

The error occurs when I am trying add the table for replication. I have seen the below documentation and that is describing when the table already exists in the subscription.

From: Jørn Thyssen <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Saturday, March 02, 2019 12:02 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [External] [DB2-L] - RE: Infosphere CDC


ATTENTION: This email message is from an external sender. Do not open links or attachments from unknown sources. To report suspicious email, forward the message as an attachment to [login to unmask email]<mailto:[login to unmask email]>.

Hi

Does this solve the issue?

https://www-01.ibm.com/support/docview.wss?uid=swg21468454 https://urldefense.proofpoint.com/v2/url?u=https-3A__www-2D01.ibm.com_support_docview.wss-3Fuid-3Dswg21468454&d=DwMFaQ&c=WlnXFIBCT3pmNh_w8hYeLw&r=6OOMt7cyjnmO39KUoF9tSeArtMbDo7ylot2L9_W-ANo&m=E0WqjfmlMSwjqdCHmmtS2iIjCXOzuA6gAxFA9NkglIE&s=Ugb2D0MFe4LZLLqruDy0WGdH_A0FyofwcrEHTdM85OI&e=

http://www-01.ibm.com/support/docview.wss?uid=swg21980755 https://urldefense.proofpoint.com/v2/url?u=http-3A__www-2D01.ibm.com_support_docview.wss-3Fuid-3Dswg21980755&d=DwMFaQ&c=WlnXFIBCT3pmNh_w8hYeLw&r=6OOMt7cyjnmO39KUoF9tSeArtMbDo7ylot2L9_W-ANo&m=E0WqjfmlMSwjqdCHmmtS2iIjCXOzuA6gAxFA9NkglIE&s=Q8E_6WO-EN_HsgDYA33WgxKxSM0FuBKqDDc7jAmFHKo&e=



Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=WlnXFIBCT3pmNh_w8hYeLw&r=6OOMt7cyjnmO39KUoF9tSeArtMbDo7ylot2L9_W-ANo&m=E0WqjfmlMSwjqdCHmmtS2iIjCXOzuA6gAxFA9NkglIE&s=rC7S-Spor88-OFFwO-55wzn2qsUr7Sj_3jj_GVWHPDo&e=

2018 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----
------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this email in error,
please immediately notify the sender by e-mail at the address shown.
This email transmission may contain confidential information. This
information is intended only for the use of the individual(s) or entity to
whom it is intended even if addressed incorrectly. Please delete it from
your files if you are not the intended recipient. Thank you for your
compliance. Copyright (c) 2019 Cigna
==============================================================================

Jeff Yang

RE: Infosphere CDC
(in response to David Steibing)

For QREP, not sure if CDC has something similar.

 DB2 for z/OS describes the current version of the metadata of its tables andcolumns information in the SYSIBM.SYSTABLES and SYSIBM.SYSCOLUMNStables respectively. Since the Q Capture program might need to decode logrecords of DB2 data at earlier versions than the version (and metadata)described in the DB2 for z/OS catalog tables, the Q Capture program relies ontwo versioning tables to track the evolution of DB2 metadata over time. Theversioning tables allow the Q Capture process to decode older versions of beforeimage column values found in a DB2 log record.The two Q Capture versioning tables are the IBMQREP_TABVERSION and theIBMQREP_COLVERSION tables.The Q Capture program never prunes its versioning tables so you need tomanage them, as documented in the product online documentation.

 

IBM DB2 rocks !

Edited By:
Jeff Yang[Organization Members] @ Mar 08, 2019 - 11:34 AM (America/Mountain)