List of Contributions

Robert Philo

Contact Details

My Content

1 to 20 of 50+ total
Posted By Robert Philo Wed November 22, 2023 09:13 AM
Found In Egroup: Data Integration
\ view thread
Hello Bujji I think you need to work with an IBM representative who deals with the customer in question to plan a Proof of Concept or similar. There is no site where you can simply download the software without an IBM customer ID and some form of entitlement to the software ------------------------------ ...
Posted By Robert Philo Tue August 22, 2023 08:30 AM
Found In Egroup: Data Integration
\ view thread
Hello Guy If DB2 is the target and some other database is the source, I don't think you need to take any action with mark table capture point, as this is only done on the source. What the CDC documentation should be saying, I believe, is that if your DB2 database is the source, you need to ...
Posted By Robert Philo Wed February 22, 2023 10:14 AM
Found In Egroup: Data Integration
\ view thread
Hello Guy mark table capture point is only done for the source tables. Use with care as any outstanding changes to be replicated, in the log from before the mark point will be skipped unless you also do dmsetbookmark. ------------------------------ Robert Philo --------------- ...
Posted By Robert Philo Wed February 22, 2023 10:11 AM
Found In Egroup: Data Integration
\ view thread
Hello Guy The undocumented dmmdcommander command can be used to open a read-only connection to the metadata database. dmmdcommander -I This opens a CLI in which you can run SQL select commands and some other commands to set some options. All commands are terminated with a semi-colon ...
Posted By Robert Philo Sun February 12, 2023 10:30 AM
Found In Egroup: Data Integration
\ view thread
Hello I got a message that someone posted a new query as an answer to an existing issue. I cannot find this post. So to answer I have created a new thread, which should be done anyway as this issue is not related to the original post. The original said: " We are using the IBM CDC ...
Posted By Robert Philo Wed February 08, 2023 10:25 AM
Found In Egroup: Data Integration
\ view thread
Yes, that is correct ------------------------------ Robert Philo ------------------------------
Posted By Robert Philo Wed February 08, 2023 09:55 AM
Found In Egroup: Data Integration
\ view thread
Guy The TS_BOOKMARK table in the target database is the definitive version of the subscription bookmarks. It has all the information required for subscription restart. Therefore there is no requirement to save off the bookmark unless you need an arbitrary recover point. So when you restart from ...
Posted By Robert Philo Tue February 07, 2023 09:59 AM
Found In Egroup: Data Integration
\ view thread
Guy. What is your target? If it is a database target the TS_BOOKMARK in the target is updated in the database in the same unit of work as the replicated log entries and if the target database is replicated in some way to the standby then the TS_BOOKMARK in the target database will automatically reflect ...
Posted By Robert Philo Tue February 07, 2023 05:09 AM
Found In Egroup: Data Integration
\ view thread
Guy Yes. most target databases will allow you to map a table without a unique key. Ultimately if there is no key then CDC would do a search by all searchable columns. Some databases will allow a search on null columns, but that would be implicitly taken care of. So yes you can have duplicates in ...
Posted By Robert Philo Thu January 26, 2023 12:08 PM
Found In Egroup: Data Integration
\ view thread
Daniel As far as I know there is only one ts.jar, I would raise a case as this is something that IBM is shipping Regards Robert ------------------------------ Robert Philo ------------------------------
Posted By Robert Philo Thu January 26, 2023 12:06 PM
Found In Egroup: Data Integration
\ view thread
Daniel Thanks for informing me of the issue with RGZPFM and the PTF ------------------------------ Robert Philo ------------------------------
Posted By Robert Philo Mon January 23, 2023 09:54 AM
Found In Egroup: Data Integration
\ view thread
Daniel The scraper has to process all the entries in the journal receivers to determine if an particular entry is in scope. All the message is doing is telling you which journal entry the scraper was processing when some error (possibly unrelated to the journal entry) occurred on the source or ...
Posted By Robert Philo Thu December 08, 2022 11:27 AM
Found In Egroup: Data Integration
\ view thread
The remote DB2/z engine is source only, this is the major feature difference, so in a bi-directional topology, you would have to use the native CDC DB2/z engine. For licencing you should speak to your account manager Regards Robert ------------------------------ Robert Philo -------- ...
Posted By Robert Philo Wed December 07, 2022 01:23 PM
Found In Egroup: Data Integration
\ view thread
Guy This is normal. A subscription requires four ports between the source and target. By default there will be various ports on the source allocated dynamically all communicating with the target listener port. The Access Server will also have multiple ports open to the source agent and to the target ...
Posted By Robert Philo Tue September 27, 2022 10:52 AM
Found In Egroup: Data Integration
\ view thread
Anuar So to be clear here, the LiveAudit subscription is OK and the standard/adaptive apply one is failing. I can see that the source and target table definitions match in critical points for this issue. I assume that the columns in the primary key constraint definition are correctly mapped. ...
Posted By Robert Philo Tue September 27, 2022 05:16 AM
Found In Egroup: Data Integration
\ view thread
Hello Anuar Please post the definitions of the source and target tables I assume that you are using standard replication or adaptive apply as a fall-back option. I don't see the relevance of the transaction time, or the SCN unless you are using LiveAudit mapping type. Thanks Robert ...
Posted By Robert Philo Mon September 26, 2022 07:59 AM
Found In Egroup: Data Integration
\ view thread
Hello Assuming that you have not manually updated the bookmarks and processed the some log entries twice, you are getting unique constraint violations on the target apply because what is unique on the source is not unique on the target for any of the following reasons: 1) There are unique constraints ...
Posted By Robert Philo Thu August 04, 2022 12:31 PM
Found In Egroup: Data Integration
\ view thread
Daniel I would go to IBM Fix Central and download the latest build. 5344 is very old. Did you open a case? Regards Robert ------------------------------ Robert Philo ------------------------------
Posted By Robert Philo Wed August 03, 2022 01:07 PM
Found In Egroup: Data Integration
\ view thread
Daniel The first step is to add more tracing to the dmconfigurets tool itself. Once way of doing this is as follows: 1. Take a backup of \conf\dmts64.vmargs file. 2. Edit "dmts64.vmargs" file, to insert in front of existing text the following -Dcom.datamirror.trace.on=true -Dcom.datam ...
Posted By Robert Philo Tue July 19, 2022 12:48 PM
Found In Egroup: Data Integration
\ view thread
Hello Daniel Thanks for the update. It is usually suggested that a user profile used to start replication has a storage limit of *NOMAX defined to avoid this sort of issue. I always recommend that the user defined in the datastore connection credentials is specifically created for this purpose ...