Oracle® Fusion Middleware

Release Notes for Oracle GoldenGate for HP NonStop (Guardian)

12c (12.2.0.1)

E57714-05

September 2017

This document contains the release notes for the 12c (12.2.0.1) release of Oracle GoldenGate for HP NonStop on the Guardian platform.

You can find additional information about the parameters and options described in these release notes in the Reference Guide for Oracle GoldenGate for HP NonStop (Guardian).

Topics:

Topics:

1.1 New Features in 12c (12.2.0.1)

This section outlines the new features that are being introduced in this release and include the following:

X86 Chipset

This release supports HP Non-Stop systems running on theX86 Chipset architecture and new operating system L06.

Event Actions

The EVENTACTIONS option was added to the FILE (table) and MAP parameters and can be used to trigger an event based on a file or table receiving a DML record.

REPERROR Additions 

The PURGETARGET option allows you to purge the target then retry creating it. 

The IOTYPE option allows you to identify IO error types.

Add Options To LAGINFO and LAGCRITICAL Parameters 

Two new reporting options, REPORTTASKS and REPORTSTOPPED, were added to the LAGINFO and LAGCRITICAL parameters.

New ADD/ALTER EXTTRAIL Option 

A new option CREATE | NOCREATE was added to theADD EXTTRAIL and ALTER EXTTRAIL parameters. The default is CREATE

1.2 New Parameters

This section lists the parameters that have been added for this release.

DOWNINFO

In earlier releases, there was no information classified when a process terminated abnormally. Now you can use the DOWNINFO parameter to classify a process that has terminated abnormally as informational in the report generated by DOWNREPORT.

NOCONTROLTABLELOCKOFF | CONTROLTABLELOCKOFF  

The NOCONTROLTABLELOCKOFF | CONTROLTABLELOCKOFF parameter can be used as a global-level toggle before and after map statements and as an option of a MAP.

1.3 Parameter Changes

This section explains the parameter changes that are included in this release.

Default Option to LAGINFO and LAGCRITICAL 

The default options, IGNORESTOPPED and IGNORETASKS , were added to the LAGINFO and LAGCRITICAL parameters.

Metadata Log Dump Commands Added In Oracle GoldenGate

The METADATA DETAIL ON,  METADATA SQLFORMAT ON, and METADATA DEFGENFORMAT ON  commands were added to Logdump, see Logdump Reference for Oracle GoldenGate.

Additional DEFGEN Option

A new FORMAT LEVEL option was added to DEFGEN for use with a definition file produced to be used for the  TARGETDEFS of an OpenSys Extract to map from another database to NSK.

RMTHOST Option Timeout  

The new TIMEOUT option was added to the RMTHOST parameter to time-out the connection when it is not made within the specified time limit.

FORMATASCII User Specified Delimiters

You can now specify an arbitrary character using the  ColumnDelimiter and RecordDelimiter options. The character specified for these options cannot be the same.

File Aging Parameter Options

In earlier releases, the parameter was restricted to days. Now, you can specify with the hours and minutes with the new FILEAGEHOURS [n] and FILEAGEMINUTES [n] options.

1.4 Deprecated Parameters and Programs

This section lists the parameters and parameter options that are deprecated as of release 12c (12.2.0.1).

No parameters or options were deprecated in this release.

1.5 Installation and Upgrades

The installation file downloaded from Oracle is a standard ZIP file.

Topics:

Topics:

1.5.1 Upgrade Process

The upgrade process for Oracle GoldenGate has not changed.

1.6 Corrected Problems and Enhancements

For questions on specific bugs or ticket numbers, consult Oracle Customer Support. SR is the Oracle Support SR number, and BugDB is the bug identification number.

Topics:

Topics:

1.6.1 Release 12.2.0.1.2 — September 2017

Bug 25178508 — GGSCI NSK: Allow 63 auxtrails 

Added feature to support the HP enhancement of 63 Transaction Management Facility Auxiliary Audit Trails.

Bug 25981145 — OTHER NSK: Complete enhancement to HP changes for large block entry sequence Enscribe files. 

