IBM 3090 CICS w/SunOS Sybase? 
Author Message
 IBM 3090 CICS w/SunOS Sybase?

We have a (potential) customer for our Sybase-based product
who has a project management system based in CICS on an IBM
3090 using VSAM files.  As you may guess from the density
of buzzwords in that sentence, I know next to nothing about
the IBM mainframe world (there are two types of programmers,
and I'm the type who has never even seen an IBM mainframe
except in the movies).  As I understand it, VSAM is the file
system and CICS is some sort of applications development
frontend environment.  Anyway, they have this "legacy" data
(I love that term) which they want our Sybase application to
be able to access *read/write*.

(a) Anyone doing anything like this?  How are you doing it?

(b) Anyone know enough about the Sybase products based on
    IBM to hazard a guess as to how you WOULD do it?  My
    first take to our salespeople is that you use the Open
    Server for CICS to write an application that makes the
    CICS data look like it's in a Sybase server to our
    application.  But what do you even write this Open
    Server application in?  COBOL?  And then what do you
    do in the Sun server?  Create views based on the data
    in the remote server?  Do RPCs?

Any help/guidance much appreciated.

--
--
Mike Kelly               Odesta Corporation, Northbrook, Illinois, USA
...!clout!odgate!mike    - Until odesta.com is registered.



Sat, 05 Aug 1995 03:41:01 GMT
 IBM 3090 CICS w/SunOS Sybase?

In comp.databases.sybase you write:

Quote:
>We have a (potential) customer for our Sybase-based product
>who has a project management system based in CICS on an IBM
>3090 using VSAM files.  As you may guess from the density
>of buzzwords in that sentence, I know next to nothing about
>the IBM mainframe world (there are two types of programmers,
>and I'm the type who has never even seen an IBM mainframe
>except in the movies).  As I understand it, VSAM is the file
>system and CICS is some sort of applications development
>frontend environment.  Anyway, they have this "legacy" data
>(I love that term) which they want our Sybase application to
>be able to access *read/write*.
>(a) Anyone doing anything like this?  How are you doing it?

I have been involved in a project where this was done.  My involvement
was on the front end side but I did get some exposure to the mainframe side.

Quote:
>(b) Anyone know enough about the Sybase products based on
>    IBM to hazard a guess as to how you WOULD do it?  My
>    first take to our salespeople is that you use the Open
>    Server for CICS to write an application that makes the
>    CICS data look like it's in a Sybase server to our
>    application.  But what do you even write this Open
>    Server application in?  COBOL?  And then what do you
>    do in the Sun server?  Create views based on the data
>    in the remote server?  Do RPCs?

At the site I was involved in they were using something called Sybase
database gateway for CICS.  The clients talked to a Sybase server on
a Sun via TCP/IP.  The Sun mapped sybase stored procedure calls to
mainframe RPC's.  These RPC's were done over the network to the mainframe
via LU 6.2.  On the mainframe side, each RPC is mapped to an IBM program
running in a CICS transaction.

The general structure then is to run sybase clients against IBM programs.
The benefit is that Sybase transactions are bound against mainframe programs
which can be written in COBOL and run against mainframe files.

The other option is to use a dynamic SQL gateway, but this will only work
if used against DB2 or some other mainframe relational system.

Hope that helps.  Let me know if you need more info.

Jeff

Quote:
>--
>Mike Kelly               Odesta Corporation, Northbrook, Illinois, USA
>...!clout!odgate!mike    - Until odesta.com is registered.


--



Sat, 05 Aug 1995 13:17:02 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ODBC to DB2 on IBM 3090

2. IBM 3090 TPC benchmarks

3. Processing speed on an IBM 3090. How fast using DB2?

4. TX-DALLAS-99395--TSO-JCL-CICS-IBM Utilities-DB2-ORACLE-DBA Skills-CASE Tools-SQL

5. TX-DALLAS-99395--TSO-JCL-CICS-IBM Utilities-DB2-ORACLE-DBA Skills-CASE Tools-SQL

6. NE-Omaha-99208--ORACLE-IBM-TSO-MVS-QMF-CICS-DB2-Senior Oracle DBA

7. NE-Omaha-99208--ORACLE-IBM-TSO-MVS-QMF-CICS-DB2-Senior Oracle DBA

8. TX-DALLAS-99395--TSO-JCL-CICS-IBM Utilities-DB2-ORACLE-DBA Skills-CASE Tools-SQL


 
Powered by phpBB® Forum Software