HomeSearchSite MapContact Us RemoteDBA Services for CODASYL DBMS and RdbPreserving Mission Critical IT Applications Through Virtualization

Remote Management of OpenVMS SystemsExtreme Performance Consulting


Rdb 7.2.1.4
DATABASE
ADMINISTRATION

VERSION INFO -> RDB -> Rdb 7.2.1.4
Back ] Next ]

September 2007 - Oracle releases Rdb version 7.2.1.4
     [Enhancements] [Bug Fixes]
    Updates to Rdb may be obtained directly from Oracle Support
 

Software Errors Fixed in Oracle Rdb Release 7.2.1.4
1 Software Errors Fixed That Apply to All Interfaces
1.1 CPU Bound Loop in PIOUTL$SERVICE_PAGE_BLASTS
1.2 Wrong Result From Zigzag Match
1.3 Wrong Result From Outer Join With MISSING Predicate
2 SQL Errors Fixed
2.1 Unexpected Column Reordering After an ALTER TABLE ... ADD COLUMN Statement
2.2 SET ALL CONSTRAINTS Causes SQLCODE -1005 With Compound Statement
2.3 GET DIAGNOSTICS in Distributed Transaction Makes Transaction Non-distributed
2.4 IMPORT DATABASE Command Losing Some Command Line Database Attributes
2.5 SET FLAGS 'TRANSACTION' Now Displays Global Transaction ID
2.6 Unexpected Bugcheck From IMPORT DATABASE Command
3 RDO and RDML Errors Fixed
3.1 %COBOL-F-AMBIGSYM, Ambiguous Reference With RDBPRE and COBOL
3.2 %RDB-F-ARITH_EXCEPT With RDBPRE/COBOL and Literal in Expression
4 RMU Errors Fixed
4.1 RMU/RESTORE or /DUMP/BACKUP Bugchecks
4.2 RMU/CONVERT Could Not Delete System Metadata Below the V7.0 Version
4.3 RMU /MOVE_AREA or /COPY_DATABASE With /BLOCKS_PER_PAGE May Fail
4.4 RMU/COLLECT/INDEXES Gave No Error If An Index Did Not Exist
4.5 RMU OPTIMIZER_STATISTICS Commands Gave Wrong Fatal Error Exit Message
4.6 RMU/CONVERT Created System Logical Areas of an Unspecified Type
4.7 RMU/VERIFY/LOG VMS Exit Status Could Be Incorrect
5 LogMiner Errors Fixed
5.1 RMU/UNLOAD/AFTER_JOURNAL Sort Work File Size Potentially Reduced
5.2 RMU/UNLOAD/AFTER_JOURNAL /QUICK_SORT_LIMIT Qualifier
6 RMU Show Statistics Errors Fixed
6.1 File Name Overwritten in File IO Statistics Display
6.2 Bugcheck When Moving Backwards To Device Information Display
6.3 RMU/SHOW STATISTICS /INPUT= Possible Errors or Bugchecks
 