Certified compliance with the HP enhancement for large block entry sequenced Enscribe files.

Bug 26102719 — EXTRACT NSK: Fix recovery for scanning too much data.

Corrected the Extract restart logic to scan less data from the output trail to determine the correct restart point.

Bug 26267532 — GGSCI NSK: Fix rollover recovery for multiple ETROLLOVER

Corrected restarting an Extract after multiple commands of ETROLLOVER from GGSCI are issued.

Bug 26626360 — Extract NSK: Pump abend- 112 Recovery scan failed (5) in trail file xxx, rba xxxx

Corrected an Extract recovery (restart positioning), when a pump is outputting current trail format and the source was either logger captured or a lower version trail format.

.

Bug 26761362 - Direct read Extract sent incorrect file.

Direct read Extract incorrectly captures the data of files with names similar to the listed file to capture then outputs them with the filename of the file you wanted.

1.6.2 Release 12.2.0.1.1 — April 2017

Bug 25752941 — Fix V11.1 Fileheader Tokens 

Corrected an issue with Extract writing file header tokens that were incompatible with the older trail versions causing Extract pump and or Replicat to abend with the error, File header failed to parse tokens.

Bug 24368944 — Handle Empty TDR Records 

Corrected an issue to handle the condition of reading an OpenSys created a trail that was extracted with NO_OBJECTDEFS.

Bug 24712817 — Propagate Fabricated CSN Information For Fileops In A Pump 

Corrected an issue with the Extract pump to write out the CSN that was fabricated for fileops.

Bug 24757916 — Put Back A Portion Of Checkpoint Conversion

Corrected an issue when you run MIGRATE during an upgrade, the resulting new checkpoints still pointing to objects, reports, and parameter files to the old location.

Bug 24815620 — Pump Trapped At Startup

Corrected an issue with the Extract data pump starting after ETROLLOVER.

Bug 24966785 — CONTROL 21 Error 72

Corrected an issue to handle CONTROL 21 for allocate and deallocate.

Bug 25204612 — Add SCANFORMETADATA

Added a new command, SCANFORMETADATA, for use with metadata records.

Bug 25225355 — Extract Stats For SOURCEISTABLE Showing Zeros For Wrong File Output

Corrected an issue for statistics output from SOURCEISTABLE when multiple tables are written to multiple files.

Bug 25263152 — SOURCEISFILE toRMTTASK Needs Group Name Check From Parameter File

Added support for a bounds check on the group name being present in the parameter file.

Bug 25292668 — Generic REPERROR Errors Missing Value For FILEOP

Corrected an issue of bounds check on the syntax for REPERROR FILEOP.

Bug 25381197 — Fix Uninitialized TACL Variable

Corrected an issue that causes the MIGRATE portion of installations to execute more than once.

Bug 25424005 — Extract Pump Corrupts Existing Tokens When Reading And Mapping Tokens

Corrected issues with the Extract data pump propagating user tokens to the output trail.

Bug 25661031 — NSK Extract Data Pump Doesn't Propagate Existing Tokens To Output Trail

Corrected issues with the Extract data pump propagating user tokens to the output trail.

Bug 25458581 — Derived View Map Is Corrupted After Attributes Are Refreshed.

Corrected an issue when you Extract a view and an ALTER to the base table occurred.

Bug 25491591 — Fix Parsing Issue With Begin Time

Corrected an issue with the GGSCI ADD EXTRACT BEGIN NOW command retrieving up the incorrect records on idle systems.

Bug 25550591 — Add Timestamp To GGSCI Lag Display

Added support for informational timestamp in the reply from GGSCI LAG group command.

Bug 25676878 — Replicat Heap Corruption If the Table Has More than 256 Partitions

Corrected an issue when you Replicat a SQL/MP table that has more than 256 partitions so that 900 is valid again.

Bug 25677559 — Fix Multiple Entries On File Free List

Corrected an issue for file aging that can cause duplicate or corrupted data. This also manifests as a Replicat Error 21 when the file or table name does not match the record length expected.

