| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 627.1 | Yes, But... | BANZAI::BOOTH | What am I?...An Oracle? | Wed Apr 25 1990 15:16 | 9 |
| For the record, Oracle can only update the DB2 database IF the Oracle
RDBMS is installed on the IBM side. That is, the update goes Oracle/VAX
to Oracle/IBM, then Oracle/IBM to DB2.
I think Ingres is read/write to DB2. However, as I understand it, any
write from the VAX side gives the IBM DBA some real grief if a system
crash occurs. Recovery would not be simple.
---- Michael Booth
|
| 627.2 | Focus & Sterling perhaps | MAIL::DUNCANG | Gerry Duncan @KCO - DTN 452-3445 | Fri Apr 27 1990 14:06 | 9 |
| Check with Focus. They claim to be able to read/write to DB2 but I'm
not clear on whether or not ANY application (or just Focus
applications) can use their software.
Also, you may want to check with Sterling software (authors of the IBM
side of VAXlink). They may have something but it will probably be
batch oriented.
-- gerry
|
| 627.3 | More on ORACLE and INGRES | SQLRUS::THOMAS | | Mon Apr 30 1990 19:14 | 9 |
| Just to add a little more info to Mike's reply --
ORACLE's SQL*Connect does support update of DB2 databases, under 2
conditions: ORACLE DBMS must be installed on the IBM system, AND
the DB2 table must be varied offline to DB2 users until the ORACLE
update is committed.
The current version of the INGRES gateway to DB2 does not support
update.
|
| 627.4 | Let IBM do it | IJSAPL::OLTHOF | Henny Olthof @UTO 838-2021 | Fri May 04 1990 09:25 | 6 |
| If updating a DB2 database from an Rdb database is the issue and it
does not need to be online, IBM offers products that will read Rdb data
into a DB2 database (check with other notes for the product name).
Henny
|
| 627.5 | Methods that can update IBM | SQLRUS::THOMAS | | Tue May 08 1990 01:29 | 16 |
| We have a number of mechanisms to allow VAX/VMS applications to update
IBM data:
1. Use RJE to transfer a transaction to the IBM. RJE will schedule to
job to update the database of choice.
2. Write cooperative applications using DECnet/SNA VMS APPC/LU6.2 PI.
An application on the VAX initiates a conversation with an
application running in CICS. The CICS application can perform the
updates.
3. Write applications to interface with existing IBM applications
using DECnet/SNA VMS 3270 Datastream PI. The VMS application
passes 3270 screens of data to an IBM-based application.
4. Use DTF to transfer files to the IBM system, then execute an IBM
application to read the data and update the databases.
5. Use IBM's DXT/D1 to extract data from VAX/VMS-based databases
(Rdb, RMS, or ORACLE) and create DB2 or SQL/DS tables.
|