CONTENTS

  Title Page

  Copyright Page

  Preface

  1      New Features and Technical Changes
    1.1 Multiversion Environment Available
      1.1.1      Accessing Multiple Versions of DEC DBMS
      1.1.2      Multiversion Restrictions and Guidelines
    1.2 Converting Databases with DBO/CONVERT/COMMIT
      1.2.1      Database Conversion Restrictions
    1.3 DBO/VERIFY/OPTIMIZE Command
      1.3.1      DBO/VERIFY/OPTIMIZE Split Into Two Functions
    1.4 Expanded Optional Dictionary Usage
      1.4.1      Restrictions and Limitations on Optional Dictionary Usage
    1.5 Reload Performance Enhanced
    1.6 DBO/OPTIMIZE/AFTER_JOURNAL Performance Improved
    1.7 Closing a Database with DBO/CLOSE/WAIT
    1.8 Altering .RUJ File Names
    1.9 DRU Data Type Change Definitions Enhanced
    1.10 DBO/RECOVER/OUTPUT Captures Utility Output
    1.11 Setting Extend Size for Backup Files
    1.12 Batch Write Functionality Added
    1.13 Prefetch Functionality for DBO/CREATE and DBO/MODIFY
    1.14 DBO/ANALYZE Record Summary Report Enhanced
    1.15 Oracle TRACE Instrumentation Enhanced
    1.16 Sequential Scan of Area Enhanced
    1.17 Disabling Prestart Transactions
    1.18 Enhancements Made to DBO/SHOW STATISTICS Displays
      1.18.1     Statistics Display Allowed During Area Reload
      1.18.2     "Summary IO Statistics" Screen Displays By-File Information for .ACE File
      1.18.3     "IO Stall" Screen Displays Process Hibernation Information
      1.18.4     Statistics Input-File Replay Enhanced
      1.18.5     "Transaction Durations" Screen Enhanced
      1.18.6     "Record Statistics" Screen Shows Discarded Pages
      1.18.7     "File IO Overview" Screen Added
      1.18.8     Resetting Database Statistics
      1.18.9     Lock Information Display Enhanced
      1.18.10    Alarm Option Rings Terminal Bell
      1.18.11    CPU Utilization Displayed for a Specific Database
      1.18.12    "Custom Statistics" Screen
      1.18.13    By-Area Information Added to Statistics Output Files
      1.18.14    Binary Output File Changes
      1.18.15    Notepad Added to Utility
      1.18.16    Determining Process Checkpoint Information
      1.18.17    Determining Global Buffer Utilization
        1.18.17.1    "GB Frequency" Screen
        1.18.17.2    Global Buffer Information Submenu
      1.18.18    Identifying Causes of Increased Database Root File I/O
      1.18.19    Determining the Number of Read-Only Transactions
      1.18.20    Determining "By-Device" Information

  2      Problems Corrected in DEC DBMS Version 6.1
    2.1 DBM$BIND_BUFFERS Logical and Remote Database Access
    2.2 DBO/VERIFY Error Handling Corrected
    2.3 Phantom Processes Exorcised
    2.4 DBO/ALTER Allowed on Page Number Zero
    2.5 Read-Only Transactions Caused Stall During Backups
    2.6 Bugcheck After Snapshot File Truncation
    2.7 DBO/OPTIMIZE/AFTER_JOURNAL Was Not Allowed with Commit-to-Journal Feature
    2.8 DBO/OPTIMIZE AFTER/LOG/OUTPUT Failed to Record Output File
    2.9 Recovery of Active .AIJ File Could Result in Duplicate Sequence Number
    2.10 DBO/BACKUP/AFTER_JOURNAL/NOQUIET_POINT Made .AIJ File Inaccessible
    2.11 Error Binding to Database During AIJ Backup
    2.12 Fast Commit Could Cause AIJ Backup Corruption
    2.13 Failure to Open .ACE File Shut Down After-Image Journaling
    2.14 AIJ Backup Server Caused Stalls
    2.15 .AIJ Extension Failed with Insufficient Free Disk Space
    2.16 Enabling After-Image Journaling Selected Wrong Journal
    2.17 After-Image Journal Creation Greater Than 2GB Failed
    2.18 DBO/RECOVER Did Not Process Appended .AIJ Files
    2.19 DBO/OPTIMIZE/AFTER_JOURNAL Returned "Record Too Large" FILACCERR Error
    2.20 DBO/RECOVER Permitted on Restored and Modified Databases
    2.21 Two-Phase Page Locking Allowed Access to Uncommitted Pages
    2.22 DBR Exceeded Virtual Address Space with Large Checkpoint Intervals
    2.23 DBO/SHOW STATISTICS Process Accounting Screen Had Duplicate Information
    2.24 Optional Parameter for Dumping Global Buffer Information in Bugcheck Dumps
    2.25 DBR Bugchecked at DBR$REDO+082A
    2.26 Multiple Binds Caused EXQUOTA Exception
    2.27 Problem Processing Options Files on DBO/CREATE and DBO/MODIFY
    2.28 Problem with DECdtm and Cluster Aliases
    2.29 Excessive Stalls and Deadlocks on RWROOT and TSNBLK Locks
    2.30 ACCVIO Sometimes Returned When Using CHECK Clause with OCCURS Item
    2.31 %DBM-F-NOT_MTYP for Storage Schema Set Fixed
    2.32 ABS Only Performs /NOQUIET_POINT AIJ Backups
    2.33 Commit to Journal without Fast Commit Causes Backup Problems
    2.34 DBO/RESTORE/INCREMENTAL Incorrectly Enabled AIJ Journaling
    2.35 Online Database Backup May Not Have Been Recoverable
    2.36 AIJ Backup When Journaling Disabled Produced Bugcheck Dump
    2.37 Bugcheck Dump Occurred When Re-Readying Storage Areas with Fast Commit Enabled
    2.38 AIJ Backup File Size Increased Dramatically
    2.39 Deadlock on .AIJ File Lock X During Journal Switch-Over
    2.40 Bugcheck Dump Was Sent to Terminal If Dump File Could Not Be Created
    2.41 Large Lock Timeout Value Caused Infinite Hang
    2.42 DBO/SHOW STATISTICS "IO Stall Time" Average Misreported
    2.43 Excessive Page Faults Occurred When Binding to a Database
    2.44 Bugcheck Occurred When Trying to Create .RUJ File During Database Bind
    2.45 Bugcheck at PIOGB$PURGE_BUFFER
    2.46 Problem Creating .RUJ File After Database Restore
    2.47 Records Stored Twice Using DBQ
    2.48 Concurrent Retrieval and Multiple Ready Statements
    2.49 Corruption of scroll in index node during index rebalance
    2.50 Deadlock Error Created Unusable Backup Files
    2.51 Problem Verifying During Backup
    2.52 Database Area Marked Inconsistent After Recovery
      2.52.1     Problem Converting a Database with an Explicit RUJ Directory
      2.52.2     Problem Binding to a Database During While Areas Are Moving

  3      Restrictions and Known Problems
    3.1 Restrictions
      3.1.1      DEC DB Integrator Gateway for DBMS Not Started Automatically
      3.1.2      Multiple Streams Cannot Bind for Exclusive Access
      3.1.3      DBO/VERIFY Causes Stall for New Users
      3.1.4      AIJ Process-Global Symbols Defined as Strings
      3.1.5      New Protection Check for OpenVMS Version 6.0
      3.1.6      Not All Software Languages Fully Supported on DEC DBMS for OpenVMS Alpha
      3.1.7      Minimum Version Numbers for Remote Access
      3.1.8      Must Relink Applications Prior to Version 5.0
      3.1.9      Linking Applications on OpenVMS AXP Systems
      3.1.10     H-Floating Point Data Type Not Supported on OpenVMS AXP
      3.1.11     D-Floating Point Data Type Differences Between OpenVMS VAX and OpenVMS AXP
      3.1.12     DML and Long Quoted Strings
      3.1.13     DML and MACRO Object Names Using DEC Ada
      3.1.14     Specifying PSECT Attributes in DEC Pascal on OpenVMS AXP
      3.1.15     DBM$RUJ Logical Name Must Specify a Directory
      3.1.16     Removing Record Occurrences from a Set
      3.1.17     Suppress Natural Alignment Warnings with VAX FORTRAN-HPO
      3.1.18     Cannot Redefine SYS$ERROR During FDML Compilations
      3.1.19     FDML and FORTRAN Error Messages Can Differ
      3.1.20     Two-Phase Commit Restrictions
      3.1.21     Cannot Embed DML Statements in Both Shareable and Main Images
      3.1.22     DCL Command within DBQ Session
      3.1.23     DBQ MACRO or Indirect File Gets Input From Default Input Stream
      3.1.24     Records and Items Cannot Use the Same Name
    3.2 Known Problems
      3.2.1      Processes Stall Waiting for Dbkey Scope Lock
      3.2.2      DEC Pascal on OpenVMS AXP with Callable DBQ for Stream Returns %DBM-F-BADUWALST Error
      3.2.3      Fetch Prior within Index Set May Not Choose the Optimal Retrieval Strategy
    3.3 Documentation Errors and Omissions
      3.3.1      Negating Wildcards in WHERE Clauses
      3.3.2      Keywords for DBO/ALTER Are Incorrect
      3.3.3      Correction to Fast Incremental Backup
      3.3.4      Sample Application Programs Labeled Incorrectly
      3.3.5      Clarification of DBO/SHOW STATISTICS Displayed Value
      3.3.6      Correction to Description of DBO/CREATE/SNAPSHOTS