SQLNET at F Hemmer Computers Cray XMP 48

  • Slides: 13
Download presentation
SQL*NET at F. Hemmer

SQL*NET at F. Hemmer

Computers • Cray X/MP 48 (Uni. COS) • IBM 3090/600+6 VF (VM/XA) • Siemens

Computers • Cray X/MP 48 (Uni. COS) • IBM 3090/600+6 VF (VM/XA) • Siemens 7890 (VM/HPO) • 200 VAXes, µVAXes and Vax. Stations (VMS) • 30 VAXes, µVAXes and VAXStations (Ultrix) • 150 Apollos • 10 Suns • 1000 IBM PC's (DOS, Xenix) • 1200 Macs (Mac. OS)

Protocols • TCP/IP, UDP/IP • Decnet • VTAM, SNA • SPX/IPX • Appletalk

Protocols • TCP/IP, UDP/IP • Decnet • VTAM, SNA • SPX/IPX • Appletalk

SQL*NET Topology IBM 3090/600 6 VF - VM/XA 3725 SNA (LU 6. 2) CTC

SQL*NET Topology IBM 3090/600 6 VF - VM/XA 3725 SNA (LU 6. 2) CTC VTAM 3732 8232 Decnet . . . IP Central VAX/VMS Cluster LEP LAVC Ultrix IBM PC Mac Apollo RT PC Fastpath Novell Sun Siemens 7890 S VM/HPO IBM PC IBM PC Mac Mac Mac Apollo

PC's and MAC's • Single user operating system • Monotasking operating system • Limited

PC's and MAC's • Single user operating system • Monotasking operating system • Limited (expensive) disk space availabililty • Usually no native networking • Availability of resource sharing systems • Very good dedicated user interface

Workstations • Multitasking operating system • Multiuser operating system • Higher disk space availability

Workstations • Multitasking operating system • Multiuser operating system • Higher disk space availability • Native networking • Resource sharing by means of standards • Good (distributed) windowing interface • A lot of CPU dedicated to the user interface

Mainframes • Multitasking operating system • Multiuser time-shared operating system • High (cheap) disk

Mainframes • Multitasking operating system • Multiuser time-shared operating system • High (cheap) disk space availability • No native multi-vendor networking • Resource sharing by means of standard protocols • Weak user interface • Little CPU used for the user interface

The LEP Control System SPS LEP Domain Lab and offices PCR Dev Computer Centre

The LEP Control System SPS LEP Domain Lab and offices PCR Dev Computer Centre Pbar

Software Architecture IBM RT PC Apollo IBM PC/AT PCA Application RPC client SQL*Net RPC

Software Architecture IBM RT PC Apollo IBM PC/AT PCA Application RPC client SQL*Net RPC Servers Application Servers SQL*Net Data. Base Server SQL*Net Oracle Server

SQL*NET Topology IBM 3090/600 6 VF - VM/XA 3725 SNA (LU 6. 2) CTC

SQL*NET Topology IBM 3090/600 6 VF - VM/XA 3725 SNA (LU 6. 2) CTC VTAM 3732 8232 Decnet . . . IP Central VAX/VMS Cluster LEP LAVC Ultrix IBM PC Mac Apollo RT PC Fastpath Novell Sun Siemens 7890 S VM/HPO IBM PC IBM PC Mac Mac Mac Apollo

Problems • Client only installations • Versions • Monitoring • Homogeneity • Remote IOR

Problems • Client only installations • Versions • Monitoring • Homogeneity • Remote IOR

Performance ms Decnet Tcp/Ip Local KB

Performance ms Decnet Tcp/Ip Local KB

Conclusions • Availability • Perfomance • Better use of computers • Client only installations

Conclusions • Availability • Perfomance • Better use of computers • Client only installations • Distributed Oracle not yet mature