CONTENTS

  Title Page

  Copyright Page

  Preface

  1      General Information

  1.1     Installation Process
    1.1.1      Requirements for Installing Data Distributor
    1.1.2      Changing the Internal Structure of a Transfer Database
    1.1.3      Changing the Internal Structure of a Source Database
    1.1.4      Changing the Internal Structure of a Target Database

  1.2     Where to Find Online Help and Error Message Documentation
    1.2.1      Getting Help on Data Distributor Statements
    1.2.2      Error Messages

  2      New and Changed Features

  2.1     Transfers to Existing Databases

  2.2     New and Changed Table Definitions
    2.2.1      Target Database Table Definitions
    2.2.2      Transfer Database Table Definitions

  2.3     Target Domain Description Changes

  2.4     New and Changed Target Index Definitions

  2.5     Rdb/VMS Version 4.0 Changes Affecting Data Distributor
    2.5.1      Default Database and Table Protection
    2.5.2      New SIGNED BYTE Datatype

  2.6     Replication Transfers Performance Option

  2.7     Limiting Concurrent Transfers on a CPU

  2.8     DEC RdbAccess for VMS, ORACLE Server Software Support

  3      Problems Corrected

  3.1     Inconsistent Replicated Data When Triggers Are Involved

  3.2     Retrying Lock Conflict and Deadlock Errors

  3.3     Serial Execution of Reinitialized Replication Transfers

  3.4     Bad SQL Transfer Definition from VIDA for DB2

  3.5     Incorrect EPILOGUE Status Codes

  4      Known Problems and Restrictions

  4.1     Using LIB$DT_INPUT_FORMAT to Change Date Input Format

  4.2     Restrictions for Extraction, Extraction Rollup, and Replication Transfers
    4.2.1      Data Distributor Version 2.2 CREATE TRANSFER Statement Syntax Change and Existing Command Procedures
    4.2.2      Transfer Schedule Defined for Time Before Transfer Execution
    4.2.3      Transfer Completion Status After a Transfer Is Stopped
    4.2.4      Data Definition Changes After a Transfer Is Defined
    4.2.5      Information Retrieval from a Transfer Database

  4.3     Restriction for Extraction and Extraction Rollup Transfers Only
    4.3.1      SQL Does Not Translate Logical Names Referencing Source Databases

  4.4     Restriction for Extraction Transfers Only
    4.4.1      Views Containing Computed_By Columns Cannot Become Tables

  4.5     Restrictions for Extraction Rollup Transfers Only
    4.5.1      Column Names for Like Tables Must Be Identical
    4.5.2      SQL Privileges Can Restrict Access to Source Tables

  4.6     Restrictions for Replication Transfers Only
    4.6.1      Restriction on Fields Named in an Rdb/VMS RDO RSE
    4.6.2      Restriction on Columns Named in an SQL Select Expression
    4.6.3      Deleting Transfer Definitions
    4.6.4      Restriction on Two-Way Replication Transfers

  4.7     Restrictions for Transferring Into an Existing Database
    4.7.1      Transferring a Table to an Existing Database Containing the Same Table Name
    4.7.2      No Extraction Rollup Into Existing Databases
    4.7.3      No Union of Source and Target Data
    4.7.4      No DEFINE TRANSFER Into an Existing Database

  4.8     Cluster Restrictions
    4.8.1      Load Balancing in a Cluster

  TABLES

  2-1        Columns for the RDB$VINTAGE Table

  2-2        Columns for the RDBVMS$TRANSFER_OWNER Table

  2-3        New Columns for the DDAL$TRANSFERS Table

  2-4        New Columns for the DDAL$TRANSFER_VIEWS Table

  2-5        New Domain Descriptions

  2-6        Indexes for the RDB$CHANGES Table

  2-7        Equivalence Names for Index Logicals

  3-1        Corrected Status Codes

  4-1        Transfer Database Tables