• ---

  Chapter 1 Information About This Release
  • 1.1 Changes to the Kit and the Installation
    • 1.1.1 Names of Oracle Rdb Kits
    • 1.1.2 Changes to the Installation Procedure
    • 1.1.3 GBLPAGES System Parameter Value Change
    • 1.1.4 Oracle Rdb No Longer Checks LMF Information
  • 1.2 Changes to the Method for Problem Reporting
  • 1.3 Changes in Names of Oracle Rdb Help Files, Command Procedures, Release Notes, and Installation Guides
  • 1.4 Rdb Web Agent
  • 1.5 Supported Platforms and Network Protocols for PC Clients
    • 1.5.1 New Query Performance Tuner
    • 1.5.2 New Parallel Backup Monitor
    • 1.5.3 Oracle RMUwin, Performance Monitor Available on Windows Only
    • 1.5.4 Launching Applications from Oracle Enterprise Manager
  • 1.6 New Hot Standby Database Option
  • 1.7 SGA API Available for Oracle Rdb
  • 1.8 New Features Affecting All Interfaces
    • 1.8.1 SQL_ALTERNATE_SERVICE_NAME Configuration Parameter
    • 1.8.2 CREATE INDEX Optimization for Empty Tables
    • 1.8.3 Eliminating Redundant Sort in Singleton Select
    • 1.8.4 Changes in Cardinality Update Algorithm
    • 1.8.5 Support for XA Transactions
      • 1.8.5.1 Using Oracle Rdb with XA Transaction Managers
      • 1.8.5.2 Relationship of Oracle Rdb Components to DECdtm
      • 1.8.5.3 Relationship of Oracle Rdb Components to an XA Transaction Manager
      • 1.8.5.4 Using SQL with an XA Transaction Manager
      • 1.8.5.5 Recovering from Unresolved Transactions
      • 1.8.5.6 Compliance Information
      • 1.8.5.7 Optional Features
  • 1.9 New Features in SQL
  • 1.10 New Features in Oracle RMU
    • 1.10.1 Enhancements to the RMU Convert Command
    • 1.10.2 Just_Page Qualifier for RMU Restore and Recover Replaced with Just_Corrupt Qualifier
  • 1.11 New Features in the Performance Monitor
    • 1.11.1 New Screens
    • 1.11.2 Enhancements to Existing Screens
  • 1.12 System Metadata Changes
    • 1.12.1 Domain Changes
    • 1.12.2 Owner and Create/Alter Timestamps
    • 1.12.3 Optional RDB$WORKLOAD Table
    • 1.12.4 Modified System Tables
    • 1.12.5 Changes to RDB$TRANSFER_RELATIONS Table
    • 1.12.6 Metadata LIST OF BYTE VARYING Changes
  • 1.13 Application Compatibility Between Oracle Rdb Versions
  • 1.14 Software Requirements
  • 1.15 Documentation for This Release
    • 1.15.1 Online Documentation Format
    • 1.15.2 Documentation for Oracle Rdb for OpenVMS
    • 1.15.3 Documentation for Oracle Rdb for Digital UNIX

