topic Re: COBOL and Oracle in Operating System - OpenVMS

COBOL and Oracle

Alberto Rua — Fri, 16 May 2008 17:15:07 GMT

IS POSSIBLE DO DATA REPLICATIONG OR MIRRORING USING COBOL MVS?

Re: COBOL and Oracle

Hoff — Fri, 16 May 2008 17:55:09 GMT

IBM MVS? Donno. Ask IBM.

Assuming you meant COBOL on OpenVMS...

Host-based volume shadowing (HBVS; also known as disk mirroring) and controller-based RAID, both occur underneath the level of COBOL and other such activity. Both HBVS and RAID are available on OpenVMS. And both can be used with COBOL applications.

If you're looking for transaction-oriented processing for recovery or replication, My recollection is that COBOL does not offer that within the language itself, though you can use RMS Journaling and other OpenVMS-related data services in conjunction with COBOL code. You can call these and other OpenVMS services from your COBOL code.

Calls into most SQL and non-SQL databases can also be configured to provide transactional and data replication processing.

What OpenVMS version?

What OpenVMS platform?

What COBOL?

What particular problem are you looking to solve, or what failures are you seeking to defend against?

Re: COBOL and Oracle

Alberto Rua — Mon, 19 May 2008 15:41:20 GMT

Sorry, is HP COBOL ON OPEN VMS AND ORACLE DBMS. COULD YOU GIVE ME MORE DETAILS ABOUT USING CODE?

Re: COBOL and Oracle

Hoff — Mon, 19 May 2008 19:11:30 GMT

Oracle Corporation (http://www.oracle.com) has an on-line support facility called Metalink, which allows you to access the documentation and example code for Oracle's database products.

Your question appears to an Oracle question -- I'm assuming you already know how to program COBOL -- and not really a COBOL question nor an OpenVMS question. You want to know how to use Oracle to replicate data.

If you're just getting going with Oracle, you'll want to start over in Metalink, and particularly with the Oracle documentation.

Now if you're seeking to replicate data using host-based volume shadowing (HBVS; host-based disk mirroring) or controller-based RAID (controller-based disk mirroring), that's basically transparent to the COBOL code.

Re: COBOL and Oracle

Alberto Rua — Sat, 24 May 2008 14:21:26 GMT

Could you explain more about how replicate data using host-based volume shadowing (HBVS; host-based disk mirroring) or controller-based RAID (controller-based disk mirroring. Thanks.

Re: COBOL and Oracle

John Gillings — Sun, 25 May 2008 21:28:00 GMT

Alberto,

>how replicate data using host-based
>volume shadowing

There's a whole manual "Volume Shadowing for OpenVMS". It's far too big (and critical) a subject to give a useful summary in this form. Exactly what and how you do it depends on your objectives and constraints. Please see the documentation: http://h71000.www7.hp.com/doc/732FINAL/aa-pvxmj-te/aa-pvxmj-te.HTML

>controller-based disk mirroring

That will depend on your controller. Again, you need to read the documentation.