[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

619.0. "IMS-DB/CICS to Rdb?" by SAHQ::GREER () Thu Apr 12 1990 00:51

    IBM customer, running IMS-DB under CICS wants to look at relational
    technology and is willing to consider Digital due to good experiences
    with our OA and network products.  They asked me what tools we had to
    allow interoperability between their current environment and Rdb. 
    Also, they asked for a reference site which had implemented a similar
    scenario (Rdb w/ IMS-DB under CICS).
    
    I think our LU6.2 product would provide transaction level
    interoperability, but that is all I'm aware of.  Any suggestions?  Any
    references?
    
    Thanks again, Rusty.
T.RTitleUserPersonal
Name
DateLines
619.1FLASHSUBWAY::ROUTLEDGEThu Apr 12 1990 23:509
    
    	A product was developed in the New York Financial District called 
    FLASH that allows a user on a VAX to maintain an IMS database.  For
    info and a list of possible reference sites call
    	Don Labombard  DTN 352-2502 
    
    	I hope this helps!!
    
    Dennis Routledge  DTN 352-3073
619.2A list of alternatives31758::THOMASFri Apr 13 1990 03:4561
    We have a number of options available.  The best option is dependent
    on the customers needs.
    
    VAXlink can be used to extract data from an IMS database and load it
    into an Rdb database.  VAXlink provides a <relatively> easy-to-use
    menu driven interface to allow the user to select a database, a number
    of entities/records, and to specify selection criteria.  Once the data
    is selected, it is automatically downloaded and loaded into Rdb. 
    VAXlink does not support updates of the IBM data.  VAXlink is also a
    low volume tool.  It can transfer approximately 1.5 MB/hour.
    
    DTF (Data Transfer Facility) can be used to transfer data in either
    direction between VSAM and RMS files.  IBM offers a utility called
    DXT (Data Extract Tool) which can be used to extract data from IMS
    databases into VSAM files.  DTF can transfer an entire file, or it
    can access a single record from the file -- both read and write.
    And look for a SQL interface to DTF sometime in the future.  I'm not
    sure of this figure, but I think that DTF can transfer approximately
    6-8 MB/minute.
    
    If your customer wishes to build new applications on the VAX which 
    will update the IMS environment, then you'd have to recommend using
    a peer-to-peer application communications programming interface.
    i.e.  the customer will have to develop cooperating applications which
    communicate across an SNA Gateway.  We offer 3 different programming
    interfaces, one for each type of SNA logical unit communications 
    protocols.  
    1- DECnet/SNA VMS API -- it uses the LU0 protocol.  LU0 is very fast
       but very difficult to program.
    2- DECnet/SNA VMS 3270 Data Stream PI -- it uses the LU2 protocol,
       basically sending 3270 terminal screens back and forth.  It's very
       easy to program, it allows you to talk directly to existing CICS
       applications, but the data transfer rate is very slow.
    3- DECnet/SNA VMS APPC/LU6.2 PI -- it uses the LU6.2 protocol, IBM's
       strategic communications protocol, designed specifically for
       application peer-to-peer communications (APPC).  It is much easier
       to program than LU0, and works almost as quickly.  It can transfer
       data approximately 100 times faster that 3270 Data Stream (LU2).
    
    I recommend using LU6.2, although don't rule out LU2.  LU2 could save
    lots of time if you can make use of existing CICS applications.  Just
    don't attempt to use LU2 to transfer 10 gigabytes of data every day.
      
    The FLASH Programming Interface (FPI) does not apply in this situation.
    FLASH provides peer-to-peer communications between VAX applications and
    IMS-DC applications using the LU0 protocol (it's layered on the API).  
    FLASH makes API much easier to program, but FLASH requires IMS-DC.  You 
    have specified that the customer is using CICS.  FLASH is an excellent
    alternative to LU6.2 in the IMS-DC environment (IMS-DC does not support
    LU6.2). 
    
    For more information on interoperability tools, contact me, or look at
    a few of our notes files:
    
    CREDIT::VIDA_DB2   (interoperability with DB2)
    CREDIT::VIDA       (interoperability with IDMS/R)
    JOVIAL::VAXLINK    (extraction from IMS and VSAM)
    SMAUG::SNAGWY      (SNA Gateways)
    
    Anne Thomas
    DBS Interoperability Product Manager
619.3FLASH won't work in this case31758::THOMASFri Apr 13 1990 03:474
    Just wanted to clarify...
    
    FLASH does not work in a CICS environment.
    
619.4THANKS!SAHQ::GREERFri Apr 13 1990 22:577
    Anne,
    	Thanks for your extensive and elightening answer.  I'll definitely
    communicate the info to the customer and see what they want/need next. 
    I have a feeling some reference sites would be useful--but I'll verify
    and get back to you with specifics if that need is voiced.
    
    Rusty.
619.5Need more informationTAV02::ARIE_LArie LevyThu Jun 21 1990 12:077
Anne,

Is FLASH a Product ? Assets ? How can we get more technical information?

Thanks,

Arie Levy