• ---

  Chapter 2 Known Problems, Restrictions, and Other Notes
  • 2.1 Known Problems and Restrictions in All Interfaces
    • 2.1.1 Reinstall V7.0 After Installing Previous Versions
    • 2.1.2 Monitor ENQLM Minimum Increased to 32767
    • 2.1.3 Hot Standby Database Option Does Not Support Replication on Digital UNIX
    • 2.1.4 Oracle Rdb Workload Collection Can Stop Hot Standby Replication
    • 2.1.5 Support for Vested Images
    • 2.1.6 RMU Convert Command and System Tables
    • 2.1.7 Converting Single-File Databases
    • 2.1.8 Converting from Versions Earlier Than V5.1
    • 2.1.9 Functionality Not Available on Digital UNIX
    • 2.1.10 Record Caches and Exclusive Access
    • 2.1.11 Strict Partitioning May Scan Extra Partitions
    • 2.1.12 Restriction When Adding Storage Areas with Users Attached to Database
  • 2.2 SQL Known Problems and Restrictions
    • 2.2.1 Behavior of Journaling Using IMPORT
    • 2.2.2 Cannot Alter a Storage Map That Is Vertically Partitioned
    • 2.2.3 SQL Does Not Display Storage Map Definition After Cascading Delete of Storage Area
    • 2.2.4 ARITH_EXCEPT or Incorrect Results Using LIKE IGNORE CASE
    • 2.2.5 Different Methods of Limiting Returned Rows From Queries
    • 2.2.6 Suggestions for Optimal Usage of SHARED DATA DEFINITION Clause for Parallel Index Creation
    • 2.2.7 %SQL-F-IND_EXISTS During Concurrent Index Definition
    • 2.2.8 Side Effect When Calling Stored Routines
    • 2.2.9 Incorrect Processing of Subquery When Nested in FOR Cursor Loop
    • 2.2.10 Nested Correlated Subquery Outer References Incorrect
    • 2.2.11 Additional Usage Notes for Holdable Cursors
    • 2.2.12 Compiling Programs Containing DISCONNECT DEFAULT
  • 2.3 Oracle RMU Known Problems and Restrictions
    • 2.3.1 Default for RMU Checksum and CRC Qualifiers Changing in Future Release
    • 2.3.2 Performance Monitor Collection Cells Are Reused
    • 2.3.3 Collect Optimizer Statistics After Converting a Database to V7.0
    • 2.3.4 RMU Parallel Backup Command Not Supported for Use with SLS
    • 2.3.5 RMUwin, Rdb Performance Monitor Limit Motif Support
  • 2.4 Known Problems and Restrictions in All Interfaces for Version 6.1 and Earlier
    • 2.4.1 Restriction on Tape Usage for Digital UNIX V3.2
    • 2.4.2 Support for Single-File Databases to Be Dropped in a Future Release
    • 2.4.3 DECdtm Log Stalls
    • 2.4.4 You Cannot Run Distributed Transactions on Systems with DECnet/OSI and OpenVMS Alpha Version 6.1 or OpenVMS VAX Version 6.0
    • 2.4.5 Multiblock Page Writes May Require Restore Operation
    • 2.4.6 Oracle Rdb Network Link Failure Does Not Allow DISCONNECT to Clean Up Transactions
    • 2.4.7 Replication Option Copy Processes Do Not Process Database Pages Ahead of an Application
  • 2.5 SQL Known Problems and Restrictions for Oracle Rdb Version 6.1 and Earlier
    • 2.5.1 INCLUDE SQLDA2 Statement Is Not Supported for SQL Precompiler for PL/I in Oracle Rdb V5.0 or Higher
    • 2.5.2 SQL Pascal Precompiler Processes ARRAY OF RECORD Declarations Incorrectly
  • 2.6 Oracle RMU Known Problems and Restrictions for Oracle Rdb Version 6.1 and Earlier
    • 2.6.1 Oracle RMU Commands Pause During Tape Rewind
    • 2.6.2 TA90 and TA92 Tape Drives Are Not Supported on Digital UNIX
  • 2.7 RDML Known Problems and Restrictions for Version 7.0 and Earlier
    • 2.7.1 RDML Generates Undefined Symbol at Link Time Using Multiversion Oracle Rdb
  • 2.8 Oracle CDD/Repository Notes of General Interest
    • 2.8.1 Oracle CDD/Repository Compatibility with Oracle Rdb Features
  • 2.9 Oracle CDD/Repository Restrictions for Oracle RdbV7.0 and Earlier
    • 2.9.1 Multischema Databases and CDD/Repository
    • 2.9.2 Interaction of Oracle CDD/Repository V5.1 and Oracle RMU Privileges Access Control Lists
      • 2.9.2.1 Installing the Corrected CDDSHR Images
      • 2.9.2.2 CDD Conversion Procedure

