CA OPS/MVS

Expand all | Collapse all

Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation

Jump to Best Answer
  • 1.  Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation

    Posted 09-20-2016 12:06 PM

    Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation



  • 2.  Re: Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation
    Best Answer

    Posted 09-20-2016 03:53 PM

    Hello John,

     

    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 :

     

    • MySQL 5.5
    • Microsoft SQL Server 2005, 2008, 2008 R2, and 2012
    • Oracle Database 10g Release 2 and Oracle Database 11g Release 2

     

    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?

     

    Regards, Cesar



  • 3.  Re: Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation

    Posted 09-22-2016 09:42 AM

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



  • 4.  Re: Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation

    Posted 09-23-2016 11:35 AM

    Thanks Stephen

    John, if you feel CA Automation Point could be a possible solution for you then let us know.

    Regards, Cesar



  • 5.  Re: Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation

    Posted 09-30-2016 02:40 PM

    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.



  • 6.  Re: Am looking to see if it is possible for OPS/MVS to update SQL tables in CA Process Automation

    Posted 09-30-2016 04:45 PM

    Hello John,

     

    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

    Regards, Cesar