CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  Part 1   DEC OSF/1 AXP

  1      Preparing to Install SQL/Services for DEC OSF/1 AXP
    1.1 Reading the Online Release Notes
    1.2 Checking Installation Procedure Requirements

  2      Installing SQL/Services for DEC OSF/1 AXP
    2.1 Using CD-ROM Consolidated Distribution Media
    2.2 Using an RIS Distribution Area
    2.3 Responding to Installation Procedure Prompts
      2.3.1      Selecting Subsets
      2.3.2      Monitoring Displays During the Subset Loading Process

  3      After Installing SQL/Services for DEC OSF/1 AXP
    3.1 Running the Installation Verification Procedure
    3.2 Deleting SQL/Services for DEC OSF/1 AXP from Your System
    3.3 Starting SQL/Services
      3.3.1      Configuring an SQL/Services System for Reboot
      3.3.2      Files Located in /tmp and Potential File Name Conflicts
      3.3.3      System Names of Objects
      3.3.4      SQL/Services Server-Related Processes Created on Your System
    3.4 Displaying Documentation from CD-ROM

  4      Managing an SQL/Services System on DEC OSF/1 AXP
    4.1 Getting Started
      4.1.1      Tailoring an SQL/Services Server
      4.1.2      Setting Shared Memory Size
      4.1.3      Setting Up Dispatchers and Transport Selection
      4.1.4      Setting Up Executors for Service and Types of Reuse
        4.1.4.1      Session Reusable Generic Services
        4.1.4.2      Session Reusable Database Services
        4.1.4.3      Transaction Reusable Database Services
        4.1.4.4      When to Use Session Reusable Versus Transaction Reusable Database Executors
      4.1.5      Setting Up Security on Servers
        4.1.5.1      Client Identification and Authentication
        4.1.5.2      Service Access Authorization
        4.1.5.3      Database and Data Access Authorization
        4.1.5.4      How Server Security Tiers Work
      4.1.6      Establishing the Default Schema Name
      4.1.7      Using an SQL Initialization File
      4.1.8      How to Decide Which Types of Service to Provide to Clients
        4.1.8.1      Deciding Whether to Use Generic Services or Database Services
        4.1.8.2      Deciding Whether to Turn Impersonation On or Off
        4.1.8.3      Deciding Whether to Authorize Unknown Users to Access a Service
        4.1.8.4      Deciding Whether to Grant Access to a Service to All Users or to Restrict Access to a Specified List of Use
        4.1.8.5      Deciding Whether to Provide Arbitrary Access to Data or Predefined Access to Data
      4.1.9      Making Modifications to a Configuration or to a Running Server
        4.1.9.1      Creating a Multinode Configuration
      4.1.10     Activating Configuration and Server Changes
      4.1.11     What You Start with After Installing SQL/Services
      4.1.12     What You Start with After Running the SQS_MANAGE Scripts
      4.1.13     Isolating Problems
      4.1.14     Solving Server Errors
      4.1.15     Submitting Software Problem Reports
    4.2 Management Commands
      4.2.1      Syntax Conventions
      4.2.2      How SQS_MANAGE Commands Work

  @ command

  ALTER EXECUTORS FOR SERVICE command

  ALTER SERVER command

  CLOSE command

  CONNECT TO SERVER command

  CREATE DISPATCHER command

  CREATE EXECUTORS FOR SERVICE command

  CREATE SERVER command

  CREATE SERVICE command

  DISCONNECT SERVER command

  DROP command

  EXIT command

  GRANT USE ON SERVICE command

  HELP command

  -input command

  OPEN command

  -output command

  -prompt command

  REVOKE USE ON SERVICE command

  SET CONFIG_FILE command

  SET OUTPUT command

  SET SERVER command

  SET VERIFY command

  SHOW CLIENTS FOR SERVICE command

  SHOW CONNECTS command

  SHOW DISPATCHER command

  SHOW EXECUTORS FOR SERVICE command

  SHOW PRIVILEGES FOR SERVICE command

  SHOW SERVER command

  SHOW SERVICE command

  SHOW SETTINGS command

  SHUTDOWN EXECUTORS FOR SERVICE command

  SHUTDOWN SERVER command

  START DISPATCHER command

  START EXECUTORS FOR SERVICE command

  START MONITOR command

  START SERVER command
    4.3 Maintaining an SQL/Services Server
      4.3.1      Relocating Log, Dump, and Lock Files
      4.3.2      Monitoring Server Activity
      4.3.3      Recovering from Failures

  Part 2   OpenVMS

  5      Preparing to Install SQL/Services for OpenVMS AXP and OpenVMS VAX
    5.1 Required Operating System Components
    5.2 Prerequisite and Optional Software
      5.2.1      Prerequisite Software
      5.2.2      Optional Software
    5.3 Prerequisite Hardware
    5.4 Installation Requirements
      5.4.1      Disk Space
      5.4.2      Replacing API Images, Server Images, and Files
      5.4.3      SQL/Services May Overwrite Site Specific Modifications
      5.4.4      Required OpenVMS Privileges
      5.4.5      Required User Limits and SYSGEN Parameters
      5.4.6      Back Up Your System Disk
      5.4.7      Avoid Giving Users Access to Help
      5.4.8      Prevent Interactive Users from Gaining Access to the System
      5.4.9      Time Required to Install SQL/Services
      5.4.10     UICs for the SQLSRV$SRV Account and Instructions on How to Find a Free UIC
    5.5 Preinstallation Checklist

  6      Installing SQL/Services for OpenVMS AXP and OpenVMS VAX
    6.1 Accessing the Online Release Notes
    6.2 Installation Procedure
      6.2.1      Invoking VMSINSTAL
      6.2.2      Steps of the Installation Procedure
      6.2.3      Completing the Installation Procedure
    6.3 Errors That Cause the Installation to Fail
    6.4 SQL/Services Troubleshooting Suggestions
      6.4.1      Common SQL/Services Network Errors
      6.4.2      Common SQL/Services Fatal Execute Server Errors
      6.4.3      Common SQL/Services API Installation Failures

  7      After Installing SQL/Services for OpenVMS AXP and OpenVMS VAX
    7.1 Editing the System Files
    7.2 VAXcluster and VMScluster Considerations
      7.2.1      Using SYSMAN to Run Startup Procedures and Run the IVP on Each Node
    7.3 Tailoring Your System
      7.3.1      Using Logical Names Created by the Installation Procedure
      7.3.2      Displaying a List of Files Installed by SQL/Services
      7.3.3      Restore Any Site Specific Modifications You May Have Made
      7.3.4      Modifying the SQL/Services Configuration File
      7.3.5      Configuring the IPX/SPX Server Environment
    7.4 Enhancing SQL/Services Performance
      7.4.1      Tuning Your System
      7.4.2      Installing SQL/Services Images as Shared
    7.5 Running the SQL/Services Installation Verification Procedure (IVP) Independently
    7.6 Returning the System to Original Settings
    7.7 Deleting Versions of DEC Rdb
    7.8 Determining and Reporting Problems
    7.9 Postinstallation Checklist

  8      Managing an SQL/Services System on OpenVMS AXP and OpenVMS VAX
    8.1 Process Pooling Overview
      8.1.1      Process Pooling Components
      8.1.2      How the Communications Server Process Functions
        8.1.2.1      Reading the Default Configuration File
        8.1.2.2      Modifying the Configuration File
      8.1.3      Execute Server Processes
        8.1.3.1      Choosing an Execute Server Type
        8.1.3.2      Choosing Generic Class Execute Server Processes
        8.1.3.3      Choosing Database Class Execute Server Processes
        8.1.3.4      Using the IDLE Parameter to Control Execute Server Processes
      8.1.4      Execute Server Process Reporting
    8.2 Methods of Accessing the SQL/Services Server
      8.2.1      How to Enable Server Access
        8.2.1.1      Explicit Access
        8.2.1.2      Proxy-Like Access (Only for DECnet)
        8.2.1.3      Default Account Access
        8.2.1.4      Network Access Required
    8.3 Purging Server Log Files

  9      Using Multiple Versions of DEC Rdb with SQL/Services
    9.1 Overview of Multiversion Support in SQL/Services
    9.2 How to Run Against Multiple Versions of DEC Rdb with SQL/Services
    9.3 Merging Your Previous Configuration File to Include Database Definitions
    9.4 Activating Configuration File Changes

  Part 3   Common Information

  10     Transport Guidelines and Error Codes
    10.1 Supported Transports and Guidelines
      10.1.1     DECnet Transport Guidelines
      10.1.2     TCP/IP Transport Guidelines
      10.1.3     AppleTalk Transport Guidelines
      10.1.4     IPX/SPX Transport Guidelines
    10.2 Network Errors

  A Installing the SQL/Services OpenVMS VAX and OpenVMS AXP Client APIs
    A.1 Who Should Install the SQL/Services OpenVMS VAX or OpenVMS AXP Client API?
    A.2 Installation Flowchart for Installing the SQL/Services OpenVMS VAX or OpenVMS AXP Client API
    A.3 Preparing to Install the SQL/Services OpenVMS VAX or OpenVMS AXP Client API
      A.3.1      Prerequisite Software
      A.3.2      Installation Procedure Requirements
        A.3.2.1      Time
        A.3.2.2      Privileges
        A.3.2.3      Disk Space
        A.3.2.4      VMSINSTAL Requirements
        A.3.2.5      Backing Up Your System Disk
    A.4 Installing the SQL/Services OpenVMS VAX or OpenVMS AXP Client API
      A.4.1      Accessing the Distribution Kit
        A.4.1.1      Accessing the Distribution Kit Using TCP/IP
        A.4.1.2      Accessing the Distribution Kit Using DECnet
      A.4.2      Installation Procedure
      A.4.3      Recovering from Errors
    A.5 Postinstallation Procedures
      A.5.1      Files Added to the System
      A.5.2      Running the IVP
    A.6 Sample Installation

  B Installing the SQL/Services MS-DOS and MS Windows Client APIs
    B.1 Installation Flowchart for Installing the SQL/Services MS-DOS and MS Windows Client APIs
    B.2 Preparing to Install the SQL/Services MS-DOS and MS Windows Client APIs
      B.2.1     Prerequisite Software
      B.2.2     Installation Procedure Requirements
        B.2.2.1      Time
        B.2.2.2      Disk Space
        B.2.2.3      Installation Requirements
    B.3 Installing the SQL/Services MS-DOS and MS Windows Client APIs
      B.3.1     Installation Procedure
        B.3.1.1      Copying and Running the Installation Program
      B.3.2     Verifying the Installation
        B.3.2.1      Running the MS-DOS Client API IVP
        B.3.2.2      Running the MS Windows Client API IVP
      B.3.3     Recovering from Errors
    B.4 Postinstallation Procedures
      B.4.1     Files Added to the System
      B.4.2     Running the IVP
      B.4.3     Support for PATHWORKS V5.0 for DOS (TCP/IP)
    B.5 The sqsapiw.ini File

  C Installing the DEC ODBC Driver for the MS Windows Operating System Software
    C.1 Installation Flowchart for Installing the ODBC Driver Software
    C.2 Preparing to Install the ODBC Driver Software
      C.2.1      Prerequisite Software
      C.2.2      Installation Procedure Requirements
        C.2.2.1      Time
        C.2.2.2      Disk Space
    C.3 Installing the ODBC Driver Software
      C.3.1      Copying and Running the Installation Program
      C.3.2      Recovering from Errors
    C.4 Postinstallation Procedures
      C.4.1      Files Added to the System
      C.4.2      Configuring the DEC Rdb Data Sources

  D Installing the DEC ODBC Driver for the Windows NT PC Operating System Software
    D.1 Installation Flowchart for Installing the ODBC Driver Software
    D.2 Preparing to Install the ODBC Driver Software
      D.2.1     Prerequisite Software
      D.2.2     Installation Procedure Requirements
        D.2.2.1      Time
        D.2.2.2      Disk Space
    D.3 Installing the ODBC Driver Software
      D.3.1     Copying and Running the Installation Program
      D.3.2     Recovering from Errors
    D.4 Postinstallation Procedures
      D.4.1     Files Added to the System
      D.4.2     Configuring the DEC Rdb Data Sources

  E Installing the SQL/Services Windows NT PC or Windows NT AXP Client API
    E.1 Installation Flowchart for Installing the SQL/Services Windows NT PC or Windows NT AXP Client API
    E.2 Preparing to Install the SQL/Services Windows NT PC or Windows NT AXP Client API
      E.2.1      Prerequisite Software
      E.2.2      Installation Procedure Requirements
        E.2.2.1      Time
        E.2.2.2      Disk Space
        E.2.2.3      Installation Program Requirements
    E.3 Installing the SQL/Services Windows NT PC or Windows NT AXP Client API
      E.3.1      Installation Procedure
        E.3.1.1      Copying and Running the Installation Program
      E.3.2      Verifying the Installation
        E.3.2.1      Running the Windows NT PC or Windows NT AXP Client API IVP
      E.3.3      Recovering from Errors
    E.4 Postinstallation Procedures
      E.4.1      Files Added to the System
      E.4.2      Running the IVP
    E.5 The sqsapi32.ini File

  F Installing the SQL/Services DEC OSF/1 AXP or ULTRIX for RISC Client API
    F.1 Installation Flowchart for Installing the SQL/Services DEC OSF/1 AXP or ULTRIX for RISC Client API
    F.2 Preparing to Install the SQL/Services DEC OSF/1 AXP or ULTRIX for RISC Client API
      F.2.1      Prerequisite Software
      F.2.2      Installation Procedure Requirements
        F.2.2.1      Time
        F.2.2.2      Superuser Privileges
        F.2.2.3      Disk Space
        F.2.2.4      Installation Requirements
    F.3 Installing the SQL/Services DEC OSF/1 AXP or ULTRIX for RISC Client API
      F.3.1      Installation Procedure
      F.3.2      Recovering from Errors
    F.4 Postinstallation Procedures
      F.4.1      Files Added to the System
      F.4.2      Running the IVP
    F.5 Sample Installation

  G Installing the SQL/Services ULTRIX for VAX Client API
    G.1 Installation Flowchart for Installing the SQL/Services ULTRIX for VAX Client API
    G.2 Preparing to Install the SQL/Services ULTRIX for VAX Client API
      G.2.1     Prerequisite Software
      G.2.2     Installation Procedure Requirements
        G.2.2.1      Time
        G.2.2.2      Superuser Privileges
        G.2.2.3      Disk Space
        G.2.2.4      Installation Program Requirements
    G.3 Installing the SQL/Services ULTRIX for VAX Client API
      G.3.1     Installation Procedure
      G.3.2     Recovering from Errors
    G.4 Postinstallation Procedures
      G.4.1     Files Added to the System
      G.4.2     Running the IVP
    G.5 Sample Installation

  H Installing the SQL/Services SunOS Client API
    H.1 Installation Flowchart for Installing the SQL/Services SunOS Client API
    H.2 Preparing to Install the SQL/Services SunOS Client API
      H.2.1     Prerequisite Software
      H.2.2     Installation Procedure Requirements
        H.2.2.1      Time
        H.2.2.2      Superuser Privileges
        H.2.2.3      Disk Space
        H.2.2.4      Installation Program Requirements
    H.3 Installing the SQL/Services SunOS Client API
      H.3.1     Installation Procedure
      H.3.2     Recovering from Errors
    H.4 Postinstallation Procedures
      H.4.1     Files Added to the System
      H.4.2     Running the IVP
    H.5 Sample Installation

  I Installing the SQL/Services OS/2 Client API
    I.1 Installation Flowchart for Installing the SQL/Services OS/2 Client API
    I.2 Preparing to Install the SQL/Services OS/2 Client API
      I.2.1      Prerequisite Software
      I.2.2      Installation Procedure Requirements
        I.2.2.1       Time
        I.2.2.2       Disk Space
        I.2.2.3       Installation Program Requirements
    I.3 Installing the SQL/Services OS/2 Client API
      I.3.1      Installation Procedure
      I.3.2      Verifying the Installation
      I.3.3      Recovering from Errors
    I.4 Postinstallation Procedures
      I.4.1      Files Added to the System
      I.4.2      Running the IVP
    I.5 Sample Installation

  J Installing Client API Software for Macintosh Computers
    J.1 Installation Flowchart for Installing the SQL/Services Macintosh for MPW or Macintosh for THINK C Client API
    J.2 Preparing to Install the SQL/Services Macintosh Client APIs
      J.2.1      Prerequisite Software for the Macintosh Client System
        J.2.1.1      Macintosh Prerequisite System Software
        J.2.1.2      Macintosh for MPW Client API Prerequisite Software
        J.2.1.3      Macintosh for THINK C Client API Prerequisite Software
        J.2.1.4      PATHWORKS Components Needed for Installation
      J.2.2      Prerequisite Software for the OpenVMS Server System
      J.2.3      Installation Procedure Requirements
        J.2.3.1      Time
        J.2.3.2      Disk Space
        J.2.3.3      Installation Program Requirements
    J.3 Server Portion of Installation
      J.3.1      Adding and Mounting the Installation Volume
      J.3.2      Adding the SQLSRV$Volume Installation Volume to the Server
    J.4 Client Portion of Installation
      J.4.1      Mounting the SQLSRV$Volume Installation Volume on the Macintosh
    J.5 Using an SQL/Services Macintosh Client Self-Extracting Archive File
    J.6 Installing the SQL/Services Macintosh for MPW Client API
      J.6.1      Macintosh for MPW Client API Installation Procedure
      J.6.2      Macintosh for MPW Client API Installation Files
    J.7 Installing the SQL/Services Macintosh for THINK C Client API
      J.7.1      Macintosh for THINK C Client API Installation Procedure
      J.7.2      Macintosh for THINK C Client API Installation Files
    J.8 Recovering from Errors

  K Sample Installation:  Full Development Kit