• ---

  Chapter 3 Software Errors Fixed
  • 3.1 Software Errors Fixed That Apply to All Interfaces
    • 3.1.1 AIJ Switchover Suspension Prone to DBR-Induced Shutdown
    • 3.1.2 Preventing Depletion of AIJ ARB Pool
    • 3.1.3 Process Starvation and Hang During AIJ Switchover
    • 3.1.4 After-Image Journal File Switchover Race Condition Corrected
    • 3.1.5 Failure to Open After-Image Journal No Longer Causes Locking Problems
    • 3.1.6 DDL Operations on After-Image Journal Files No Longer Deadlock with AIJ Switchover
    • 3.1.7 AIJ Inaccessible After Node or Cluster Failure or When the Database Is Stopped with Abort=Delprc Qualifier
    • 3.1.8 User Processes Do Not Hibernate on AIJ Submission
    • 3.1.9 Performance No Longer Degrades in Dynamic OR Optimization
    • 3.1.10 Recovery and Fast Commit No Longer Results in Database Corruption
    • 3.1.11 Recovery Process No Longer Hangs When Using Global Buffers
    • 3.1.12 DBR No Longer Fails During REDO When Fast Commit Is Enabled
    • 3.1.13 DBR No Longer Rolls Back Committed Transaction Data
    • 3.1.14 DBR Now Validates Checkpoint During REDO
    • 3.1.15 PAGE TRANSFER VIA MEMORY and Fast Incremental Backup No Longer Cause PIO$MARK_SNUB Bugcheck
    • 3.1.16 Bugchecks at PIOFETCH$WITHIN_DB + 0784 Eliminated
    • 3.1.17 Bugcheck at Transaction Commit Is Now Fixed
    • 3.1.18 Now Can Create a Database with Lock Partitioning and Global Buffers
    • 3.1.19 Oracle Rdb No Longer Fails on OpenVMS Alpha V7.0
    • 3.1.20 Multiple Connections No Longer Cause Missing Oracle Trace Data
    • 3.1.21 Nominal Record Length Now Stored in AIP for UNIQUE Indexes
    • 3.1.22 Node Size Calculation for Unique Sorted Indexes
    • 3.1.23 Performance Enhancement for Storage Maps and Mapped Indexes
    • 3.1.24 Memory Leak Plugged for Insert with Storage Maps
    • 3.1.25 Update on Rows with Many Missing Values
    • 3.1.26 Long Records on Alpha Platforms No Longer Cause Problems
    • 3.1.27 Record Compression on Alpha Platforms
    • 3.1.28 Database No Longer Hangs If Process Holding Logical Area Lock Does Not Release Lock
    • 3.1.29 Excessive Root File I/O
    • 3.1.30 Applications No Longer Hang When Executive Mode ASTs Are Disabled
    • 3.1.31 CREATE INDEX with SIZE IS Clause No Longer Returns Incorrect Results
    • 3.1.32 LOCK_CONFLICT Error on Multiple Databases No Longer Leaves Transaction Active
    • 3.1.33 System Metadata Index Corruption Fixed
    • 3.1.34 Checksum Errors on Alpha Processors Fixed
    • 3.1.35 Bugchecks at PIOAPF$AST + 78 Fixed
    • 3.1.36 Detach Failure No Longer Returns Invalid Request Handle
    • 3.1.37 Error Details No Longer Lost from Remote Prefetch Operations
    • 3.1.38 Error Details No Longer Lost from Remote Databases
    • 3.1.39 Monitor No Longer Hangs After Certain Period of Activity
    • 3.1.40 Read-Only Transactions No Longer Fail with Deadlocks on SNAPSHOT CURSOR 0
    • 3.1.41 Attached Inactive Processes Now Perform Global Checkpoint Operations
    • 3.1.42 Undetected Global Checkpoint Deadlock Corrected
    • 3.1.43 Null Fields Now Detected from Versioned Tables
    • 3.1.44 System Table and Index Cardinalities Updated
    • 3.1.45 Database Attach No Longer Leaves Extra Channel Assigned
    • 3.1.46 Bugchecks at PSIISCAN$BWS_SEARCH_SCR + D1 No Longer Occur
    • 3.1.47 Invalid Monitor Home Directory No Longer Causes Server Failures
    • 3.1.48 Large Queries No Longer Bugcheck at RDMS$$GEN_ROOM+14
    • 3.1.49 Bugcheck at RDMS$$EXE_CREATE_TTBL_FILE+5D Is Fixed
    • 3.1.50 File Error Messages During Query Execution Are Now Correct
    • 3.1.51 Sort and Merge Routines Are No Longer Called in Incorrect Order
    • 3.1.52 RDMS$BIND_WORK_VM Now May Be a Large Value
    • 3.1.53 VLDB Application Storage Areas No Longer Exhaust the Channel Limit
    • 3.1.54 Data Converted from TEXT to BIGINT (QUADWORD) No Longer Loses Precision with Large Values
    • 3.1.55 Changes to TIMESTAMP Literal and Character Format
    • 3.1.56 External Functions Now Produce Valid Descriptor Lengths
    • 3.1.57 SPAM Page Search Algorithm Is Now Optimized
    • 3.1.58 RDMS$BIND_SEGMENTED_STRING_COUNT or RDB_BIND_SEGMENTED_STRING_COUNT No Longer Causes VM Corruption
    • 3.1.59 DEC MMS and CDD/Repository Report EXEDELPROC
  • 3.2 SQL Errors Fixed
    • 3.2.1 LIBSQL Naming Conflict Corrected
    • 3.2.2 Full Outer Join with Derived Tables and IS NULL Predicate No Longer Returns Incorrect Results
    • 3.2.3 Assignment Statement No Longer Uses Incorrect Value for CURRENT_TIMESTAMP
    • 3.2.4 COMPUTED BY Column Value Now Returned Correctly
    • 3.2.5 Computed By Column Now Set to Null During DROP TABLE CASCADE
    • 3.2.6 Unexpected RDMS-F-BAD_SYM Error When Referring to COMPUTED BY Columns Fixed
    • 3.2.7 FETCH No Longer Returns End-Of-Stream Condition on NO_RECORD
    • 3.2.8 OUT Parameters Now Accessible with TRACE Statement
    • 3.2.9 Enhanced Support for Views by ALTER DOMAIN and ALTER TABLE Statements
    • 3.2.10 Reserved Tables No Longer Removed from Reserving List After ALTER INDEX
    • 3.2.11 CREATE TRIGGER or CREATE MODULE Statement No Longer Generates Unexpected SEGTOOBIG Error
    • 3.2.12 GET DIAGNOSTICS Statement Now Processed Correctly
    • 3.2.13 RETURNED_SQLSTATE and RETURNED_SQLCODE No Longer Incorrect After COMMIT, ROLLBACK, and SET TRANSACTION Statements
    • 3.2.14 Queries with Expressions Containing Variables No Longer Return Wrong Results
    • 3.2.15 Invalid DATE and TIMESTAMP Literals No Longer Accepted
    • 3.2.16 Searched Update and Searched Delete Statements No Longer Promote Locks Excessively
    • 3.2.17 Single Area WITH LIMIT Storage Map Now Used Correctly
    • 3.2.18 ALTER STORAGE MAP Now Lets You Remove the USING Column
    • 3.2.19 Unexpected UNRES_REL Error No Longer Occurs When Reserving Views
    • 3.2.20 Initialize Handles and External Globals Command Line Qualifiers Processed Correctly
    • 3.2.21 SQL Precompiler Now Consistent for C and COBOL Symbolic Debugging
    • 3.2.22 Bugcheck Creating Complex Views Fixed
    • 3.2.23 SQL Now Generates Connection Name by Default
    • 3.2.24 ALTER DATABASE Handles EXTENT Attribute Correctly
    • 3.2.25 Now Can Create Storage Maps for Tables Containing Data
    • 3.2.26 Views Containing SELECT Literal Now Return Correct Results
    • 3.2.27 SELECT DISTINCT from View Now Returns Correct Dbkey
    • 3.2.28 Divide by Zero Fault Corrected
    • 3.2.29 Ctrl/Z from SQL HELP No Longer Erases Command Line Recall Buffer
    • 3.2.30 Ctrl/Z in Multiscreen Help No Longer Returns RMS-F-EOF Message
    • 3.2.31 Databases Created with MULTITHREADED AREA ADDITIONS Now Correct
    • 3.2.32 EXPORT and IMPORT Statements Correctly Associate Constraints on Multischema Databases
    • 3.2.33 Behavior of Global Buffering Using IMPORT Corrected
    • 3.2.34 EXPORT and IMPORT Statements Handle Invalidated Outlines Correctly
    • 3.2.35 Export and Import Files Now Can Use Any Extension
    • 3.2.36 Now Can Import Interchange Files with Uppercase Extensions on Digital UNIX
    • 3.2.37 IMPORT Statement No Longer Exceeds Memory
    • 3.2.38 EXPORT and IMPORT Statement Problems with Procedures and Functions in ANSI Databases Are Fixed
    • 3.2.39 SQL92 Intermediate Level UNIQUE Constraint Available
    • 3.2.40 Constraints No Longer Fail When New Column Is Created Using DEFAULT
    • 3.2.41 New Behavior for Domain Check Constraints and NULL
    • 3.2.42 RDB$MESSAGE_VECTOR Psect Size Corrected for OpenVMS Alpha
    • 3.2.43 CANTSNAP Errors Stop Occurring After Multiple Re-Ready Requests
    • 3.2.44 Multistatement Procedure Using a Labeled FOR Statement No Longer Bugchecks
    • 3.2.45 Dynamic SQL and TRIM No Longer Result in Access Violation
    • 3.2.46 Intervals in Views No Longer Loop
    • 3.2.47 Using COALESCE with Aggregate Functions Now Returns Correct Results
    • 3.2.48 SELECT ...LIKE with Host Variable No Longer Fails
    • 3.2.49 SQL No Longer Bugchecks at SQL$$SET_TERM_CHARS + xxxxxx
    • 3.2.50 Bugcheck Error in SHOW TRANSACTION Fixed
    • 3.2.51 ALTER TABLE Column Deletion Errors Fixed
    • 3.2.52 Using Dynamic Statement Names No Longer Causes Memory Leaks
    • 3.2.53 Now Can Modify Data Types When Constraints Are Defined
    • 3.2.54 ALTER TABLE No Longer Causes BEFORE or AFTER UPDATE Triggers to Execute Unexpectedly
    • 3.2.55 Simple CASE Expressions Are Evaluated Correctly
    • 3.2.56 New Warning Message Is Generated for Redundant Column References
    • 3.2.57 Value Restriction Removed for Indexes and Storage Maps
    • 3.2.58 ACCVIO or Memory Consumption Loop Problems Using SQL Module Language and Connections Are Fixed
    • 3.2.59 COMMIT with List Cursor Processing No Longer Bugchecks
    • 3.2.60 COMMIT and ROLLBACK Are Now Ignored If There Is No Transaction
  • 3.3 Oracle RMU Errors Fixed
    • 3.3.1 RMU Convert Command Works Properly with Fixed-Size AIJ Files
    • 3.3.2 RMU Open Command and Global_Buffers Qualifier Now Works Correctly
    • 3.3.3 RMU Restore Just_Pages No Longer Leaves Pages with Bad Logical Area
    • 3.3.4 Incremental Restore Now Marks Page Ranges as Changed
    • 3.3.5 No Operator Request Issued When Loader Becomes Empty
    • 3.3.6 Failed AIJ Backup No Longer Causes Recovery Problems
    • 3.3.7 Performance Monitor Uses RDMS$BIND_STATS_DISABLED Correctly
    • 3.3.8 Fixed-Size AIJ Backup to Tape No Longer Ignores Active Checkpoints
    • 3.3.9 DBR No Longer Bugchecks During Extensible AIJ Backup
    • 3.3.10 RMU Backup Command No Longer Deadlocks During Extensible AIJ Backup
    • 3.3.11 Quiet-Point AIJ Backups Spanning Transactions Can Now Be Applied
    • 3.3.12 Time Reduced for AIJ Journal Creation and Extension
    • 3.3.13 Determining the True Size of Current .aij File
    • 3.3.14 AIJ Rollforward Can Start from Quiet-Point AIJ Backup or Quiet-Point Database Backup
    • 3.3.15 RMU Set Audit Stop Command Now Stops Auditing of RMU Commands
    • 3.3.16 Bugcheck at RDMS$$KOD_ISCAN_START_SCAN + AC
    • 3.3.17 Oracle RMU for Digital UNIX Now Translates Environment Variables in .sqlrc Configuration File
    • 3.3.18 RMU Show Statistics with Input Qualifier No Longer Fails
    • 3.3.19 Performance Monitor Starts Up More Quickly
    • 3.3.20 Oracle RMU Now Clears Snapshot, SPAM Pages from CPT During RMU Repair Command
    • 3.3.21 Corrupt Pages in Snapshot Areas Can Now Be Removed
    • 3.3.22 RMU Monitor Logging No Longer Disables Over Time
    • 3.3.23 RMU Analyze Cardinality Update Command Correctly Updates Cardinality
    • 3.3.24 Changes to Header in RMU Analyze Output
    • 3.3.25 RMU Unload Command No Longer Pads VARCHAR Fields When Producing Delimited Text Files
    • 3.3.26 RMU Checkpoint Command Now Allows No Wait for Completion
    • 3.3.27 DBR No Longer Bugchecks Trying to Fetch Inconsistent Pages
    • 3.3.28 Database Recovery No Longer Runs with DBKEY SCOPE IS ATTACH Properties
    • 3.3.29 RMU Show After_Journal Backup_Context Command Properly Creates and Deletes Process Global Symbols
    • 3.3.30 Now You Can Invoke Many Simultaneous Database Attach and Detach Operations While Using the RMU Show Users Command
    • 3.3.31 RMU Extract Command with Item=Security Qualifier Now Generates Correct DCL Syntax
    • 3.3.32 RMU Extract Command with the Option Qualifier Processes Keywords Correctly
    • 3.3.33 RMU Recover Resolve Can Now Resolve Transactions Originated from Different Systems
  • 3.4 RdbPRE, RDML, and RDO Errors Fixed
    • 3.4.1 Alignment of Host Variable Smallint in the RDBPRE Preprocessor
    • 3.4.2 RDO MATCHING Operator Can Now Find Date Matches
    • 3.4.3 RDML/Pascal Now Correctly Generates Casting
    • 3.4.4 RDMLVAXC.H Is Now Compatible with C++

