Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation
As of today our CA OPS/MVS product, that runs on Mainframe systems under z/OS Operating Systems, does not have a direct interface with CA Process Automation. I have briefly looked at the Database prerequisites in which it can store persist data and the list of the available options are not supported by CA OPS/MVS :
Can you please share with us what is your final objective with the database update?
Perhaps we can provide you a solution, using another tool that runs under the same platform where CA Process Automation does, that can also interact with CA OPS/MVS in case an event originated in the Mainframe requires an update in CA Process Automation. Does this sounds like something might help you with your project?
Not sure if John is using CA Automation Point at his site, but, in theory, he could send the SQL UPDATE query to an AP PPQ using the OPS/MVS ADDRESS AP PPQ-WRITE command, AP can receive the SQL UPDATE query and kick off a REXX that feeds the query to the Rexx/SQL interface to update John's CA Process Automation tables......
John, if you feel CA Automation Point could be a possible solution for you then let us know.
Thanks Stephen, but we do not have Automation Point at our site.
Cesar, regarding your question "Can you please share with us what is your final objective with the database update?". We are looking into creating reports on messages that we issue via OPSMVS, how many on a daily basis, peak periods, severity of the messages, etc. With more measurements to follow on other aspects of what we do via OPSMVS.
We have found a way via CA ESP that we have at our site, and will be able to make our updates that way. It is too bad that we do not have the possibility to have a "direct link" to CA Process Automation. One CA product being able to talk directly to another.
Glad to hear you have a workaround using CA ESP. As we have made efforts to expand CA OPS/MVS reach out Distributed Systems there is not direct link with CA Process Automation at this time.
Thanks for opening this thread John