Top
Software Errors Fixed in Oracle Rdb Release 7.2.1.3
1 Software Errors Fixed That Apply to All Interfaces
1.1 Possible Shared Memory Corruption When Multiple Databases Attached
1.2 Remote TCP/IP Bugchecks If Database Is Configured For Internal Security Checking
1.3 Incorrect Results From Complex Query Involving RDB$DATABASE System Table
1.4 ALTER DATABASE ... SHARED MEMORY IS PROCESS Did Not Disable RESIDENT
1.5 Incomplete Error Handling for COSI-E-WORK_DEV
1.6 Wrong Result From Query With NOT NULL Test
1.7 Bugcheck at COSI$TIMER_GET_REQIDT With RDMS-F-NOREQIDT
1.8 Inappropriate Message When Dropping Journal if No Journals Exist
1.9 Bugcheck From UNION Query With Constant Boolean
2 SQL Errors Fixed
2.1 Unexpected Constraint Activation After ALTER TABLE ... DISABLE CONSTRAINT
2.2 Bugcheck with "SQL$BLRXPR - 15" on Cross-DB Insert
2.3 Comments Not Always Recognized by SQL$PRE/COBOL
2.4 Incorrect Data Displayed from CONCAT Operator
2.5 CREATE INDEX Inserts Index Key in Wrong Partition
2.6 Unexpected Bugcheck When Inserting Into a View
2.7 SQLSTATE 22001 Not Returned with Dynamic SQL
2.8 Unexpected Bugcheck When Creating a Duplicates Allowed SORTED RANKED Index
2.9 SQLSTATE 22011 and SQLCODE -1044 Added
2.1 SUBSTRING Truncation for View Defined in Program
2.11 Unexpected PORT_LEN Error When Calling Storage Mapping Function
2.12 Unexpected Failure of ALTER DATABASE to Enable PERSONA Support
3 RMU Errors Fixed
3.1 RMU Backup To Tape With /ENCRYPTION Can Cause Bugcheck
3.2 RMU /ANALYZE /INDEX Accesses All Logical and Physical Areas
3.3 %COSI-F-NEGTIM Could Abort RMU/VERIFY Or RMU/BACKUP
3.4 RMU/VERIFY Problem With Database Creation Date Diagnostics
3.5 RMU/RESTORE Exits with Traceback Log When the Wrong Version is Used
3.6 RMU/VERIFY %RMU-I-BADNXTNOD Diagnostic Message Changed To %RMU-E-BADNXTNOD
3.7 RMU/VERIFY %RMU-I-BTRDUPCAR Diagnostic Message Changed To
%RMU-E-BTRDUPCAR
3.8 Possible Invalid %RMU-F-NOPRIVERR Error on RMU/RESTORE, RMU/DUMP/BACKUP
3.9 RMU/REPAIR to Move Snapshot File Can Fail With Bad New File Specification
3.1 RMU-F-FILACCERR, Error Truncating File on RMU/BACKUP/AFTER
4 RMU Show Statistics Errors Fixed
4.1 Incorrect RMU/SHOW STATISTICS Transaction Recovery Duration Estimates
4.2 RMU/SHOW STATISTICS Stall Statistics Aggregate Duration Incorrectly Scaled Values
4.3 RMU /SHOW STATISTICS /ALARM=n Not Waiting n Seconds
4.4 State Value Truncated on Hot Standby Statistics Display
5 Hot Standby Errors Fixed
5.1 Hot Standby Node Failure Recovery When Using RMU/OPEN/ROW_CACHE=DISABLE
 
Top
Software Errors Fixed in Oracle Rdb Release 7.2.1.2
1 Software Errors Fixed That Apply to All Interfaces
1.1 Bugchecks at KOD$START + 0000080C
1.2 Adding a Large AIJ File to a DB Fails With Either an ACCVIO or OPCDEC Error
1.3 Simple Query Fails with ARITH_EXCEPT
2 SQL Errors Fixed
2.1 Unexpected RTN_FAIL/BAD_REQ_HANDLE Reported when Stored Function
Called with All Constant Parameters
2.2 SYSTEM-F-ROPRAND With Large Command Line
2.3 Unexpected Bugcheck from ALTER VIEW
2.4 Unexpected Bugcheck from ALTER INDEX ... BUILD PARTITION
3 RMU Errors Fixed
3.1 RMU/DUMP/BACKUP Fails With an ACCVIO or an Overrun Error
3.2 RMU/RESTORE Convert Problem With More Than 32 Client Sequences
3.3 RMU LOAD Delimited Text Problem Parsing NULL Values
4 RMU Show Statistics Errors Fixed
4.1 RMU/SHOW STATISTICS AIJ ARB:I/O Ratio, Blocks-per-I/O Ratio Problems
5 Hot Standby Errors Fixed
5.1 Unable to Fully Disable Hot Standby Governor
 