• ---

  Chapter 4 Documentation Additions and Changes
  • 4.1 Latest Software Enhancements
  • 4.2 Additions and Changes to the Oracle Rdb Documentation for Version 7.0 and Earlier
    • 4.2.1 Additions and Changes to the Oracle Rdb7 and Oracle CODASYL DBMS: Guide to Hot Standby Databases Documentation
  • 4.3 Oracle Rdb7 SQL Reference Manual
    • 4.3.0.1 Reorganization of the Oracle Rdb7 SQL Reference Manual
    • 4.3.1 Incorrect Qualifier for SQL Module Language Documented
    • 4.3.2 Incorrect Digital UNIX Link Command for SQL Precompiler Documented
  • 4.4 Oracle RMU Reference Manual
    • 4.4.1 New Transaction_Mode Qualifier for Some Oracle RMU Commands
    • 4.4.2 RMU Server After_Journal Stop Command
    • 4.4.3 Incomplete Description of Protection Qualifier for RMU Backup After_Journal Command
  • 4.5 Changes to the Oracle Rdb7 Guide to Database Performance and Tuning
    • 4.5.1 Error in Updating and Retrieving a Row by Dbkey Example
    • 4.5.2 Error in Calculation of Sorted Index in Example 3-46

• ---

  Index

• ---

  Figures
  • 1-1 Parts of an XA transaction
  • 1-2 Oracle Rdb with DECdtm
  • 1-3 Oracle Rdb with XA

