*********************************************************************** DB2 Universal Database Version 5 Documentation *********************************************************************** The following files contain the .pdf format and 'zipped' postscript format for the DB2 UDB Version 5.0 and Version 5.2 manuals. Files named *50.* are the first version of a manual shipped with DB2 UDB Version 5.0 (except for db2z0e50.* which was first available with Version 5.2). Files named *51.* or *52.* are the versions of each manual shipped with DB2 UDB Version 5.2 - Be sure to download each file using the 'binary' transmission mode. - The Adobe Acrobat Reader is required to view the .pdf files. It can be obtained from the following web site: http://www.adobe.com - db2a0e50.pdf - Embedded SQL Programming Guide db2a0e50.psbin.zip db2a1e50.pdf - Building Applications for Windows** & OS/2 Environments db2a1e50.psbin.zip db2ape50.pdf - APPC, CPI-C, and SNA Sense Codes db2ape50.psbin.zip db2axe50.pdf - Building Applications for UNIX** Environments db2axe50.psbin.zip db2axe51.pdf db2axe51.ps.zip db2b0e50.pdf - API Reference db2b0e50.psbin.zip db2b0e51.pdf db2b0e51.ps.zip db2c0e50.pdf - DB2 Connect User's Guide db2c0e50.psbin.zip db2c0e51.pdf db2c0e51.ps.zip db2c1e50.pdf - DB2 Connect Personal Edition Quick Beginnings db2c1e50.psbin.zip db2c1e51.pdf db2c1e51.ps.zip db2cye50.pdf - DB2 Connect Enterprise Edition Quick Beginnings db2cye50.psbin.zip db2cye51.pdf db2cye51.ps.zip db2d0e50.pdf - Administration Guide db2d0e50.psbin.zip db2d0e51.pdf db2d0-a4.pdf (pdf version for the metric A4 paper size) db2d0e51.ps.zip db2e0e50.pdf - Replication Guide and Reference db2e0e50.psbin.zip db2e0e52.pdf db2e0e52.ps.zip db2f0e50.pdf - System Monitor Guide & Reference db2f0e50.psbin.zip db2h1e50.pdf - DB2 Connectivity Supplement db2h1e50.psbin.zip db2h1e51.pdf db2h1e51.ps.zip db2i1e50.pdf - DB2 Personal Edition Quick Beginnings db2i1e50.psbin.zip db2i2e50.pdf - DB2 for OS/2 Warp Quick Beginnings db2i2e50.psbin.zip db2i6e50.pdf - DB2 for Windows NT** Quick Beginnings db2i6e50.psbin.zip db2ixe50.pdf - DB2 for UNIX** Quick Beginnings db2ixe50.psbin.zip db2ixe51.pdf db2ixe51.ps.zip db2iye50.pdf - Installing and Configuring DB2 Clients db2iye50.psbin.zip db2iye51.pdf db2iye51.ps.zip db2k0e50.pdf - Administration Getting Started db2k0e50.psbin.zip db2l0e50.pdf - Call Level Interface Guide and Reference db2l0e50.psbin.zip db2m0e50.pdf - Messages Reference db2m0e50.psbin.zip db2m0e51.pdf db2m0-a4.pdf (pdf version for the metric A4 paper size) db2m0e51.ps.zip db2n0e50.pdf - Command Reference db2n0e50.psbin.zip db2n0e51.pdf db2n0-a4.pdf (pdf version for the metric A4 paper size) db2n0e51.ps.zip db2p0e50.pdf - Troubleshooting Guide db2p0e50.psbin.zip db2q0e50.pdf - What's New db2q0e50.psbin.zip db2q0e51.pdf db2q0e51.ps.zip db2s0e50.pdf - SQL Reference db2s0e50.psbin.zip db2s0e51.pdf db2s0-a4.pdf (pdf version for the metric A4 paper size) db2s0e51.ps.zip db2t0e50.psbin.zip - Glossary db2u0e50.pdf - Road Map to DB2 Programming db2u0e50.psbin.zip db2v3e50.pdf - Extended Enterprise Edition for AIX Quick db2v3e50.psbin.zip Beginnings db2v6e50.pdf - Extended Enterprise Edition for Windows NT Quick db2v6e50.psbin.zip Beginnings db2v6e51.pdf db2v6e51.ps.zip db2w0e50.pdf - Master Index db2w0e50.psbin.zip db2y0e50.pdf - SQL Getting Started db2y0e50.psbin.zip db2z0e50.pdf - File Manager for AIX Quick Beginnings db2z0e50.ps.zip desu9mst.psbin - DB2 UDB Text Extender Administration and Programming. dmba5mst.psbin - DB2 UDB Image, Audio, and Video Extenders - Administration and Programming. *********************************************************************** DATABASE 2 for OS/2 and DATABASE 2 for AIX Version 2.1 Documentation *********************************************************************** The following 27 manuals have been released with version 2.1.2 of the DATABASE 2 for OS/2 and DATABASE 2 for AIX Program Products. Each manual has two versions, a postscript version for printing using a postscript printer and an INF version for online viewing using the VIEW command of OS/2 or the XVIEW command of AIX. (The INF version of each manual has a filename ending with the letter 'i'.) Note that if the manual number ends with -01, this indicates that it has been updated for DB2 Version 2.1.1. If the number ends with -00, then the manual has not changed between DB2 version 2.1.0 and 2.1.1 No manuals were updated between DB2 version 2.1.1 and version 2.1.2. Each manual has been compressed using PKZIP so be sure to transfer the file using the BINARY mode. ADMIN.ZIP ADMINI.ZIP Title: DATABASE 2 Administration Guide for Common Servers Version 2 - 688 pages. S20H-4580-01. This book provides information necessary to use and administer the DB2 RDBMS products including: - information required for designing, implementing and managing databases - information regarding the configuring and tuning of your database environment to improve performance AIXINDX.ZIP AIXINDXI.ZIP Title: DATABASE 2 for AIX Master Index Version 2 161 pages. S20H-4781-00. This book represents the master index for the IBM DATABASE 2 for AIX (DB2 for AIX) library. It consolidates the indexes from the other manuals in the library, directing readers to the the manual(s) in which the topic is discussed. APIREF.ZIP APIREFI.ZIP Title: DATABASE 2 API Reference for Common Servers Version 2 705 pages. S20H-4984-01. This book provides information about the use of application programming interfaces (APIs) to execute database administrative functions. It presents detailed information on the use of database manager API calls in applications written in : - C - COBOL - FORTRAN - REXX APPPROG.ZIP APPPROGI.ZIP Title: DATABASE 2 Application Programming Guide for Common Servers Version 2 - 631 pages. S20H-4643-01. This book discusses how to design and code application programs that access DB2 databases and application servers. It presents detailed information on the use of SQL in supported host language programs. Where you require information unique to your specific operating system, see the DB2 SDK book for that platform. CAEDOS.ZIP CAEDOSI.ZIP Title: DATABASE 2 Client Application Enabler/DOS User's Guide Version 1.2 - 152 pages. SC09-1628-01. (Note 1 : Unchanged from Version 1.2). (Note 2 : Also refer to DB2 DOS Client Installation Supplement Version 1.2). This is the V1.2 CAE/DOS User's Guide ... use it in conjunction with the CAE/DOS V1.2.1 Supplement also in this library. CLIREF.ZIP CLIREFI.ZIP Title: DATABASE 2 Call Level Interface Guide and Reference for Common Servers Version 2 - 594 pages. S20H-4644-01. This book provides the information necessary to write applications using DB2 Call Level Interface to access IBM DB2 servers. This book should also be used as a supplement when writing applications (using an ODBC Software Development Kit) that access IBM DB2 servers using ODBC. CMDREF.ZIP CMDREFI.ZIP Title: DATABASE 2 Command Reference for Common Servers Version 2 413 pages. S20H-4645-01. This book provides information about the use of system commands and the IBM DB2 command line processor (CLP) to execute administrative functions. DBAATK2.INFBIN Title: Database Director - Getting Started This book describes the Database Director and how it can be used to view catalogued database objects and to perform most administrative actions on them. DBMON.ZIP DBMONI.ZIP Title: DATABASE 2 Database System Monitor Guide and Reference for Common Servers Version 2 - 379 pages. S20H-4871-00. The DB2 Database system monitor enables you to gather both statistical information on the operation of the database manager and activity information on database processing. This book describes the database system monitor AND the various pieces and types of information that can be gathered. DB22PLN.ZIP DB22PLNI.ZIP Title: DATABASE 2 for OS/2 Planning Guide Version 2 187 pages. S20H-4784-00. This book provides product and planning information about the IBM DB2 family of products for the OS/2 operating system. These products include the following: - DB2 for OS/2 - DB2 SDK for OS/2 - DDCS for OS/2 This book presents a comprehensive overview of the DB2 products for OS/2. DB26PLN.ZIP DB26PLNI.ZIP Title: DATABASE 2 for AIX Planning Guide Version 2 187 pages. S20H-4758-00. This book provides product and planning information about the IBM DB2 family of products for the AIX operating system. These include: - DB2 for AIX - DB2 SDK for AIX - DDCS for AIX This book presents a comprehensive overview of the DB2 products for AIX. DDCSIN2.ZIP DDCSIN2I.ZIP Title: Distributed Database Connection Services (DDCS) for OS/2 - Installation and Configuration Guide Version 2.3 91 pages. S20H-4795-01. This manual describes the steps to install and configure DDCS for OS/2 V2.3. It contains information for administrators responsible for setting up a DDCS for OS/2 connection between clients and DRDA Application Servers. This book contains platform-specific information for DDCS/2. For conceptual and user information that applies to all DDCS products, see the Distributed Database Connection Services (DDCS) User's Guide for Common Servers Version 2.3. DDCSIN6.ZIP DDCSIN6I.ZIP Title: Distributed Database Connection Services (DDCS) for AIX - Installation and Configuration Guide Version 2.3 91 pages. S20H-4794-01. This describes the steps to install and configure the DDCS for AIX product. It contains information for administrators responsible for setting up a DDCS for AIX connection between database clients and DRDA servers. It contains platform specific information for DDCS for AIX. For conceptual and user information that applies to all DDCS products, see the DDCS User's Guide. DDCSUSR.ZIP DDCSUSRI.ZIP Title: Distributed Database Connection Services (DDCS) User's Guide for Common Servers Version 2.3 147 pages. S20H-4793-00. This book contains general information about the DDCS products. It is intended for programmers and administrators who are responsible for setting up and maintaining a DDCS connection between database clients and DRDA Application Server Databases. This book explains concepts that are applicable to any of the DDCS products. DOSSUP.ZIP DOSSUPI.ZIP Title: DATABASE 2 DOS Client Installation Supplement Version 1.2 35 pages. S20H-4949-00. This manual provides an overview of the DB2 Client Application Enabler for DOS Version 1.2.1 and describes briefly the differences from the DB2 Client Application enabler for DOS Version 1.2. It includes: - an overview of CAE/DOS V1.2.1 - Installation information - password encryption information - DOS Extender information - and more INFOCON.ZIP INFOCONI.ZIP Title: DATABASE 2 Information and Concepts Guide for Common Servers Version 2 - 185 pages. S20H-4664-00. The manual provides general information and concepts about the following DB2 products or components: - DB2, the relational database management system - DB2 Client Application Enabler - DB2 Software Developer's Kit - Administrator's Toolkit - DDCS These products are available for various platforms including OS/2, Windows and UNIX-based platforms. INSAIX.ZIP INSAIXI.ZIP Title: DATABASE 2 for AIX Installation and Operation Guide Version 2 - 149 pages. S20H-4757-01. This book describes the installation and basic operation of the IBM Database 2 for AIX products on the AIX operating system. See the AIX Planning Guide for hardware and software requirements and other related information. INSAIXC.ZIP INSAIXCI.ZIP Title: DATABASE 2 Installing and Using AIX Clients Version 2 179 pages. S20H-4666-01. This book provides the following information: - Installing the following client product or component on a RISC System/6000 running version 3.2.4 (or later) of the AIX operating system - DB2 CAE for AIX - DB2 SDK for AIX - Setting up communication protocols between a client and a remote server. - Using the DB2 Client Application Enabler for AIX INSOS2.ZIP INSOS2I.ZIP Title: DATABASE 2 for OS/2 Installation and Operation Guide Version 2 - 153 pages. S20H-4785-01. This book contains the basic information required to install the DB2 for OS/2 V2.1 product or any of its components. It is designed for anyone installing DB2 for OS/2 V2.1, or preparing to install it on other workstations. Use this book in conjunction with the Planning Guide and the Administration Guide to perform DB2 for OS/2 installation related tasks. INSOS2C.ZIP INSOS2CI.ZIP Title: DATABASE 2 Installing and Using OS/2 Clients Version 2 181 pages. S20H-4782-01. This book provides the following information: - Installing the following client product or component on a workstation running OS/2: - DB2 CAE for OS/2 - DB2 SDK for OS/2 - Setting up communication between a client and a remote server - Using the DB2 CAE for OS/2 INSWINC.ZIP INSWINCI.ZIP Title: DATABASE 2 Installing and Using DB2 Clients for Windows Version 2 - 161 pages. S20H-4789-01. This book provides information for: - installing the following client product or component on a workstation running in the Windows environment: - DB2 CAE/Windows V2.1 - DB2 SDK/Windows V2.1 - Setting up communication between a client and a remote server - Using the DB2 CAE for Windows MSGREF.ZIP MSGREFI.ZIP Title: DATABASE 2 Messages Reference for Common Servers Version 2 - 372 pages. S20H-4808-01. The purpose of this manual is to list all messages returned by various components of DB2 common server V2.1. OS2INDX.ZIP OS2INDXI.ZIP Title: DATABASE 2 for OS/2 Master Index Version 2 158 pages. S20H-4788-00. This manual consolidates the indexes from the other manuals in the library directing readers to the manuals(s) in which the topic is discussed. PROBDET.ZIP PROBDETI.ZIP Title: DATABASE 2 Problem Determination Guide for Common Servers Version 2 - 162 pages. S20H-4779-00. The purpose of this guide is to provide assistance for you to: - Identify problems or errors in a concise manner - Assist in the effective and prompt resolution of problems - Describe available diagnostic tools It is designed to be used by the person who is designated as technical support rep for DB2 clients and servers. SDKAIX.ZIP SDKAIXI.ZIP Title: DATABASE 2 Software Developer's Kit for AIX - Building Your Applications Version 2 - 107 pages. S20H-4780-00. This book provides: - Introductory information about programming applications that use embedded SQL or the DB2 CLI to access DB2 databases. - Step-by-step instructions to compile and link those applications in an AIX environment. SDKOS2.ZIP SDKOS2I.ZIP Title: DATABASE 2 Software Developer's Kit for OS/2 - Building Your Applications Version 2 - 95 pages. S20H-4787-00. This book provides: - introductory information about programming applications that use embedded SQL or the DB2 CLI to access DB2 databases. - Step-by-step instructions to compile and link those applications in an OS/2 environment. SDKWIN.ZIP SDKWINI.ZIP Title: DATABASE 2 Software Developer's Kit for Windows - Building Your Applications Version 2 - 91 pages. S20H-4792-00. This book provides: - introductory information about programming applications that use embedded SQL or the DB2 CLI to access DB2 databases. - Step-by-step instructions to compile & link those applications in a Windows environment. SQLREF.ZIP SQLREFI.ZIP Title: DATABASE 2 SQL Reference for Common Servers Version 2 847 pages. S20H-4665-01. This book is intended for anyone who wants to use SQL to access a database. It defines the SQL used by DB2 version 2.1. Use it as a reference manual for information on relational database concepts, language elements, functions, the forms of queries, and the syntax and semantics of the SQL language. *********************************************************************** *********************************************************************** DATABASE 2 Client for Macintosh Version 2.1 Documentation *********************************************************************** The following 2 manuals are available for the Database 2 Client for Macintosh Program Products. Each manual has two versions, a postscript version for printing using a postscript printer and an INF version for online viewing using the VIEW command of OS/2 or the XVIEW command of AIX or Windows NT. (The INF version of each manual has a filename ending with the letter 'i'). NOTE that the .inf version for each manual is not yet available. Each manual has been compressed using PKZIP so be sure to transfer the file using the BINARY mode. INSMACC.ZIP INSMACCI.ZIP (not yet available) Title: IBM DATABASE 2 Installing and Using DB2 Clients for Macintosh** Version 2 Release 1 - 86 pages. S50H-0529-00 This book is for those users who install, use, and maintain the DB2 Macintosh client products. It is also for users who want to run applications using DB2 Client Application Enabler for Macintosh. Installation and configuration of these products must be coordinated with the administrator responsible for the database server and communications network. This book provides information about the following tasks: Installing the following client products or components on a workstation running the Macintosh** environment: - IBM DATABASE 2 Client Application Enabler for Macintosh - IBM DATABASE 2 Software Developer's Kit for Macintosh (DB2 SDK for Macintosh) Setting up communication between a client and a remote server. Using the DB2 Client Application Enabler for Macintosh. See the DB2 SDK for Macintosh Building Your Applications for information on developing applications using the DB2 SDK for Macintosh. Note: The DB2 SDK for Macintosh is a product that you can purchase separately. The DB2 Client Application Enabler for Macintosh component is included in the DB2 SDK for Macintosh and the DB2 Client Pack. SDKMAC.ZIP SDKMACI.ZIP (not yet available) Title: IBM DATABASE 2 Software Developer's Kit for Macintosh** Building Your Applications Version 2 - 42 pages. S50H-0528-00 This book provides: Introductory information about programming applications that use embedded SQL, the Microsoft** Open Database Connectivity** (ODBC), or the DB2 Call Level Interface (DB2 CLI) to access DB2 databases. Step-by-step instructions to compile and link those applications in your environment. If you have not developed applications that use embedded SQL, the ODBC, or the DB2 CLI, read this book first to gain a general understanding about coding your applications. If you know how to code applications that use embedded SQL, the ODBC or the DB2 CLI, you can read this book to learn how to compile and link your applications, and then use the Application Programming Guide to code your applications. Or, you can start with the Application Programming Guide, and return to this book when you are ready to compile and link your applications. The Installing and Using DB2 Clients for Macintosh book explains how to install the Software Developer's Kit on a client workstation. The book also lists the directories that contain SDK files, such as header and include files. *********************************************************************** *********************************************************************** DATABASE 2 for Windows 95 and Windows NT Version 2.1 Documentation *********************************************************************** The following manuals have been released with version 2.1 of the DATABASE 2 for Windows NT Program Products. Most manuals have two versions, a postscript version for printing using a postscript printer and an INF version for online viewing using the VIEW command of OS/2 or the XVIEW command of AIX or the XVIEW command if the IPFWIN viewer is installed on your Windows 95 or Windows NT workstation. Alternatively, the IVIEW tool found in sqllib\bin can be used. (The INF version of each manual has a filename ending with the letter 'i'.) Note that if the manual number ends with -01, this indicates that it has been updated for DB2/NT Version 2.1.1. If the number ends with -00, then the manual has not changed between DB2/NT version 2.1.0 and 2.1.1. Two new manuals were shipped with version 2.1.2, DDCS for Windows Getting Started AND DDCS for Windows Supplement Version 2.4. Please refer to the DATABASE 2 for OS/2 and DATABASE 2 for AIX Version 2.1 Documentation for 'Common Servers' for information concerning DB2 which is independent of the platform on which the product is installed. Be sure to transfer each file using BINARY mode. Files with a file extension of .zip have also been compressed using PKZIP and so must be uncompressed using PKUNZIP before use. DBSRVNT.ZIP DBSRVNTI.INF Title: Database Server for Windows NT - Up and Running 193 pages. S59H-0727-00. This manual describes the Database Server for Windows NT. This product comprises the following products: - The DB2 SERVER, which is a relational database management system containing functions and tools that enable users to create, update, control and manage relational databases using Structured Query Language (SQL). - The DB2 SOFTWARE DEVELOPER'S KIT which provides the Windows NT development environment for application developers. - The DB2 WORLD WIDE WEB CONNECTION, which enables application developers to create Internet applications that access data from DB2 databases. - An evaluation copy of the DISTRIBUTED DATABASE CONNECTION SERVICES (DDCS) MULTI-USER GATEWAY product, which provides access to DB2 databases residing on host systems such as MVS/ESA, VM, VSE, and OS/400 DDCSGETS.ZIP Title: Distributed Database Connection Services (DDCS) for Windows - Getting Started Version 2.4 240 pages. S88H-9588-00. This manual provides all the information necessary to install, configure and use DDCS for Windows version 2.4. Please refer also to the manual Distributed Database Connection Services (DDCS) for Windows - Supplement Version 2.4 (DDCSSUP.ZIP) DDCSINT.ZIP DDCSINTI.INF Title: Distributed Database Connection Services (DDCS) for Windows NT Installation and Configuration Guide Version 2.3 160 pages. S33H-0311-01. This manual describes the steps to install and configure DDCS for the Windows NT product. It contains information for administrators responsible for setting up a DDCS for Windows NT connection between database clients and any of the following DRDA server database management systems: - DB2 for MVS - DB2 for VSE and VM - DB2 for OS/400 This book contains platform-specific information for the DDCS for Windows NT product. For conceptual and user information that applies to all DDCS products, see the Distributed Database Connection Service s (DDCS) User's Guide for Common Servers Version 2.3. DDCSSUP.ZIP Title: Distributed Database Connection Services (DDCS) for Windows - Supplement Version 2.4 76 pages. This manual provides additional information about installing and using DDCS for Windows Single User Version 2.4. Please refer also to the manual Distributed Database Connection Services (DDCS) for Windows - Getting Started Version 2.4 (DDCSGETS.ZIP) INSNT.ZIP INSNTI.INF Title: DATABASE 2 for Windows 95 and Windows NT Installation and Operation Guide Version 2 - 196 pages. S33H-0312-01. This book contains the basic information required to install the DB2 for Windows NT product or any of its components. It is designed for anyone installing DB2 for Windows NT or preparing to install it on other workstations. Use this book in conjunction with the DB2 for Windows NT Planning Guide and the DB2 2 Administration Guide for Common Servers the Administration Guide to perform DB2 for Windows NT installation related tasks. INSNTCL.ZIP INSNTCLI.INF Title: DATABASE 2 Installing and Using DB2 Clients for Windows 95 & Windows NT Version 2 - 190 pages. S33H-0313-01. This book provides the following information: - Installing the following client products or components on a workstation running in the Windows 95 or NT environment: - DB2 CAE for Windows 95 & NT - DB2 SDK for Windows 95 &NT - Setting up communication between a client and a remote server - Using the DB2 CAE for Windows 95 & NT product PLANNT.ZIP PLANNTI.INF Title: DATABASE 2 for Windows 95 & Windows NT Planning Guide Version 2 170 pages. S33H-0314-01. This book provides product and planning information about the IBM DB2 family of products for the Windows NT operating system. These products include the following: - DB2 for Windows NT - DB2 SDK for Windows 95 & NT - DDCS for Windows NT This book presents a comprehensive overview of the DB2 products for Windows NT. SDKNT.ZIP SDKNTI.INF Title: DATABASE 2 Software Developer's Kit for Windows 95 & Windows NT - Building Your Applications Version 2 - 76 pages. S33H-0310-01. This book provides: - introductory information about programming applications that use embedded SQL, the Microsoft Open Database Connectivity (ODBC) or the DB2 Call Level Interface (DB2 CLI) to access DB2 databases. - Step-by-step instructions to compile & link those applications in your environment. *********************************************************************** *********************************************************************** DATABASE 2 Parallel Edition for AIX Version 1.2 Documentation *********************************************************************** Be sure to transfer each file using the BINARY mode. SG24-4560 PSBIN Title: DB2 Parallel Edition for AIX: Performance and Tuning Guide. Version 1.2 - 113 pages. SG24-4560-00. file******************************************************************* *********************************************************************** DATABASE 2 Professional Certification Program *********************************************************************** The following files contain a description of the DB2 Professional Certification Program. Test objectives are also included. db2cert.text - DB2 Certification Program Description db2qanda.text - Certification Questions & Answers 500.object - Test objectives for DB2 Fundamentals (500) 501.object - Test objectives for DB2 Administration (501) 502.object - Test objectives for DB2 Application Dev. (502) *********************************************************************** *********************************************************************** 12doc3.zip Title : DB2/2 v1.2 Documents (Set 3 of 3) DB2/2 Installation Guide, Information & Planning Guide, CAE/2 User's Guide, Messages and Problem Determination Guide, Query Manager User's Guide and Exercises. Unzip file onto diskette and follow the instruction in the readme.txt. 12doc2.zip Title : DB2/2 v1.2 Documents (Set 2 of 3) DB2/2 SQL Reference, Programming Guide, Command Reference, What's New, Programming Reference. Unzip file onto diskette and follow the instructions in the readme.txt. 12doc1.zip Title : DB2/2 v1.2 Documents (Set 1 of 3) DB2/2 Guide, DB2/2 Master Index and Glossary. pdated manuals for DB2/2 v1.2 in Bookmanager format. et 1 of 3. nzip file onto diskette and follow instructions in readme.txt. locking.des Title : DB2/2, DB2/6000, DB2/HP-UX and DB2/Solaris Locking Description This document contains a detailed description of how locking works in the DB2/2, DB2/6000, DB2/HP-UX and DB2/Solaris products. This file is in ascii format. borlcos2.zip Title : Building Embedded SQL Applications Using SDK/2 with Borland C++. This package provides information on how to build embedded SQL applications with the DATABASE 2(TM) Software Developer's Kit for OS/2 using the Borland C++ compiler. This package includes the following files: borv2.txt - Text file containing instructions on how to build embedded SQL applications using the Borland C++ compiler. bldbor.cmd - Command file for building sample Borland C/C++ program. bldborsr.cmd - Command file for building a Borland C stored procedure for a DB2 for OS/2 server. bldborud.cmd - Command file for building a Borland C UDF. csne1q96.psbin Title : IBM Client/Server News, First Quarter 1996 (Vol. 4 Nbr. 1) csne2q96.psbin Title : IBM Client/Server News, Second Quarter 1996 (Vol. 4 Nbr. 2) db2nqadm (this is a binary file) db2nqadm.txt If you choose to install DB2 UDB V5.2 product documentation on your UNIX operating system, an HTML search engine called NetQuestion will also be installed (if it is not already present on your system). If NetQuestion is not already present on your system you may find that after installing your DB2 product documentation, you are not able to unmount the installation file system (typically a CD-ROM, but NFS file systems can also be affected). This problem is caused by NetQuestion daemons that are started during the installation of the documentation. db2srdbc (this is a binary file) db2srdbc.txt DB2 Universal Database Version 5.2 for AIX uses a level of the NetQuestion double-byte character set (DBCS) search engine that will not work properly if certain levels of NetQuestion are already presen on your AIX operating system. db2.windowsnt.security.msword6.zip (Microsoft Word Version 6.0 format) db2.windowsnt.security.msword7.zip (Microsoft Word Version 7.0 format) db2.windowsnt.security.msword8.doc (Microsoft Word Version 8.0 format - Note this copy is 'not' zipped) Title : DB2 Universal Database (UDB) and Windows NT Security Security is one of the most important features of any database management system. It is key to keeping data safe and limiting data access to those with a need to know. DB2 UDB has many security features of its own, but on Windows NT it also relies on the security features of the Windows NT operating system itself. To understand security for DB2 UDB on Windows NT, we must understand not only the many security features of DB2 UDB but also the Windows NT security model and how it is used by DB2 UDB. netqhp10.txt When installing DB2 Universal Database V5.2 for HP-10 you may find tha NetQuestion, the HTML search facility that comes with DB2 product documentation, cannot be installed from the product CD-ROM. nl0194.txt Title : DB2 Family Newsletter, First Quarter 1994 nl0294.txt Title : DB2 Family Newsletter, Second Quarter 1994 nl0394.txt Title : DB2 Family Newsletter, Third Quarter 1994 nl0494.txt Title : DB2 Family Newsletter, Fourth Quarter 1994 nl0195.zip Title : DB2 Family Newsletter, First Quarter 1995 nl0295.zip Title : DB2 Family Newsletter, Second Quarter 1995 nl0395.zip Title : DB2 Family Newsletter, Third Quarter 1995 nl0495.zip Title : DB2 Family Newsletter, Fourth Quarter 1995 nl0196.txt Title : DB2 Family Newsletter, First Quarter 1996 nl0296.txt Title : DB2 Family Newsletter, Second Quarter 1996 nl0396.txt Title : DB2 Family Newsletter, Third Quarter 1996 olympic.baseball.psbin Title: DB2 Client Server Version 2 at the 1996 Summer Olympics This White Paper presents an example of how the use of the new object relational capabilities of the version 2 DB2 Client Server product were used to assist the development and implementation of the IBM Results System at the 1996 Summer Olympic Games. The specific object relational capabilities discussed in this paper are User Defined Functions and User Defined Types. The example illustrates the collection of certain statistics for baseball. ora-db2.doc Title : Differences between DB2/6000 and ORACLE This document is the summary of experience gained by converting a major business application system from ORACLE 7 to DB2/6000. Initially, the target database was DB2/6000 Version 1 being accessed via Embedded SQL (ESQL). Later, this was changed to be DB2/6000 Version 2 being accessed via Call Level Interface (CLI). The ORACLE database is accessed via Oracle Call Interface (OCI). perfnote.psbin Title : Performance Tuning Notes for DB2 Client/Server This document was created fromthe personal notes of the author and are NOT those of IBM. It contains general notes concerning DB2 performance for both version 1 and version 2 for the OS/2, Windows NT, AIX, Solaris and HP-UX Unix platforms. It is a postscript file. prepapi.txt.db2v21 (for DB2 Version 2.1) prepapi.txt.db2v52 (for DB2 Version 5.2) prepapi.txt (for DB2 UDB Version 6.1 - this file just contains a reference to the file, prepapi.psbin). prepapi.psbin.db2v52 (for DB2 UDB Version 5.2) prepapi.psbin (for DB2 UDB Version 6.1) Title : DATABASE 2 API REFERENCE - PRECOMPILER APIs SUPPLEMENT An SQL precompiler examines source code and processes SQL statements to generate modified source code for your application program. This document explains how you can create your own precompiler to support additional features or languages, using the Precompiler Services interface provided by DB2. qanda.txt Title : DB2/2 and DB2/6000 Common Questions and Answers This ascii file contains a formatted version of all of the common questions and answers and problems and solutions which are asked of the product service teams. This document is avialble to assist our customers in quickly getting solutions to problems and answers to questions, without having to call anyone.