Software Product Description ___________________________________________________________________ PRODUCT NAME: DEC DB Integrator Gateway SPD 63.35.02 for SequeLink[R], Version 3.1A DESCRIPTION DEC DB Integrator Gateway for SequeLink (SequeLink Gateway) provides applications and tools with direct, read/write access to data sources served by Version 2.5 or higher SequeLink servers. This access can be via interactive or dynamic SQL interfaces. Client/server access is en- abled by drivers for Microsoft[R] Open Database Connectivity (ODBC) applications. Optional support for embedded SQL and SQL module lan- guage programming is available. DEC DB Integrator (DBI) extends the functionality of the SequeLink Gate- way by providing a native integration of databases accessed by SequeLink Gateways and other DB Integrator gateways. DBI clients may directly access and join views of tables existing on multiple databases. These views may be horizontally or vertically partitioned and be based on tables existing on any database accessible by these gateways. DBI views may be pre-defined or dynamically declared. DBI servers maintain a persistent catalog of metadata extracted from databases served by SequeLink servers. DBI uses this metadata along with information on network and underlying database manager capabil- ities to optimize cross-database joins. The SequeLink Gateway is available on the Digital UNIX[R] Operating System on AXP systems, workstations and servers and on the OpenVMS Op- erating System on Digital AXP and VAX systems, workstations and servers. Features Standard SQL Interfaces DIGITAL July 1995 AE-QD92B-TE DEC DB Integrator Gateway SPD 63.35.02 for SequeLink[R], Version 3.1A The SequeLink Gateway provides direct, read/write access to SequeLink data sources through standard DEC SQL interfaces. These interfaces in- clude a dynamic SQL interface, an interactive SQL facility and the SQL/Services server. SQL data manipulation language (DML) is fully supported. SQL data def- inition language (DDL) support is limited to operations required to create and maintain tables and indexes and to grant and revoke access to database objects. The dynamic SQL interface compiles and executes SQL requests passed through its call interface. This programming approach is highly ef- fective in applications such as ad-hoc query access where the exact parameters of requests are not known until runtime. It is compatible with any programming language that supports the operating system's call- ing standards. The dynamic memory handling capabilities of Ada, C and PL/I enable these languages to take full advantage of the power and flexibility of this approach. The interactive SQL facility supports interactive query and update of data and management of table and view metadata in databases accessed via SequeLink servers. All required data format translations are per- formed automatically as part of handling requests to read and update data accessed by SequeLink servers. SequeLink Server Support The SequeLink Gateway provides access to information in CA-INGRES[R], INFORMIX-Online[R], INFORMIX-SE[R], ORACLE[R], IBM[R] DB2[TM] MVS IBMDB2/2 IBMDB2/400 and IBM DB2/6000 databases through the SequeLink servers for those databases. Connectivity to a specific SequeLink server de- pends on the existence of a common network transport between the Se- queLink server platform and the SequeLink Gateway platform. 2 DEC DB Integrator Gateway SPD 63.35.02 for SequeLink[R], Version 3.1A Disk Space Requirements Table 1 lists the disk space required to install and operate SequeLink Gateway software by hardware/operating system platform (Platform). The common requirement represents the space required to store software ob- jects that are common to DBI and the DB Integrator family of gateways. If one of these products is already installed on the system or clus- ter, the disk space requirement will be decreased by this amount. ___________________________________________________________________ Table_1:__Disk_Space_Requirements_by_Platform______________________ Disk Space Required (512 Byte Blocks) Platform_______Install_____Permanent____Common_____________________ OpenVMS VAX 35,700 35,300 28,000 OpenVMS AXP 50,000 49,300 39,000 Digital_UNIX___77,060______77,060_______73,260_____________________ These counts refer to the disk space required on the system disk. The sizes are approximate; actual sizes may vary depending on the user's system environment, configuration, and software options selected. Additional space must be allowed for programs, logs, temporary database cache files and user interface software. CLUSTER ENVIRONMENT This product is fully supported when installed on any valid and li- censed VAXcluster or VMScluster configuration. These configurations are described in the VAXcluster SPD (SPD 29.78.xx), and the VMScluster SPD (SPD 42.18.xx). 3 DEC DB Integrator Gateway SPD 63.35.02 for SequeLink[R], Version 3.1A SERVER SOFTWARE REQUIREMENTS This section lists the software required to install and operate the SequeLink Gateway. Support of DEC ODBC Driver for MS Windows and DEC ODBC Driver for Windows NT client applications may require additional software. With the re- quired software, all SequeLink gateways support access via DECnet and TCP/IP transports. In addition, the SequeLink Gateway on the OpenVMS VAX platform may be accessed through the Novell NetWare (IPX/SPX) trans- port. SequeLink Gateway OpenVMS VAX Server Software Requirements o OpenVMS VAX Operating System V5.5-2 - V6.2 o DEC TCP/IP Services for OpenVMS VAX, V3.0 - V3.1[2] o A Version 2.5 SequeLink server on the gateway platform or acces- sible via a common network and protocol Network Transport Options The SequeLink Gateway for OpenVMS VAX will require one or more of the following network software products to support direct access to lo- cal and remote databases by SQL/Services SQL Multimedia and DEC ODBC Driver for MS Windows desktop applications. o DECnet transport - DECnet for OpenVMS VAX, V5.5-2 - V6.1 o TCP/IP transport - DEC TCP/IP Services for OpenVMS VAX, V3.0 - V3.1 ____________________ [2] Attaches to a remote SequeLink server require common network pro- tocol support on both the system running DEC DB Integrator Gateway for SequeLink and the remote system running the SequeLink server 4 DEC DB Integrator Gateway SPD 63.35.02 for SequeLink[R], Version 3.1A o Novell NetWare - SQL/Services and DEC ODBC Driver client applica- tions communicating via Novell NetWare[R] require a Novell IPX/SPX transport - InterConnections Leverage for NetWare File Sharing Ser- vices (FSS), V1.5 - V2.0 SequeLink Gateway OpenVMS AXP Server Software Requirements o OpenVMS AXP Operating System V6.1 - V6.2 o One of the following network transports[2] - DEC TCP/IP Services for OpenVMS AXP, Version 3.0 - 3.1 - DECnet SNA APPC/LU6.2 for OpenVMS, V2.2 o A Version 2.5 SequeLink server on the gateway platform or acces- sible via a common network and protocol Network Transport Options The SequeLink Gateway for OpenVMS AXP will require one or more of the following network software products to support direct access to lo- cal and remote databases by SQL/Services SQL Multimedia and DEC ODBC Driver for MS Windows desktop applications. o DECnet transport - DECnet for OpenVMS AXP, V6.1 - V6.2 o TCP/IP transport - DEC TCP/IP Services for OpenVMS AXP, V3.0 - V3.1 SequeLink Gateway Digital UNIX Server Software Requirements o Digital UNIX Operating System, V3.0, V3.2 o TCP/IP Services[2] (Included with the Digital UNIX Operating System) o A Version 2.5 SequeLink server on the gateway platform or acces- sible via a common network and protocol 5 DEC DB Integrator Gateway SPD 63.35.02 for SequeLink[R], Version 3.1A Network Transport Options The SequeLink Gateway for Digital UNIX will require one or more of the following network software products to support direct access to lo- cal and remote databases by SQL/Services SQL Multimedia and DEC ODBC Driver for MS Windows desktop applications. o DECnet transport - DECnet/OSI, Version 2.0, for Digital UNIX o TCP/IP transport - Included with the Digital UNIX Operating Sys- tem ORDERING INFORMATION DEC DB Integrator Gateway for SequeLink for OpenVMS VAX Traditional Software Licenses: QL-3E1A*-** Concurrent Use Licenses: QL-3E1AA-3* Software Documentation: QA-3E1AA-GZ Software Product Services: QT-3E1A*-** Software Media: QA-3E1**-H* (TK, Mag Tape, CD) Software Media: QA-VWJ8A-H8 (Consolidated CD) DEC DB Integrator Gateway for SequeLink for OpenVMS AXP Traditional Software Licenses: QL-3E2A*-** Concurrent Use Licenses: QL-3E1AA-3* Software Media and Doc: QA-03XAA-H8 Software Documentation: QA-3E1AA-GZ Software Product Services: QT-3E0A*-** Software Media: QA-3E2**-H* (CD-ROM) Software Media: QA-03XAA-H8 (Consolidated CD) DEC DB Integrator Gateway for SequeLink for Digital UNIX Traditional Software Licenses: QL-3E0A*-** Concurrent Use Licenses: QL-3E0AM-3* Software Documentation: QA-3E1AA-GZ Software Product Services: QT-3E0A*-** 6 DEC DB Integrator Gateway SPD 63.35.02 for SequeLink[R], Version 3.1A Software Media: QA-3EO**-H* (CD-ROM) Software Media: QA-054AA-H8 (Consolidated CD) * Denotes variant fields. For additional information on available li- censes, services, and media, refer to the appropriate price book. SequeLink Servers SequeLink servers from TechGnosis are available through Digital. ___________________________________________________________________ Table_2:__SequeLink_Servers________________________________________ Part Operating Number_________RDBMS_____________________System____________________ QB-3FAAA-W* INFORMIX-Online SunOS[TM] QB-3FAAB-W* INFORMIX-Online Solaris[R] QB-3FAAC-W* INFORMIX-Online IBM AIX[R]/RISC QB-3FAAD-W* INFORMIX-Online HP-UX[R]/RISC QB-3FAAE-W* INFORMIX-Online Digital UNIX QB-3FBAA-W* INFORMIX-SE SunOS QB-3FBAB-W* INFORMIX-SE Solaris QB-3FBAC-W* INFORMIX-SE IBM AIX/RISC QB-3FBAD-W* INFORMIX-SE HP-UX RISC QB-3FBAE-W* INFORMIX-SE Digital UNIX QB-3FVAA-W* INGRES SUN OS QB-3FVAB-W* INGRES Solaris QB-3FVAC-W* INGRES AIX QB-3FVAD-W* INGRES HP-UX QB-3FVAE-W* INGRES Digital UNIX QB-3FVAF-W* INGRES OpenVMS AXP QB-3FVAG-W* INGRES OpenVMS VAX QB-3FDAA-W* ORACLE SunOS 7 DEC DB Integrator Gateway SPD 63.35.02 for SequeLink[R], Version 3.1A ___________________________________________________________________ Table_2_(Cont.):__SequeLink_Servers________________________________ Part Operating Number_________RDBMS_____________________System____________________ QB-3FDAB-W* ORACLE Solaris QB-3FDAC-W* ORACLE IBM AIX/RISC QB-3FDAD-W* ORACLE HP-UX RISC QB-3FDAE-W* ORACLE Digital UNIX QB-3FDAF-W* ORACLE OpenVMS AXP QB-3FDAG-W* ORACLE OpenVMS VAX QB-3FDAH-W* ORACLE OS/2[R] QB-3FFAA-W* DB2/6000 IBM AIX/RISC QB-3FGAA-W* DB2 IBM MVS QB-3FEAA-W* DB2/2 IBM OS/2 QB-3FHAA-W*____DB2/400___________________IBM_OS/400________________ The (*) character in part numbers that identify SequeLink servers varies by the number of users licensed. The correlation of this character to the number of users is as follows: o A=5, B=10, C=15, D=20, E=25, F=30, G=35, H=40, J=45, K=50, L=75, M=100 8