• ---

  Tables
  • 1-1 Keywords to Access Oracle Rdb Help Files
  • 1-2 Columns for RDB$WORKLOAD Table
  • 1-3 New Columns for RDB$COLLATIONS Table
  • 1-4 New Columns for RDB$CONSTRAINTS Table
  • 1-5 New Columns for RDB$DATABASE Table
  • 1-6 New Columns for RDB$FIELDS Table
  • 1-7 New Columns for RDB$INDEX_SEGMENTS Table
  • 1-8 New Columns for RDB$INDICES Table
  • 1-9 Changed Columns for RDB$INDICES Table
  • 1-10 New Columns for RDB$MODULES Table
  • 1-11 New Columns for RDB$QUERY_OUTLINES Table
  • 1-12 New Columns for RDB$RELATIONS Table
  • 1-13 Changed Columns for RDB$RELATIONS Table
  • 1-14 New Columns for RDB$ROUTINES Table
  • 1-15 New Columns for RDB$TRIGGERS Table
  • 1-16 New Columns for RDB$CATALOG_SCHEMA Table
  • 1-17 Documentation for Oracle Rdb for OpenVMS
  • 1-18 Documentation for Oracle Rdb for Digital UNIX
  • 2-1 Oracle CDD/Repository Compatibility for Oracle Rdb Features

Library Product

Copyright ©1996, Oracle Corporation All rights reserved.