Top
Software Errors Fixed in Oracle Rdb Release 7.2.1.1
1 Software Errors Fixed That Apply to All Interfaces
1.1 Unexpected Query Failure With RDB-E-NO_RECORD Error
1.2 AIJ Backup Operation Aborts With NONAME-F-NOMSG Message Number 00000004 ...    5-2
1.3 Some RDMS$SET_FLAGS Settings Not Seen After ATTACH
1.4 RDB-E-EXCESS_TRANS Error After SET TRANSACTION Failure
1.5 Float Overflow in Rdb Optimizer Cost Estimation
1.6 Wrong Result From Query With Zig-zag Match and Reverse Scan
1.7 %RDB-E-REQ_NO_TRANS When Fetching From a Cursor
1.8 Distinct Query Bugchecks With Bitmap Scan Enabled
1.9 ALTER Requires Read-Write Access to Storage Areas
2 SQL Errors Fixed
2.1 SQL/Services Executor Loops Consuming 99% CPU
2.2 Some SQL Dialect-required Warnings Not Delivered
2.3 SET AUTOMATIC TRANSLATION 'ON' May Cause Wrong Results From Queries
2.4 Declared Variables Ignored by Oracle Dialect Dynamic Statements
2.5 Unexpected DATTYPUNK Error Reported When Parameter Appeared in CONCAT Operation
2.6 AIP Length Not Set by ALTER TABLE for Unmapped Tables
3 RMU Errors Fixed
3.1 RMU Online Verification ACCVIO at RMUVLAREA$VERIFY_LAREA_PAGES
3.2 RMU/SHOW LOGICAL_NAMES Does Not Include RDM$MONITORnn
3.3 RMU/VERIFY/INCREMENTAL Incorrect Diagnostics for Bitmap Indexes
3.4 RMU/BACKUP With PARALLEL and COMPRESS=ZLIB Fails
4 Row Cache Errors Fixed
4.1 Bugcheck During Online RMU Backup When Snapshots In Row Cache Enabled
4.2 Slight Relaxation of VMS$MEM_RESIDENT_USER Requirement
5 RMU Show Statistics Errors Fixed
5.1 Latch Hangs Possible From RMU /SHOW STATISTICS
5.2 RMU/SHOW STATISTICS Bugcheck in KUTDIS$LONG_TX_NOTIFY
6 Hot Standby Errors Fixed
6.1 LRS Shutdown Failure RDMS-F-PARTDTXNERR/SYSTEM-F-NOSUCHID
 
Top
Software Errors Fixed in Oracle Rdb Release 7.2.1.0
 
