PDF《Oracle? Rdb for OpenVMS》

Oracle? Rdb for OpenVMS Table of Contents Oracle? Rdb for OpenVMS.

1 Release Notes.2 October

2007 3 Contents.4 Preface.5 Purpose of This Manual.6 Intended Audience.7 Document Structure

8 Chapter 1Installing Oracle Rdb Release 7.1.5.2.9 1.1 Oracle Rdb V7.1 Version Numbering Enhancement.10 1.2 Requirements

11 1.3 Invoking VMSINSTAL.12 1.4 Stopping the Installation.13 1.5 After Installing Oracle Rdb.14 1.6 Spurious SYSVERDIF Message During Installation.15 1.7 Patches for OpenVMS V7.3?1.16 1.8 Oracle Rdb Release 7.1.5.2.1 Optimized for Alpha EV56 (21164A Processor Chip) and Later Platforms.17 1.8.1 AlphaServer

4000 EV56 299Mhz Not Supported by Oracle Rdb Release Optimized for Alpha EV56 Processor.18 1.9 Maximum OpenVMS Version Check Added.19 1.10 VMS$MEM_RESIDENT_USER Rights Identifier Required.20 Chapter 2Software Errors Fixed in Oracle Rdb Release 7.1.5.2.21 2.1 Software Errors Fixed That Apply to All Interfaces.22 2.1.1 Potential System Crash Using VLM Global Buffers.22 2.1.2 Bugcheck From UNION Query With Constant Boolean.22 2.1.3 CPU Bound Loop in PIOUTL$SERVICE_PAGE_BLASTS.23 2.1.4 Wrong Result From Zigzag Match.23 Oracle? Rdb for OpenVMS i Table of Contents 2.1 Software Errors Fixed That Apply to All Interfaces 2.1.5 Wrong Result From Outer Join With MISSING Predicate.25 2.1.6 Query Bugchecks After Upgrading From Release 7.1.1 to Release 7.1.5.1.26 2.1.7 Query Loops and Hangs Upgrading from Rdb V7.0 to V7.2.26 2.2 SQL Errors Fixed.29 2.2.1 SUBSTRING Truncation for View Defined in Program

29 2.2.2 Unexpected PORT_LEN Error When Calling Storage Mapping Function.29 2.2.3 Unexpected Failure of ALTER DATABASE to Enable PERSONA Support.30 2.2.4 Unexpected Column Reordering After an ALTER TABLE ... ADD COLUMN Statement ........30 2.2.5 SET ALL CONSTRAINTS Causes SQLCODE ?1005 With Compound Statement.30 2.2.6 GET DIAGNOSTICS in Distributed Transaction Makes Transaction Non?distributed.31 2.2.7 IMPORT DATABASE Command Losing Some Command Line Database Attributes

32 2.2.8 WAIT and NOWAIT Flags Not Used by Sequences.33 2.3 RDO and RDML Errors Fixed.34 2.3.1 %COBOL?F?AMBIGSYM, Ambiguous Reference With RDBPRE and COBOL.34 2.3.2 %RDB?F?ARITH_EXCEPT With RDBPRE/COBOL and Literal in Expression.35 2.4 RMU Errors Fixed.36 2.4.1 RMU/VERIFY %RMU?I?BTRDUPCAR Diagnostic Message Changed To %RMU?E?BTRDUPCAR.36 2.4.2 RMU/REPAIR to Move Snapshot File Can Fail With Bad New File Specification.36 2.4.3 RMU?F?FILACCERR, Error Truncating File on RMU/BACKUP/AFTER.37 2.4.4 RMU/COLLECT/INDEXES Gave No Error If An Index Did Not Exist.37 2.4.5 RMU OPTIMIZER_STATISTICS Commands Gave Wrong Fatal Error Exit Message.38 2.4.6 RMU/VERIFY/LOG VMS Exit Status Could Be Incorrect.39 Chapter 3Software Errors Fixed in Oracle Rdb Release 7.1.5.1.41 3.1 Software Errors Fixed That Apply to All Interfaces.42 3.1.1 %RDB?E?REQ_NO_TRANS When Fetching from a Cursor.42 3.1.2 Distinct Query Bugchecks With Bitmap Scan Enabled

42 3.1.3 Program Fails With SYSTEM?F?ACCVIO in RDB$SHARE71

44 3.1.4 Unexpected Query Failure With RDB?E?NO_RECORD Error.44 3.1.5 AIJ Backup Operation Aborts With NONAME?F?NOMSG Message Number 00000004........45 3.1.6 Adding a Large AIJ File to a DB Fails With Either an ACCVIO or OPCDEC Error.45 3.1.7 Simple Query Fails with ARITH_EXCEPT.46 3.1.8 %MTH?F?SQUROONEG Error from RMU Workload Collect.47 3.1.9 ALTER DATABASE ... SHARED MEMORY IS PROCESS Did Not Disable RESIDENT.....47 3.1.10 Incomplete Error Handling for COSI?E?WORK_DEV.47 3.1.11 Wrong Result From Query With NOT NULL Test.48 3.1.12 Possible Shared Memory Corruption When Multiple Databases Attached.49 3.1.13 Bugcheck at COSI$TIMER_GET_REQIDT With RDMS?F?NOREQIDT.49 3.2 SQL Errors Fixed.51 3.2.1 Some SQL Dialect?required Warnings Not Delivered.51 3.2.2 Declared Variables Ignored by Oracle Dialect Dynamic Statements.52 Oracle? Rdb for OpenVMS ii Table of Contents 3.2 SQL Errors Fixed 3.2.3 Unexpected RTN_FAIL/BAD_REQ_HANDLE Reported when Stored Function Called with All Constant Parameters.52 3.2.4 SYSTEM?F?ROPRAND With Large Command Line