CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Introduction to SQL Access Server for Rdb/VMS

  1.1     What Is the SQL Access Model?

  1.2     Overview of SQL Access Server for Rdb/VMS Architecture
    1.2.1      SQL Access Client
    1.2.2      Network Communication (Transport)
    1.2.3      SQL Access Server Process

  1.3     How SQL Access Server for Rdb/VMS Works
    1.3.1      Communication Server Process
    1.3.2      Execution Server Process

  2      Managing SQL Access Server for Rdb/VMS

  2.1     Authorizing Access to SQL Access Server

  2.2     Overview of System Management Command Procedures
    2.2.1      Starting Up SQL Access Server
    2.2.2      Shutting Down SQL Access Server
      2.2.2.1      Using SQLA_SHUTDOWN
      2.2.2.2      Using SQLA_WINDDOWN
    2.2.3      Flushing Logging Buffers

  2.3     Monitoring the Size and Number of Log Files
    2.3.1      Deleting Log Files
    2.3.2      Using VMS File Version Limit

  2.4     VMS Logical Names Used By SQL Access Server

  3      Configuring SQL Access Server for Rdb/VMS

  3.1     Sample Configuration File Created During Installation

  3.2     Configuration File Parameters

  3.3     Selecting Values for Configuration Parameters
    3.3.1      Selecting Values for the min_servers Parameter
    3.3.2      Selecting Values for the max_servers Parameter
    3.3.3      Selecting Values for the max_idle_servers Parameter
    3.3.4      Selecting Values for Other Parameters

  3.4     Rules for Specifying Parameters
    3.4.1      Specifying Open Systems Interconnection (OSI) Selector Parameters
    3.4.2      Specifying Default Values
    3.4.3      Modifying the Configuration File

  3.5     Procedure for Modifying the Configuration File
    3.5.1      Annotated Sample Configuration File

  4      Monitoring SQL Access Server for Rdb/VMS

  4.1     Guidelines for Logging

  4.2     Configuring Log Files
    4.2.1      Logging to One File
    4.2.2      Logging to Multiple Files

  4.3     Methods for Specifying Logging
    4.3.1      Configuration File Method
      4.3.1.1      Logging to One File
      4.3.1.2      Logging to Multiple Files
    4.3.2      Logical Name Method

  4.4     Disabling Logging

  4.5     Using Logging Flags

  4.6     Guidelines for Specifying Logging Flags

  4.7     Annotated Sample Logs

  4.8     Interpreting Log Files

  5      Features of Digital's SQL Access Server for Rdb/VMS Implementation

  5.1     Coding Specifications

  5.2     Comparing Data Types
    5.2.1      Comparing SQL Access Data Types to SQL Data Types for Rdb/VMS
    5.2.2      Comparing SQL Data Types for Rdb/VMS to SQL Access Data Types
    5.2.3      Segmented Strings
    5.2.4      Date Data Type

  5.3     Understanding SQL Access Server Behavior
    5.3.1      Using Null Fields
    5.3.2      Using Escape Clauses
    5.3.3      Using Data Definition Language (DDL) Statements and Data Manipulation Language (DML) Statements in Transactions
    5.3.4      Using R-Cancel and R-Status Requests

  5.4     Interpreting the Data-Resource-Name Parameter

  A   Location and Structure of Error Messages

  A.1     Where to Find Error Message Documentation

  A.2     How Error Messages are Structured

  EXAMPLES

  3-1        Configuration File Created During Installation

  3-2        Correctly Specifying a Default Value

  3-3        Incorrectly Specifying a Default Value

  3-4        Annotated Configuration File

  4-1        How to Disable Logging in Configuration File

  4-2        Specifying Logging Flags in the Configuration File

  4-3        Specifying Logging Flags Using Logical Names

  4-4        Logging Flags That Generate Few Log Messages

  4-5        Logging Flags That Generate Many Log Messages

  4-6        Logging Flags Digital Recommends

  4-7        Annotated Log File

  5-1        How to Specify a Date

  FIGURES

  1-1        Components of the SQL Access Model

  1-2        Overview of the SQL Access Server for Rdb/VMS Architecture

  1-3        How SQL Access Server for Rdb/VMS Works Using OSI Communications

  4-1        Logging to One Log File

  4-2        Logging to Multiple Files

  TABLES

  3-1        Configuration File Parameters

  4-1        Logging Flags

  5-1        Mapping SQL Access Data Types to SQL Data Types for Rdb/VMS

  5-2        Mapping SQL Data Types for Rdb/VMS to SQL Access Data Types

  A-1        Explanation of Severity Codes