Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] CDC performance and requirement

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] CDC performance and requirement
 Login/Join
 
nox
Platinum Member
posted
Hi,

I have a DB2 locate in IBM z/OS platform for online transaction, want to use iWay DataMigrater tool to transform data into Linux DB2 and same time using CDC to know any table that is IUD(Insert/Update/Delete).
Current tables in DB2 are around 500, approximately around 1TB of total size.
Here is my questions:
1. For the initial load from source tables(500 tables) do I need to be offline the DB2 from transaction? or I can get every data as current state of data as User's manual mention?

2. Any system/hardware recommendation for CDC usage for 500 tables?

Thanks,

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS v8.2.06 , Windows
 
Posts: 137 | Registered: August 29, 2019Report This Post
Marina
Silver Member
posted Hide Post
Hello,
1. You should be able to run a flow with initial load to "get every data as current state of data".
2. Could you please open a Hottrack case and provide the details about your environment and requirements? For example, one of the details about the requirements that we'd like to know is: what is the naming convention for the tables and synonyms names on the target system.

Thank you.
 
Posts: 37 | Registered: February 13, 2007Report This Post
nox
Platinum Member
posted Hide Post
Hi,

Thank you Maria for your reply, about the requirement I need to be more detail information from user, so i can get back to you. For all I know now is to transform DB2's tables from z/OS into Linux OS as DB2 via iWay DataMigrater.

To continue my question:
1. never done this large amount of table before, not sure how long it take for do initial load? and suppose it take 30min. to complete the load, after 30min. will use CDC to track 30min. data, assume the target will get the data after 30min. but using CDC to tack back 30min. might getting few data repeatedly, which is wrong for the table's data. Or should I offline these table till it's complete?

2. CDC is base on collecting DB's log to do IUD into the target, what if DBA decide to use massive IUD or 'TRUNCATE TABLE' to avoid getting logs, from this point should we re-do initial load again? since there is no logs to identify where source table has been change?


WebFOCUS v8.2.06 , Windows
 
Posts: 137 | Registered: August 29, 2019Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] CDC performance and requirement

Copyright © 1996-2020 Information Builders