Bug 25830352 - Replicat Traps With Error 2, in apic_scanforobjectdefs()

Corrected a Replicat abend that traps with error 2 when scanning for metadata and none was in the input trail.

Bug 25831012 - Fix Capturing sortprog Writes to An Unstructured File

Corrected how GGSLIB captured a non-audited write to an unstructured file from sortprog, causing a downstream Replicat to abend with an error 21.

1.6.3 Release 12.2.0.1 — February 2017

Bug 22478185 — Fix Replicat ESEQ Error Message 

Corrected an issue that fixes problems with the files with a block size greater than 4K as a result of the 32K block changes.

Bug 23557196 — Fix An Error 2 On DUP/LOAD For Files With Less Than 4K Block Size 

Corrected an issue to use SETMODE 141,1 for exclusive open on files with a greater than 4K block size.

1.6.4 Initial Release — September 2016

Bug 21836256 — MGR Allow LOGFILESBEHIND To Check EXTTRAILS

Corrected an issue where Manager did not apply LOGFILESBEHIND to Extract trails. Manager now shows Extract trails, not just logger files for LOGFILESBEHIND.

Bug 21778854 — Intercept Of Control Operation From SORT Causes Zero Length Trail Record

Corrected an issue to set the unstructopen flag in the context for opens on unstruct files.

Bug 21475744 - LOGGER debug, Switch Process When Application Crash Not Enough Stack Space

Corrected an issue to better handle stack space errors in BASELIB and have Logger report a bad filename received from BASELIB if it occurs.

Bug 20976346 - Manager Consistently Display LAGCRITICAL Messages When There Seems To Be No Lag

Corrected an issue with Manager incorrectly reported lag, it now resets to zero (0) when at EOF.

Bug 20799603 - Allow File Aging To Happen When Configured With @functions and Filters

Removed restrictions on FILEAGEDAYS for MAP statements containing SQLEXEC, @functions, or filters.

Bug 20230635 - Process Trail Metadata

Added support to read and process trail metadata generated from OpenSys Extract v12.2.

Bug 20230617 - Generate Trail Header

Added support for Extract to write a trail file header.

Bug 19430508 - Fix ENCKEYS Error Response

Fixed an error message when the encryption keyname is not found by showing the correct keyname.

Bug 19187929 - Extract SOURCEIS And RESTARTCHECKPOINTS Corrupts Checkpoint On Missing File

Corrected Extract from corrupting its checkpoint when used with SOURCEISTABLE/SOURCEISFILE and RESTARTCHECKPOINTS,  and one of the file and/or tables is missing.

Bug 18827236 - Handle Processing OpenSys URF Record

Implemented an enhancement that allows OpenSys unified records to be processed by Guardian Extract Pump and Replicat.

Bug 18707922 - Do not Attempt To Create EXTTRAIL During GGSCI > ADD EXTTRAIL

Added option to GGSCI to skip EXTTRAIL creation.

Bug 18345841 - RFE: Purge Current Target File If Enscribe CREATEFILE Gets An Error 10

Changed the REPERROR options to allow the purging of a target Enscribe file on a Create error 10.

Bug 16773609 - Enhancement Support Event Actions On HP NonStop

Implemented an enhancement that allows new support for event marker event actions.

Bug 14845421 — RFE: Extract To Support Volume Name > 6 Characters

Corrected problems with long volume names.

Bug 13961867 - Using Unprintable Characters For FORMATASCII Delimiter

Changed FORMATASCII options to allow you to specify column and record delimiters.

Bug 12558226 - Need All SQL Statements With Control Table Tablelock Off

Added a new parameter CONTROLTABLELOCKOFF for issuing CONTROL TABLELOCK OFF.

Bug 11887421 - Change Extract/Server To Use Non Blocking Sockets

Implemented an enhancement for Extract, Replicat, and Server to use nowaited socket calls to time out orphaned server collectors, and initial load Replicat.

Bug 9870271 - Ability To Define Different Lag Intervals In MGR For Each Group