1 Software Errors Fixed That Apply to All Interfaces
1.1 Incorrect Backup Checksum and CRC Values on I64
1.2 Bugcheck Loop Created Many Bugcheck Dumps
1.3 Left Outer Join Query Slows With Full Index Scan
1.4 DBR Bugchecks at DIO$LACB_CREATE + 00000174
1.5 Processes Do Not Always Terminate After Monitor Terminates
1.6 Wrong Results With "OR Index Retrieval" and Bitmapped Scan
1.7 Bugcheck in Query on a Single Table With AND/OR Predicates
1.8 Bugcheck When Bitmap Scan Enabled
1.9 Wrong Result From Star Join Query With Aggregate
1.1 Restriction Relaxed for Executing External Routines via Privileged Images
1.11 RDMS$_ Symbols Missing From RDMMSGSHR on I64
1.12 Hangs or Looping When Lots of Page Contention
1.13 Logical RDMS$ENABLE_INDEX_COLUMN_GROUP Not Working
2 SQL Errors Fixed
2.1 CREATE OUTLINE Not Fully Supported for MULTISCHEMA Databases
2.2 Unexpected INV_TBL_DCL Error From CREATE MODULE in Compiled Source
2.3 Numeric Out of Range SQLSTATE 22003 Not Returned
2.4 TIMESTAMP Result of DATE Added to TIME Expression was Truncated
2.5 Unexpected Constraint Failure from INSERT ... SELECT Statement
2.6 SQL$MOD /LIS Displays Incorrect /ALIGN Value
2.7 FOR UPDATE Clause was Ignored for DECLARE CURSOR
2.8 UPDATE ... WHERE CURRENT OF Assigns Incorrect Result Within IF Statement
2.9 Unexpected COSI-F-BUGCHECK Error Reported by SHOW Commands
2.1 ALTER DOMAIN Incorrectly Propagates DEFAULT Changes to Table Columns
2.11 Module Global Variables Limited to 64 DECLARE Statements
2.12 Invalid Escape Sequence Not in SQLSTATE...   6-26
2.13 Incomplete Drop of Partitioned Indices with DROP STORAGE AREA ... CASCADE
2.14 Unexpected LENMISMAT Warnings when Using TRANSLATE ... USING Function
2.15 Unexpected Error from UNION Containing NULL Expression
2.16 Inconsistent Data Type Assignment to IS NULL Expression
2.17 Table Synonym Not Used by Query Outlines
2.18 Unexpected UNSDTPCVT Error During String Concatenation
2.19 Parameter for LIKE Pattern Sized Too Small
3 RMU Errors Fixed
3.1 RMU/BACKUP/AFTER Ignores Default Filename When /EDIT_FILENAME Included
3.2 Possible RMU COLLECT OPTIMIZER Workload Statistics Memory Corruption
3.3 RMU VERIFY Memory Corruption
3.4 Unexpected DLMNOTFND When Leading Characters of Suffix Appear in Data
3.5 Unexpected Failure of RMU Load When the NULL String Appears With Column Data
3.6 Unexpected INVALID_BLR Error Reported For RMU Load
3.7 RMU /COPY, /MOVE and /RESTORE Could corrupt ABM Pages
3.8 RMU Unload May Truncate REAL Data When Delimited or Text Format Used
3.9 Incomplete Multischema Database Support in RMU Extract
3.1 RMU Extract Item=Protections Did Not Consistently Extract Protections
3.11 RMU/CONVERT Bugchecks in PIO$LOCK_PAGE When Statistics Disabled
3.12 RMU/RESTORE/AREA/ONLINE Was Unnecessarily Locking RDB$SYSTEM for
PROTECTED READ
3.13 Failure of RMU /BACKUP of Database With Very Large Storage Area
Count and Small Specified /BLOCK_SIZE Value
3.14 RMU Extract Reports BAD_CODE Error for BITSTRING Function
3.15 Incorrect SQL Syntax Generated for Views Containing UNION and GROUP BY Clauses
4 LogMiner Errors Fixed
4.1 RMU /UNLOAD /AFTER_JOURNAL Incorrect NULL Bit Setting
4.2 RMU /UNLOAD /AFTER_JOURNAL AERCP_LEN Field Incorrect In Text Format
5 Row Cache Errors Fixed
5.1 RMU/RECOVER of Journaled Row Cache Changes Corrupts Database
5.2 Recovered Database Corrupt When ROW SNAPSHOT IS ENABLED
6 RMU Show Statistics Errors Fixed
6.1 RMU/SHOW STATISTICS Hot Standby Statistics State Display Field
6.2 RMU /SHOW STATISTICS Defined Logicals List Incomplete
6.3 Rdb Executive Sort and Temporary Work File Statistics
 
Top
Enhancements And Changes Provided in Oracle Rdb Release 7.2.1.4
1 Enhancements And Changes Provided in Oracle Rdb Release 7.2.1.4
1.1 RMU/SHOW STATISTICS /STALL_LOG And /ALARM
1.2 RMU/SHOW STATISTICS Stall Alarm Invoked Procedure Parameter Addition
1.3 RMU /SHOW AIP New Qualifier /BRIEF
1.4 RMU /SHOW AIP New Qualifier /PAREA
1.5 New Options for RMU DUMP EXPORT Command...    7-3
 
