MUP NUMBER: LDB2VVA031 ----------- PRODUCT: DEC DB Integrator Gateway for DB2 -------- UPDATED PRODUCT: DEC DB Integrator Gateway for DB2 3.1A ---------------- APPRX BLCK SIZE: 8770 ---------------- i DIGITAL Before You Install DEC DB Integrator Gateway for DB2 Client Version 3.1A This letter provides the most current information about DEC DB Integrator Gateway for DB2 Client for the Digital UNIX[[R]] on Alpha operating system and the OpenVMS Alpha and the OpenVMS VAX operating systems. Instructions in this letter supersede those in the rest of the documentation supplied with DEC DB Integrator Gateway for DB2 Client. DEC DB Integrator Gateway for DB2 Server Information DEC DB Integrator Gateway for DB2 Client for Digital UNIX Ver- sion 3.1A works with DEC DB Integrator Gateway for DB2 Server Version 3.1. <> DEC DB Integrator Gateway for DB2 Client for OpenVMS Version 3.1A works with DEC DB Integrator Gateway for DB2 Server Version 2.0 (formerly known as DEC RdbAccess Server for DB2 Version 2.0) and DEC DB Integrator Gateway for DB2 Server Version 3.1. <> MUP Kit Description Enclosed is the Version 3.1A MUP (Mandatory Update Package) kit for DEC DB Integrator Gateway for DB2 Client. This kit supersedes Version 3.1. You can install this kit without having installed DEC DB Integrator Gateway for DB2 Client Version 3.1. Items in this release are as follows: o Concurrent use license metering problem fix o Support for additional development tools o Other miscellaneous enhancements Refer to the release notes for complete information. Contents of This Kit Your DEC DB Integrator Gateway for DB2 Client Version 3.1A kit includes the following items: o Bill of Materials (BOM) Please read the BOM in this kit and check to see that all items listed are actually in your kit. If your kit is dam- aged or any items are missing, please contact your Digital representative. o Media You will find the CD-ROM media in the DEC DB Integrator Gateway for DB2 Client Version 3.1A kit. o Documentation The DEC DB Integrator Product Family Compact Disc User's Guide accompanies the Version 3.1A MUP distribution kit. The Compact Disc User's Guide provides information about using the CD-ROM and accessing the software kits and documentation. NOTE Before you install the product, Digital recommends that you read the cover letter, release notes, and installation guide. o Software Product Description (SPD) The SPD provides an overview of DEC DB Integrator Gateway for DB2 Client and its features. The SPD is on CD-ROM, as explained in the Compact Disc User's Guide. o Software Performance Report (SPR) Use this form to report any problems with DEC DB Integrator Gateway for DB2 Client, provided you have purchased warranty services. Installation Information The following list summarizes important information about the installation of DEC DB Integrator Gateway for DB2 Client: o License requirements To install and run DEC DB Integrator Gateway for DB2 Client, you must first register and load a License Product Authoriza- tion Key (License PAK) using the License Management Facility (LMF). The License PAK may be shipped along with the kit if you ordered the license and media together. Otherwise, it is shipped separately to a location based on your license order. For DEC DB Integrator Gateway for DB2, you need a VIDA for DB2 license or a user or capacity license. <> o Operating system requirement The Digital UNIX[[R]] on Alpha operating system Version 3.0 or higher must be installed on your system before DEC DB Integrator Gateway for DB2 Client can be installed and used properly. <> The OpenVMS Alpha operating system Version 6.1 or the OpenVMS VAX operating system Version 5.5-2 or higher must be in- stalled on your system before DEC DB Integrator Gateway for DB2 Client can be installed and used properly. <> 2 o Common Components requirement The Rdb Common Components Version 6.1 are automatically installed as part of the installation procedure for DEC DB Integrator Gateway for DB2 Client for Digital UNIX. <> The Rdb Common Components Version 6.1 must be installed on the system before DEC DB Integrator Gateway for DB2 Client can be installed and used properly. Refer to the DEC DB In- tegrator Gateway for DB2[TM] Client for OpenVMS Installation and Configuration Guide for instructions. <> o DEC C/C++ requirement The DEC C/C++ Run-Time components may need to be installed on an OpenVMS VAX Version 5.5 or Version 6.0 system before Rdb Common Components Version 6.1 can be installed. Additional information is included in this letter. <> o Other prerequisite software on the client system DEC SNA OSF APPC/LU6.2 Version 1.0 <> DEC SNA VMS APPC/LU6.2 Version 2.2 <> o Prerequisite software on the server system - One of the following operating systems: MVS/XA Version 2 Release 2 MVS/ESA Version 4 Release 3 or Release 4 - One of the following gateway servers: DEC RdbAccess Server for DB2 Version 2.0 DEC DB Integrator Gateway for DB2 Server Version 2.0 DEC DB Integrator Gateway for DB2 Server Version 3.1 - ACF/VTAM Version 3 Release 4 or Version 4 Release 1 - One of the following versions of CICS: CICS/MVS Version 2 Release 1 CICS/ESA Version 3 Release 2 or Release 3 - Assembler H Version 2 - SMP/E Version 1 Release 7 or Release 8 - One of the following versions of the IBM database soft- ware: DB2 Version 2 Release 3 DB2 Version 3 Release 1 with the CICS Attachment Facil- ity 3 Installing DEC C/C++ Before installing the Common Components, you might need to in- stall the DEC C/C++ Run-Time Components Version 6.0 for OpenVMS VAX kit if the target installation system is running OpenVMS VAX Version 5.5 or Version 6.0. The DEC C/C++ Run-Time Com- ponents kit must be installed prior to the Common Components installation. The saveset containing the DEC C/C++ Run-Time Components kit is in the file AACRT060.A, and is included with the Rdb Version 6.1 for OpenVMS VAX kits. This kit is installed using the VMSINSTAL utility. The Common Components installation fails if the DEC C/C++ Run-Time Components kit is not already installed. Installing the DEC C/C++ Run-Time Components kit might have some implications for customer sites that run OpenVMS Version 5.5, 5.5-1, or 5.5-2 and develop applications written in C or C++. The DEC C/C++ Run-Time Components kit contains shareable image run-time components. When the DEC C/C++ Run-Time Components kit is installed on OpenVMS VAX Version 5.5, 5.5-1, or 5.5-2 systems, some of the shareable image run-time components replace older versions of existing OpenVMS components. This makes the installation of the DEC C/C++ Run-Time Components kit similar to an OpenVMS upgrade for sites that develop or distribute software for OpenVMS VAX Version 5.5, 5.5-1, or 5.5-2 systems. Please read the release notes that are supplied with the DEC C/C++ Run-Time Components kit before installation so that you fully understand these implications before installing the Common Components. <> Desktop Connectivity and DEC DB Integrator Gateway for DB2 Client You can access DEC DB Integrator Gateway for DB2 Client databases from your desktop using popular ODBC-compliant tools and applications. The client/server connectivity software is available as part of the DEC DB Integrator Gateway for DB2 Client kit. The client/server or ODBC access to DEC DB Integrator Gateway for DB2 Client is enabled by the SQL/Services software that comes packaged with the DEC DB Integrator Gateway for DB2 Client software. SQL/Services software is a client/server component of the DB Integrator Product Family. SQL/Services lets you develop client application programs on a variety of desktop and mainframe systems so that you can access DBI and gateway databases. DEC ODBC Driver for the Microsoft Windows operating system and DEC ODBC Driver for the Windows NT PC operating system allow ODBC applications read and write access to DEC DB Integrator Gateway for DB2 Client databases using TCP/IP, DECnet, or IPX /SPX transport. Note that the DEC ODBC Driver for Windows NT 4 PC operating system does not support the IPX/SPX transport. The ODBC Driver then uses SQL/Services software to access the data. Where to Find SQL/Services Software: The SQL/Services subsets are part of the DEC DB Integrator Gateway for DB2 Client kit. To enable desktop connectivity from a PC to DEC DB Integra- tor Gateway for DB2 Client, you need to install the following subsets, which are listed as optional on the DBI installation menu: o DEC Database Desktop ODBC Files and Images This subset installs the images for the DEC ODBC Driver for Windows and for Windows NT on the Alpha and Intel platforms. These executables must then be moved to the client machines. o DEC Database Desktop Client Files and Images This subset provides the client software needed to allow communication between the client (in this case, a PC) and the server where DBI and/or gateways are installed. There are clients for MacIntosh, Windows, Windows NT (Alpha and Intel platforms), RISC ULTRIX, and Sun included in this subset. o DEC Database Desktop Server Files and Images This subset provides the software needed to create and manage SQL/Services executors on the server machine. Documentation for SQL/Services is also included in this subset. The other elements needed to enable desktop or PC access to DEC DB Integrator Gateway for DB2 Client on Digital UNIX systems are SQL and Rdb/Dispatch. These components are included in the DEC Common Database Components Files and Images subset, which is mandatory and automatically installed (if it is not already present on the system) when you install DBI or any of the gateways. <> SQL/Services is a separate installation on OpenVMS systems. The SQL/Services Installation and Configuration Guide is in- cluded in the SQL/Services saveset. The SQL/Services savesets are available as part of the Oracle Rdb (formerly DEC Rdb) kit, which is packaged with DEC DB Integrator Gateway for DB2 Client. The DEC ODBC Driver for Windows image (DECODBC.EXE) is included in the SQL/Services saveset. Instructions for copying this image to the PC are in the README.TXT file in the SQL/Services saveset. SQL/Services savesets are as follows: o SQLSRVnnn.A, where nnn is the version of SQL/Services, can be found in the [DECRDBnnn.KIT] directory on CD-ROM 5 o SQLSRVMnnn.A, where M identifies it as the Multiversion kit and nnn is the version of SQL/Services, can be found in the [DECRDBMVnnn.KIT] directory on CD-ROM. On tape media, the SQL/Services savesets can be found on a separate tape. If you are running multiple versions of Rdb, then install the SQL/Services Multiversion kit. <> 6 How to Set Up and Use SQL/Services and ODBC: Please refer to the SQL/Services Installation and Configura- tion Guide for information on the setup and configuration of SQL/Services. The SQL/Services documentation may be found in the following locations after installing the software: /usr/lib/dbs/sqs/v61/doc/sqlsrvXXX.install_guide <> SYS$HELP:SQLSRVxxx.INSTALL_GUIDE <> Documentation Omissions and Errata DEC DB Integrator Product Family User's Guide o Chapter 1, Section 1.5.5 Online Help - Use the DCL command HELP DB_Integrator to invoke online help for DBI on an OpenVMS system. - Use the DCL command HELP DBI_GATE_xxx to invoke online help for a DBI gateway product on an OpenVMS system. Re- place xxx with one of the following: DB2, EDASQL, ORACLE, SQLNK, or SYBASE. <> - To view the online reference page for DEC DB Integrator Gateway for DB2 Client on a Digital UNIX system: % man dbi_db2 <> o Chapter 4 - Section 4.7.3 Specifying the Logon Mode The parameter for the LOGON_MODE qualifier is described as being case sensitive on Digital UNIX. This is incorrect. This parameter is not case sensitive. The parameter value you provide for the LOGON_MODE quali- fier in an attach specification is automatically converted to uppercase on Digital UNIX. <> - Section 4.7.4 Specifying the DEC SNA Gateway Logical Unit Name The example in this section contains an error. There should be a single quotation mark preceding the semicolon (;) at the end of the statement. o Chapter 7, Section 7.3.4 Examples of Attach Statements for the DBI Gateway for SequeLink The qualifiers DB_LOGON1 and DB_LOGON2 are incorrect. Replace them in the text and examples with DB_LOGON_1 and DB_LOGON_2. The last example contains an error. Place a single quotation mark before the semicolon (;) at the end of the statement. 7 o Chapter 10, Section 10.5, Conversion of Data Types Add the following statement to this section: The tables in the following sections show how data types in the underlying database management systems are mapped into SQL data types. o Chapter 13, Section 13.2.7 Stored Procedures In Example 13-1, the END statements are incorrect. They should be as follows: END; END MODULE; o Chapter 18, Section 18.1.2 Managing Large Result Sets The second paragraph under the bulleted item DBI_WM_BYTE_ LIMIT contains an error. It should read as follows: Half of the lesser of the process's remaining page file quota (PAGFILCNT) and the process's free page table entry count (FREPTECNT) in bytes. DEC DB Integrator Product Family User's Guide for DEC OSF/1[[R]] AXP o Chapter 4, Section 4.1.3 SQL Date-Time Format The time format of hh:mm:ss.hh is incorrect and references to the time field .hh are also incorrect. The correct time format is hh:mm:ss.cc and the correct referenced time field is .cc. o Appendix B - Section B.1 Select Expressions The first example in the description of the OPTIMIZE USING outline-name argument contains an error. Place a semicolon (;) at the end of the statement. - Section B.2 Change to System Relations Documentation The command HELP SQL System_Relations is incorrect. The correct command is as follows: % dbhelp decdb System_Relations - Section B.3 SELECT Statement: General Form In the Examples section, the logical name RDMS$DEBUG_FLAGS is incorrect. The correct logical name is RDMS_DEBUG_ FLAGS. - Section B.4 sql_get_message_vector In the Examples section, the logical name RDB$_INTEG_FAIL is incorrect. The correct logical name is RDB__INTEG_ FAIL. - Section B.4 sql_signal 8 In the Examples section, the SQL$REPORT.SC sample pro- gram name is incorrect. The correct program name is sql_ report.sc. <> Release Notes The DEC DB Integrator Gateway for DB2 Client release notes provide additional information about the product that is not contained in the documentation. Digital strongly recommends that you read the release notes before proceeding with the installation. Before installing DEC DB Integrator Gateway for DB2 Client, you can read the release notes from the CD-ROM, as described in the DEC DB Integrator Product Family Compact Disc User's Guide. After installing the DEC DB Integrator Gateway for DB2 Client subset, you can read the release notes in ASCII format from: /usr/lib/dbs/d2g/v31/doc/d2g311.release_notes <> SYS$HELP:LDB2031.RELEASE_NOTES. <> Documentation Available The following DEC DB Integrator Product Family documentation is available from Digital: o DEC DB Integrator Product Family User's Guide-order number AA-Q1SNB-TK o DEC DB Integrator Handbook-order number AA-Q1SPB-TK o DEC DB Integrator Gateway for DB2[TM] Server Installation and Configuration Guide-order number AA-MI29D-TE o DEC DB Integrator for OpenVMS Installation Guide-order number AA-Q1SQB-TK o DEC DB Integrator Gateway for DB2[TM] Client for OpenVMS Installation and Configuration Guide-order number AA-MH82D-TE o DEC DB Integrator Gateway for EDA/SQL[TM] for OpenVMS Instal- lation and Configuration Guide-order number AA-QDA6A-TE o DEC DB Integrator Gateway for ORACLE[[R]] for OpenVMS Instal- lation and Configuration Guide-order number AA-Q2C9B-TE o DEC DB Integrator Gateway for SequeLink[TM] for OpenVMS Installation and Configuration Guide-order number AA-QD93A-TE o DEC DB Integrator Gateway for SYBASE[[R]] for OpenVMS Instal- lation and Configuration Guide-order number AA-Q1ZPB-TE o DEC DB Integrator Gateway for Custom Drivers/DEC DB In- tegrator Gateway for RMS Installation Guide-order number AA-PFF7D-TE 9 o DEC DB Integrator Gateway for Custom Drivers Driver Develop- ment Guide-order number AA-PUZUB-TE o Accessing Nonrelational Data with SQL-order number AA-PFF8C- TK o Accessing RMS and VSAM Files with SQL-order number AA-PN9EB- TE o Accessing DEC DBMS Data with SQL-order number AA-Q227A-TE o DEC DB Integrator Gateway for DSM User's Guide-order number AA-Q0T4A-TE <> The following DEC DB Integrator product family documentation is available on CD-ROM. Refer to the DEC DB Integrator Product Family Compact Disc User's Guide for information on accessing the files. o Before You Install letters and Release Notes for DEC DB Integrator, DEC DB Integrator Gateway for DB2 Client, DEC DB Integrator Gateway for EDA/SQL, DEC DB Integrator Gateway for ORACLE, DEC DB Integrator Gateway for SequeLink, and DEC DB Integrator Gateway for SYBASE o DEC DB Integrator for DEC OSF/1[[R]] AXP Installation Guide o DEC DB Integrator Product Family User's Guide for DEC OSF/1[[R]] AXP o DEC DB Integrator Gateway Products for DEC OSF/1[[R]] AXP Installation and Configuration Guide <> o Before You Install DEC DB Integrator Gateway for Custom Drivers and DEC DB Integrator Gateway for RMS o DEC DB Integrator Gateway for Custom Drivers/DEC DB Integra- tor Gateway for RMS Release Notes o CDD/Repository CDO Reference Manual o Before You Install DEC DB Integrator Gateway for DBMS o Before You Install DEC DB Integrator Gateway for DSM <> o SQL manuals o SQL/Services manuals Digital Services A variety of service and support options are available from Dig- ital. For more information, contact your Digital sales office. 10 Comments Are Appreciated Digital appreciates your comments about DEC DB Integrator Gate- way for DB2 Client. If you experience problems, find documenta- tion errors, or want to make comments, please fill out and mail the questionnaire following the preface in the manuals. Or send Internet mail containing the manual's title (if applicable), product name and version, and order number (if present) to: trapasso@orion.enet.dec.com If you have access to a FAX machine, you can send comments and suggestions to: L. S. Trapasso, DBI Documentation, ZKO2-1/R34 FAX number 603-881-6061 ©Digital Equipment Corporation. 1994, 1995. All Rights Reserved. DEC, Digital, OpenVMS, VAX, VMS, and the DIGITAL logo are trade- marks of Digital Equipment Corporation. IBM is a registered trademark of International Business Machines Corporation. DB2, CICS, CICS/ESA, CICS/MVS, MVS/ESA, MVS/XA, RACF, and VTAM are trademarks of International Business Machines Corporation. UNIX is a registered trademark in the United States and other countries licensed exclusively through X/Open Company Ltd. Digital Operating Systems Name Changes Several of Digital's operating system names have changed. DEC OSF/1 is now known as Digital UNIX. OpenVMS AXP is now known as OpenVMS Alpha. Because of the recent occurrence of these name changes, the software and documentation may not reflect the new operating system names. Notice of Product Name Changes: The product DEC Rdb and a number of other related products were recently sold by Digital Equip- ment Corporation to Oracle Corporation. DEC Rdb is now known as Oracle Rdb. Because the sale of these products was concluded recently, the software and documentation do not necessarily reflect the new names for all the products. All other trademarks and registered trademarks are the property of their respective holders. 11 Copyright Digital Equipment Corporation 1995. All Rights reserved. This software is proprietary to and embodies the confidential technology of Digital Equipment Corporation. Possession, use, or copying of this software and media is authorized only pursuant to a valid written license from Digital or an authorized sublicensor. ADDHERE