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

dan.smith@informatica.com

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 ?

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.

Will do Dan. Thanks for sharing the contact details!

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

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.

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.

Yes you can.  The location references the location of the PWX listener in the Z mainframe and can run on windows.

Thanks Andy!