Top
Enhancements And Changes Provided in Oracle Rdb Release 7.2.1.3
1 Enhancements And Changes Provided in Oracle Rdb Release 7.2.1.3
1.1 RMU /ANALYZE /INDEX Wildcard Support
1.2 New RMU VERIFY Messages %RMU-E-BADCLTSEQALLOC, %RMU-E-BADCLTSEQMAXID,
%RMU-E-BADCLTSEQUSED
1.3 RMU/SHOW LOCKS Per Database New Feature...    8-3
1.4 Reduced CPU Usage and Improved Performance
1.5 Sample of Rdb External Routine Access to Oracle RDBMS
1.6 New RMU /SET DATABASE /TRANSACTION_MODE=(...) Command
1.7 COMPRESS Qualifier for After-Image Journal Backup Command
1.8 New Qualifier /[NO]DATABASE_VERIFICATION For RMU /BACKUP Command
1.9 Qualifier /[NO]CONFIRM For RMU /RECOVER Command
1.1 /ORDER_AIJ_FILES Removes Some Unnecessary Files For RMU /RECOVER Command
 
Top
Enhancements And Changes Provided in Oracle Rdb Release 7.2.1.2
1 Enhancements And Changes Provided in Oracle Rdb Release 7.2.1.2
1.1 Optional Run-Time Routine Native Compiler on I64
1.2 Mixed Case Passwords Supported
1.3 RMU Tape Support Added for SDLT600, LTO2, LTO3 Drives
 
Top
Enhancements And Changes Provided in Oracle Rdb Release 7.2.1.0
1 Enhancements And Changes Provided in Oracle Rdb Release 7.2.1.0
1.1 New Implementation of the CONCAT (||) Operator
1.2 New Columns in Information Table RDB$JOURNALS
1.3 Oracle Rdb Release 7.2.x.x New Features Document Added
1.4 Hot Standby Status Symbols From RMU /SHOW AFTER_JOURNAL /BACKUP_CONTEXT
1.5 RMU BACKUP, COPY, MOVE /THREADS=n New Qualifier
1.6 Concealed Logical Names Defined in LNM$SYSCLUSTER_TABLE Table Allowed
1.7 Support for GNAT Ada on Alpha and Itanium
1.7.1 Pragma EXTEND_SYSTEM
1.7.2 SQL_STANDARD Package
1.7.3 GNAT Ada Type Differences
1.7.4 SQL Module Language
1.7.5 Precompiled SQL
1.8 Enhancement to SQLCA
1.9 File-System Caching Avoided for RMU /COPY, /MOVE, /BACKUP And /RESTORE, IO To
Database
1.1 RMU /BACKUP /COMPRESSION New Algorithm
1.11 Enhancements for Compression Support in RMU Unload and Load
1.12 RMU /UNLOAD /AFTER_JOURNAL Commit Information Includes Username
1.13 SHOW DOMAIN and SHOW TABLE Have Better Formatting of DEFAULT Strings
1.14 CALL Statement From Trigger Action Can Now Update Tables
1.15 Using OpenVMS Reserved Memory Registry With Rdb
1.16 Server Output File Names As Database Attributes
1.17 New REBLDSPAM Informational Message Added to RMU/VERIFY
1.18 Increased Date/Time String Display Precision
1.19 Enhanced System Table Lookup in Multischema Databases
1.2 New SET FLAGS Option: REBUILD_SPAM_PAGES
1.21 RMU/BACKUP /NORECORD New Qualifier
1.22 Improved Management of the AIP (Area Inventory Page) Data by SQL Commands
1.23 New RMU Show AIP Command Added
1.24 New RMU Set AIP Command Added

Top

 

Copyright 2019 Software Concepts International
All Rights Reserved