Implemented an enhancement for Manager to configure LAGINFO and LAGCRITICAL by group.

Bug 9430365 - NSK-3743-GG: Lag Is Not Reported While Replicat Is Waiting For File Open

Corrected an issue in Manager not reporting lag for a running Replicat that is not checkpointing.

Bug 9427846 - Report DOWNCRITICAL , ALLOW Skip Of Stopped

Added an option IGNORESTOPPED to DOWNINFO and DOWNCRITICAL to skip reporting on gracefully stopped processes.

Bug 9417227 - NSK-4269-GG: RFE: ALLOW REPERROR BY IO Type

Implemented an enhancement that allows REPERROR to be processed configured by IO type.

1.7 Known Issues

The following are known issues for this release:

User Exits

If you are using user exits to do primary key updates, you must change the key length fields to a long instead of a short. This is due to the support for the larger records of DDL2.

DEFGEN and DDLGEN 

The DEFGEN and DDLGEN utilities incorrectly type Enscribe Binary-8 as Char (1).

Replicat Mapping

When Replicat is mapping a subset of target columns from and to Enscribe files using differing source and target DDL layouts, the data may be truncated or corrupted while processing updates because of COMPENSCRIBEMAPS.

Direct Read Extract

Direct read Extract incorrectly tries to capture SQL/MP tables that exist in the same subvolume as the wanted Enscribe files, resulting in a file system error 1028.

1.8 Getting Help with Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

1.9 Related Information

The Oracle GoldenGate Product Documentation Libraries are found at

Oracle GoldenGate

Oracle GoldenGate Application Adapters

Oracle GoldenGate for Big Data

Oracle GoldenGate Plug-in for EMCC

Oracle GoldenGate Monitor

Oracle GoldenGate for HP NonStop (Guardian)

Oracle GoldenGate Veridata

Oracle GoldenGate Studio

Additional Oracle GoldenGate information, including best practices, articles, and solutions, is found at:

Oracle GoldenGate A-Team Chronicles

1.10 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.


Oracle Fusion Middleware Release Notes for Oracle GoldenGate for HP NonStop (Guardian), 12c (12.2.0.1)

E57714-05

Copyright © 2005, 2017, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

This guide is intended for installers, database administrators, and system administrators who are installing, configuring and running Oracle GoldenGate.

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Accessible Access to Oracle Support

Oracle customers who have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

The Oracle GoldenGate Product Documentation Libraries are found at

Oracle GoldenGate

Oracle GoldenGate Application Adapters

Oracle GoldenGate for Big Data

Oracle GoldenGate Plug-in for EMCC

Oracle GoldenGate Monitor

Oracle GoldenGate for HP NonStop (Guardian)

Oracle GoldenGate Veridata

Oracle GoldenGate Studio

Additional Oracle GoldenGate information, including best practices, articles, and solutions, is found at:

Oracle GoldenGate A-Team Chronicles

The following text conventions are used in this document:

Convention Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, such as "From the File menu, select Save." Boldface also is used for terms defined in text or in the glossary.

italic

italic

Italic type indicates placeholder variables for which you supply particular values, such as in the parameter statement: TABLE table_name. Italic type also is used for book titles and emphasis.

monospace

MONOSPACE

Monospace type indicates code components such as user exits and scripts; the names of files and database objects; URL paths; and input and output text that appears on the screen. Uppercase monospace type is generally used to represent the names of Oracle GoldenGate parameters, commands, and user-configurable functions, as well as SQL commands and keywords.

UPPERCASE

Uppercase in the regular text font indicates the name of a utility unless the name is intended to be a specific case.

{ }

Braces within syntax enclose a set of options that are separated by pipe symbols, one of which must be selected, for example: {option1 | option2 | option3}.

[ ]

Brackets within syntax indicate an optional element. For example in this syntax, the SAVE clause is optional: CLEANUP REPLICAT group_name [, SAVE count]. Multiple options within an optional element are separated by a pipe symbol, for example: [option1 | option2].