| New Features and Technical Changes
(Rdb V7.1.2) |
|
| Enhancements provided in Oracle Rdb release 7.1.2. |
| 1.1 | New NVL2 expression. |
| 1.2 | SET DEFAULT CONSTRAINT MODE enhancements. |
| 1.3 | New dialect ORACLE LEVEL2 added. |
| 1.4 | RMONSTOP71.COM Parameter for RMU/MONITOR STOP command. |
| 1.5 | RMU/UNLOAD/AFTER_JOURNAL output flush. |
| 1.6 | RMU /SHOW STATISTICS enhanced to show large memory setting. |
| 1.7 | Statistics collection performance improvement for AlphaServer GS systems. |
| 1.8 | RMU RECOVER accepts wildcard After-image Journal file specifications and ORDER_AIJ_FILES qualifier. |
| 1.9 | RMU/SHOW STATISTICS page dump content and format enhancements. |
| 1.10 | Enhancement to prestarted transaction timeout. |
| 1.11 | RDM$BIND_SNAP_QUIET_POINT logical no longer Used. |
| 1.12 | New SET CONTINUE CHARACTER statement for interactive SQL. |
| 1.13 | OPTIMIZE clause enhancements. |
| 1.14 | New Options for the OPTIMIZATION_LEVEL qualifier. |
| 1.15 | SET OPTIMIZATION LEVEL enhancements. |
| 1.16 | RMU Load now supports SELECTIVITY option for OPTIMIZE Qualifier. |
| 1.17 | New options supported for LOGMINER SUPPORT clause. |
| 1.18 | Changes to the IMPORT command. |
| 1.19 | ALTER MODULE statement. |
| 1.20 | New RENAME statement. |
| 1.21 | New Warning generated when row size exceeds row cache length. |
| 1.22 | Oracle media management V2.0 API for Oracle Rdb RMU. |
| 1.23 | Commands accepting /LIBRARIAN. |
| 1.24 | Opaque archive application. |
| 1.25 | RMU backup streams. |
| 1.26 | Parallel backup operations. |
| 1.27 | Data stream naming considerations. |
| 1.28 | /LIBRARIAN parameters. |
| 1.29 | Logical names To access LIBRARIAN application. |
| 1.30 | SQL/Services required for RMU parallel backup. |
| 1.31 | Listing and deleting data streams. |
| 1.32 | Sanity checks added to RMU /VERIFY to check TSNs and CSNs. |
| 1.33 | RMU /CLOSE /WAIT /NOCLUSTER now allowed. |
| 1.34 | Native 64-bit Virtual Addressing for row caches. |
| 1.35 | 64-bit addressing no application or database Changes required. |
| 1.36 | Deprecated Attributes. |
| 1.37 | Snapshots In Row Cache. |
| 1.38 | Performance Enhancements for RMU /RECOVER with optimized After-Image Journals. |
| 1.39 | Enhancements to INSERT FILENAME for LIST OF BYTE VARYING Data. |
| 1.40 | Default for RMU CRC Qualifier Changed to /CRC = AUTODIN_II. |
| 1.41 | New LIKE clause added to CREATE TABLE. |
| 1.42 | Enhancements to statistical functions. |
| 1.43 | RMU /VERIFY enhanced to detect sequence problems. |
| 1.44 | New Procedure RDB$IMAGE_VERSIONS.COM. |
| Problems Corrected
(Rdb V7.1.2) |
|
| Software errors fixed in Oracle Rdb Release 7.1.2 |
| 2.1 | Software errors fixed that apply to all interfaces. |
| 2.2 | Area access fails after online storage area creation. |
| 2.3 | Page Transfer via memory feature now available. |
| 2.4 | UNION Query with two left outer joins in first leg returns wrong results. |
| 2.5 | Error %RDMS-E-NOSOL_FOUND in Full Outer join query. |
| 2.6 | Query with EXISTS clause and COMPUTED BY column returns wrong results. |
| 2.7 | Bugcheck in DIO$FREE_CURRENT_LOCK for sorted ranked indexes. |
| 2.8 | Illegal page count error in the dynamic optimizer. |
| 2.9 | Ranked index overflow node corruption on insert. |
| 2.10 | Incorrect results from a reverse scan on a ranked index. |
| 2.11 | Restriction removed for READ ONLY transaction on standby database |
| 2.12 | Bugcheck at PSIINDEX$FIND_ENTS_EXACT + 54. |
| 2.13 | AIJ Log server process may loop or bugcheck. |
| 2.14 | SYSTEM-F-NOIOCHAN Error. |
| 2.15 | ROLLBACK not appended to AIJ for failed 2PC transactions. |
| 2.16 | Bugcheck at LCK$MEMBIT_BLAST + 023C with exception of COSI-F-IVLOCKID |
| 2.17 | Bugcheck when multiple tables are transitively joined with IS NULL Filter. |
| 2.18 | Unexpected error from GRANT and REVOKE. |
| 2.19 | Process can hang after SYS$FORCEX issued. |
| 2.20 | Show storage map "Lists_Map" partition display error |
| 2.21 | Incorrect cardinalities calculated by CREATE DATABASE. |
| 2.22 | ALTER INDEX fails with the RDMS-F-NOT_LARDY error. |
| 2.23 | Cannot drop close timer database. |
| 2.24 | Outer ORDER BY ignored in favor of inner ORDER BY clause. |
| 2.25 | Query Using IN clause with 16 filter predicates runs slower |
| 2.26 | PIOUTL$BUILD_IORB bugcheck adding mixed format storage area |
| 2.27 | Unexpected Bugcheck During CREATE SEQUENCE. |
| 2.28 | Bugcheck on dropping of an empty sorted ranked index. |
| 2.29 | Index estimation may not estimate the most useful index first |
| 2.30 | Premature switch to sequential retrieval in the dynamic optimizer |
| 2.31 | Poor performance from bulk loads after 7.1.0.1. |
| 2.32 | RDMRLE image not always supplied during installation. |
| 2.33 | SORT consumes all available memory. |
| 2.34 | Unexpected failure of the IDENTITY clause in CREATE TABLE. |
| 2.35 | Unexpected failure of INSERT for Table with IDENTITY after an IMPORT |
| 2.36 | Unexpected Privileges required using VLM or SSB features with OpenVMS Galaxy support enabled. |
| 2.37 | bugchecks at PIO$FETCH + 00000360. |
| 2.38 | DBR bugchecks at DBR$DDTM_RESOLVE + 000003F4. |
| 2.39 | Spurious CHECKSUM errors reading READ ONLY areas with global buffers. |
| 2.40 | Additional memory utilized for global buffers starting with Rdb release 7.1.0.4 |
| 2.41 | Fields added to informational table RDB$CACHES. |
| 2.42 | Page locks not released when LOCKING IS PAGE LEVEL. |
| 2.43 | Potential bugcheck using VLM Global buffers with Galaxy support. |
| 2.44 | Incorrect retrieval of duplicates from ranked Indexes. |
| 2.45 | ALTER TABLE Statement May Fail if RESERVING clause used for transaction. |
| 2.46 | Processes not recovered after node failure. |
| 2.47 | DBR bugchecks at PIO$COMPLETE + 000002E4. |
| 2.48 | Left outer join query with CONCAT function returns wrong results. |
| 2.49 | RCS Bugchecks at DIOCCH$UNMARK_GRIC_ENT. |
| 2.50 | Query with sum function of two select counts bugchecks. |
|
| 3 | SQL Errors fixed. |
| 3.1 | DECLARE LOCAL TEMPORARY TABLE limited to 10 tables per session. |
| 3.2 | Unexpected ACCVIO when reporting incompatible character set assignments. |
| 3.3 | ALTER STORAGE MAP may fail with PARTEXTS error for LIST storage map. |
| 3.4 | Problems corrected in ALTER INDEX BUILD PARTITION. |
| 3.5 | INSERT into table with an IDENTITY column may fail with RDB$_NO_PRIV error. |
| 3.6 | IMPORT may generate ACCVIO exception during import of a module. |
| 3.7 | SELECT FOR UPDATE now supported by Oracle Rdb. |
| 3.8 | Unexpected failure from DROP STORAGE AREA CASCADE clause. |
| 3.9 | Create Module declaring integer variable's default with cast bugchecks. |
| 3.10 | Incorrect Unit for the DETECTED ASYNC PREFETCH THRESHOLD option. |
| 3.11 | DROP CONSTRAINT now operates on column and table constraint. |
| 3.12 | IVP or other failure with dynamic SQL if SQL$INT is Installed/RESIDENT. |
| 3.13 | CREATE INDEX Would Fail With READ_ONLY_FIELD error. |
| 3.14 | SQL Added padding spaces to saved source SQL statement. |
| 3.15 | ALTER TABLE caused AUTOMATIC UPDATE columns to be evaluated for all rows. |
| 3.16 | SQL-F-NODBFILE When SQL Modules are compiled with /CONNECT. |
| 3.17 | Concatenate now supports Non-character values in ORACLE LEVEL2. |
| 3.18 | RDB-E-REQ_NO_TRANS with multiple SQL modules and images. |
|
| 4 | RDO and RDML errors fixed. |
| 4.1 | RDML /DATE_TYPE qualifier default is now NOEMPTY_RECORDS. |
| 4.2 | RMU errors fixed. |
| 4.3 | Could not import statistics on different node. |
| 4.4 | RMU extract generates incorrect ALTER TABLE ADD CONSTRAINT syntax. |
| 4.5 | RMU/VERIFY/CONSTRAINTS problems with named tables and constraints. |
| 4.6 | RMU/BACKUP/PARALLEL/DISK_FILE did not work properly |
| 4.7 | RMU/BACKUP/DISK_FILE fails if too many writer threads |
| 4.8 | TRUNCATE TABLE and RMU /REPAIR corruption corrected. |
| 4.9 | AIJ backup file may not allow recovery of a restored database. |
| 4.10 | Domains required for SQL_FUNCTION not output by RMU extract |
| 4.11 | RMU/RESTORE bugchecks at LCK$STALL_FOR_ENQ + 0CC0. |
| 4.12 | Changes to RMU /CLOSE behavior. |
| 4.13 | May not be able to apply the next AIJ after doing RMU/RECOVER/RESOLVE /STATE multiple times. |
| 4.14 | RMU/EXTRACT/ITEM=DATABASE may not display snapshot file attributes |
| 4.15 | Recovery of empty optimized AIJ does not update the sequence number. |
| 4.16 | RMU/VERIFY not writing constraint verification failure warnings to /OUTPUT file. |
| 4.17 | RMU/COLLECT may default to a READ WRITE transaction. |
| 4.18 | RMU/CONVERT failed if VMS$MEM_RESIDENT_USER rights identifier not held. |
| 4.19 | Multi-Disk file restore could fail if READER_THREADS exceeded one. |
| 4.20 | RMU extract not extracting modules correctly when MATCH option used. |
| 4.21 | Recovery of database with fixed AIJs after convert to V7.1 could lose data. |
| 4.22 | Some database backup files created with LZSS compression could not be restored. |
| 4.23 | RMU verify access violation allocating memory for Expanding a Storage Record. |
|
| 5 | LogMiner errors fixed. |
| 5.1 | LogMiner elimination of processing unneeded AIJ files. |
| 5.2 | Replication Option and LogMiner features active at the same time |
| 5.3 | RMU /UNLOAD /AFTER_JOURNAL created .RRD content clarification. |
| 5.4 | /TRANSACTION_TYPE qualifier for RMU/UNLOAD /AFTER_JOURNAL. |
|
| 6 | Row cache errors fixed. |
| 6.1 | Storage area grows despite row erasure when using row cache. |
| 6.2 | Logical area record erasure count not updated for cached rows. |
| 6.3 | Commit performance improvement with row cache feature. |
|
| RMU/SET | ROW_CACHE command updates. |
|
| 7 | RMU show statistics errors fixed. |
| 7.1 | RMU /SHOW STATISTICS writes invalid configuration file. |
| 7.2 | RMU /SHOW STATISTICS /DEADLOCK_LOG does not record first deadlock occurrence. |
| 7.3 | RMU /SHOW STATISTICS row cache overview integer overflow. |
| 7.4 | RMU /SHOW STATISTICS "Device Information" screen bugchecks in playback mode. |
| 7.5 | RMU /SHOW STATISTICS Limiting multi-page report. |
| 7.6 | RMU /SHOW STATISTICS Misleading maximum values after RESET or UNRESET. |
| 7.7 | Enhancement to transaction duration display when written to report. |
| 7.8 | RMU /SHOW STATISTICS Bugcheck in KUTDIS$UPDATE_RS. |
| 7.9 | RMU /SHOW STATISTICS 95th percentile transaction duration less than 0.40 seconds. |
| 7.10 | "RUJ File Writes" statistic not accurate |
| 7.11 | RMU /SHOW STATISTICS custom (Yanked) value double of value reported in original screen. |
|
| 8 | Hot standby errors fixed. |
| 8.1 | Changes to RMU /REPLICATE AFTER START /BUFFERS qualifier. |
| 8.2 | Standby database missing updates if master not manually opened. |
| 8.3 | Starting LRS on master database caused shutdown. |
|
| 9 | Oracle Trace errors fixed. |
| 9.1 | Oracle Trace did not collect for Oracle Rdb Release 7.1.1 |