CONTENTS Title Page Copyright Page Send Us Your Comments Preface 1 Preparing to Install DEC Rdb 1.1 DEC Rdb Packaging 1.2 Required Operating System Components 1.3 Prerequisite and Optional Software 1.3.1 Prerequisite Software 1.3.1.1 Operating System Requirements 1.3.1.2 Multiversion Variant Requirements 1.3.1.3 Standard Version Installation 1.3.1.4 DEC C/C++ Run-Time Components Considerations 1.3.1.5 Thai Collating Sequence Save Set 1.3.1.6 EPC$SHR.EXE Shared Image 1.3.2 Optional Software 1.4 Prerequisite Hardware 1.5 OpenVMS License Management Facility 1.6 Preparing Your System and the Installing Account 1.6.1 Recover All DEC Rdb Databases 1.6.2 Backup, Restore, and Recovery Operations with a New Version of DEC Rdb 1.6.2.1 Upgrading from DEC Rdb V3.0 Through V6.0 to V6.1 1.6.2.2 Upgrading from DEC Rdb V2.n to V6.1 1.6.3 Reverting to V3.1 Through V6.0 from V6.1 1.6.4 Disk Space Required 1.6.5 CDD/Repository Considerations 1.6.6 Shut Down the DEC Rdb Monitor 1.6.7 OpenVMS Privileges Required 1.6.8 Process Account Password Must Not Be Locked 1.6.9 Process Account Quotas Required 1.6.10 System Parameter Values Required 1.6.10.1 Checking GBLPAGES and GBLSECTIONS Values 1.6.10.2 Checking Other System Parameter Values 1.6.10.3 Changing System Parameter Values with AUTOGEN 1.6.10.4 Setting Dynamic System Parameters 1.6.11 Back Up Your System Disk 1.6.12 Avoid Giving Users Access to Online Help 1.6.13 Prevent Interactive Users from Gaining Access to the System 1.6.14 Time Required 1.7 Preinstallation Checklist 2 Installing DEC Rdb 2.1 Accessing the Online Release Notes 2.2 Installation Procedure 2.2.1 Invoking VMSINSTAL 2.2.2 Steps of the Installation Procedure 2.3 Errors That Cause the Installation or IVP to Fail 3 After Installing DEC Rdb 3.1 Returning the System to Original Settings 3.2 Starting and Shutting Down DEC Rdb 3.2.1 Editing the System Startup File 3.2.2 Editing the System Shutdown File 3.2.3 Defining LNK$LIBRARY and SQL$USER to Ease Program Linking 3.2.4 Running RMONSTART Manually 3.3 Modifying System Parameters 3.4 Rebooting the System 3.5 Enabling DEC Rdb on Other VAXcluster and VMScluster Nodes 3.5.1 Using SYSMAN to Load Licenses, Run Startup Procedures, and Run the IVP on Each Node 3.5.2 Executing RDBSERVER_NCP.COM in a DECnet Environment 3.5.3 Executing RDBSERVER_NCL.COM in a DECnet/OSI Environment 3.6 Minimum User Account Privileges and Quotas 3.7 Converting Existing Databases 3.8 Tailoring Your System 3.8.1 Defining SYS$LANGUAGES 3.8.2 Setting Up DECtrace 3.8.3 Using the RDB$REMOTE Account for Remote Access 3.8.4 Moving DEC Rdb Demonstration and Sample Database Files to Another Directory 3.8.5 Displaying a List of Files Installed by DEC Rdb 3.9 Installing DEC Rdb Images as Shared 3.10 Installing DEC Rdb Images as Resident on OpenVMS AXP 3.11 Installing SQL Images for Privileged Applications 3.12 CDD/Repository Installed but Not Started Prior to Installation 3.13 Running the IVP Separately 3.14 Returning Read-Only Storage Areas to Original Settings 3.15 Adding DEC Ada Files to the Library 3.16 Deleting Versions of DEC Rdb 3.17 Determining and Reporting Problems 4 Using Multiple Versions of DEC Rdb 4.1 Overview of Multiple-Version Support in DEC Rdb 4.1.1 General Multiversion Support Considerations 4.1.2 Layered Product Considerations 4.1.3 CDD/Repository Considerations 4.2 General Instructions for Installing the Multiversion Variant 4.3 Accessing Multiple Versions of DEC Rdb 4.3.1 Changing the Default DEC Rdb Environment 4.3.2 Setting Symbols with DECRDB$SETVER RESET 4.3.3 Matching Environment and Database Versions 4.3.4 Identifying Environment Versions with DECRDB$SHOVER 4.3.5 Linking Programs 4.3.6 Using LSE Templates in SQL 4.3.7 Accessing Remote Databases 4.3.8 Accessing Online Help 4.4 How Applications Access Multiple Versions of DEC Rdb 5 Using Remote Databases 5.1 Introduction to Remote Database Access with DEC Rdb 5.2 Setting Up the System for Remote Access 5.2.1 Setting Up Remote Access in DECnet Phase IV 5.2.1.1 Verifying the RDBSERVER DECnet Object in the Network Control Program (NCP) 5.2.1.2 Verifying Matching Passwords for the RDB$REMOTE Account in UAF and for the RDBSERVER DECnet Object in NCP 5.2.2 Setting Up Remote Access in DECnet/OSI 5.2.3 Setting Up Remote Access in TCP/IP Services 5.2.4 Verifying the Setup of the RDB$REMOTE Account in the OpenVMS Authorize Utility 5.2.5 Enabling the RDB$REMOTE Account in the OpenVMS Authorize Utility 5.3 Granting Database Privileges for Remote and Network Access 5.3.1 Granting Database Privileges to the RDB$REMOTE Account for Remote Access 5.3.2 Controlling Database Privileges for Network Access 5.4 Improving Performance When Attaching to a Remote Database 5.4.1 Specifying Configuration Files to Improve Remote Access 5.4.2 Creating a Configuration File 5.4.2.1 Specifying the SQL_DEFAULTS_RESTRICTION Parameter 5.4.2.2 Specifying the SQL_ENABLE_PROBE Parameter 5.4.2.3 Specifying the SQL_MESSAGE_VECTOR_RETURN_TYPE Parameter 5.4.2.4 Specifying the SQL_NETWORK_BUFFER_SIZE Parameter 5.4.2.5 Specifying the SQL_NETWORK_NUMBER_ATTACHES Parameter 5.4.2.6 Specifying the SQL_NETWORK_TRANSPORT_TYPE Parameter 5.4.2.7 Specifying the SQL_RCV_PREFETCH_ROWS Parameter 5.4.2.8 Specifying the SQL_SGS_PREFETCH_ROWS Parameter 5.4.2.9 Specifying the SQL_USERNAME and SQL_PASSWORD Parameters 5.4.3 Modifying LOGIN.COM to Improve Network Performance 5.5 Troubleshooting for Remote Access 5.5.1 Retaining Asynchronous System Traps to Access a Remote Database 5.5.2 Troubleshooting Application-Specific Problems 5.5.2.1 Avoiding Undetected Deadlock with Distributed Transactions 5.5.2.2 Restrictions on Distributed Transactions Related to the DISTRIBTRAN Security Privilege 5.5.3 Troubleshooting Summary A OpenVMS Security and DEC Rdb A.1 OpenVMS Privileges Used to Install DEC Rdb A.2 OpenVMS Privileges Required for RMU Commands A.3 OpenVMS Privileges That Override DEC Rdb Protection A.4 OpenVMS Protection of DEC Rdb Files A.5 DEC Rdb Internal Protection A.6 Auditing B Sample Installation: Development Kit