-
1. Re: Creating datamaps in bulk
Tamil Dhanabalan Jul 19, 2020 10:13 PM (in response to Padmanabha G)Dan Smith from PWX team has responded with some useful information some time ago. I am not sure whether it applies to Z OS.
create the powerexchange datamap using UNIX command
For PWX CDC for Z/OS 10.4.1,
createdatamaps - Data Map Creation Utility
I hope Dan responds to this with some recommendation for Mainframes Z/OS.
Is there a utility or way to do these bulk creation for Z/OS DB2 tables ?
-
2. Re: Creating datamaps in bulk
dan.smith@informatica.com Jul 20, 2020 7:15 AM (in response to Tamil Dhanabalan)Unfortunately, createdatamaps is the way to do this.
We had not envisioned thousands of data maps being required.
You may want to reach out to Phil Line (pline@informatica.com), the Director of PWX Product Management, to add this as a future requirement.
-
3. Re: Creating datamaps in bulk
Tamil Dhanabalan Jul 20, 2020 8:33 AM (in response to dan.smith@informatica.com)Will do Dan. Thanks for sharing the contact details!
-
4. Re: Creating datamaps in bulk
dan.smith@informatica.com Jul 20, 2020 11:15 AM (in response to Tamil Dhanabalan)1 of 1 people found this helpfulCapture Registrations and Extraction Maps are not the same as DataMaps.
Data Maps are used for accessing non-relational sources, such as IMS, VSAM, or sequential files, which is what I understood you to be doing when you mentioned "mainframe files".
Data Maps are not used for accessing Oracle, and are almost never used when accessing DB2. They are not used for either with CDC.
If what you are looking for is a batch utility for creating Capture Registrations and Extraction Maps, that already exists. Please refer to the DTLUCBRG chapter in the PWX Utilities Guide.
-
5. Re: Creating datamaps in bulk
Tamil Dhanabalan Jul 21, 2020 9:49 AM (in response to dan.smith@informatica.com)Thanks dan.smith@informatica.com !
In case of DTLUCBRG, can we use our windows laptops to create registration maps and extraction maps on mainframe Z/OS DB2 environment using the Location parameter?
Please share if there are some limitations.
-
6. Re: Creating datamaps in bulk
dan.smith@informatica.com Jul 21, 2020 9:58 AM (in response to Tamil Dhanabalan)I think you have to run CBRG on z for z sources.
But I could be wrong.
I would recommend raising a support ticket and asking.
-
7. Re: Creating datamaps in bulk
Andy Bristow Jul 21, 2020 11:05 AM (in response to Tamil Dhanabalan)Yes you can. The location references the location of the PWX listener in the Z mainframe and can run on windows.
-
8. Re: Creating datamaps in bulk
Tamil Dhanabalan Jul 21, 2020 11:24 AM (in response to Andy Bristow)Thanks Andy!
-
9. Re: Creating datamaps in bulk
Padmanabha G Jul 21, 2020 9:12 PM (in response to Tamil Dhanabalan)Thank you all for your comments.
Yes,I was referring to sequential and VSAM files and looking for datamaps creation in bulk.
Will look into the createdatamap utility
Thanks