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.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


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