Happy to announce the release of HP NonStop for Oracle GoldenGate 23ai with a wide range of new features and enhancements.

This release contains several new features, some of which causes behavior changes and possibly require parameter modification depending on the version you are currently using.

New Parameters

Replicat can now defer applying transactions until a specific amount of time has elapsed using DEFERAPPLYINTERVAL.

Extract and Replicat now have use of a new Colmap function @SizeOf( ) to allow the removal of hard coded lengths in mapping. This can be especially useful while using the @GETTLFTOKEN().

Added the ability to use =Defines in LogParm for non audited Logger capture.

Added the parameter CHECKTHRESHOLDMIN for manager to alter the frequency that checks and reports TMF DISKTHRESHOLD percent.

Parameter Changes

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

Extract now has the option RECEIVERPORT for the RMTHOST parameter to communicate with an OpenSys MicroServices install. This should be used instead of MGRPORT or PORT.

Extract uses the MAXFILESTHRESHOLD as the number files left before MAXFILES is about to be reached that are displayed to EMS as critical warnings with emphasis. You now can set the MAXFILESTHRESHOLD on a per EXTTRAIL basis from GGSCI.

EVENTACTIONS can be used to trigger an event based on a file or table receiving a DML record. Added a new option CLOSEFILES to EVENTACTIONS to cause all open files and tables to be closed.

The User Exit parameters for Extract and Replicat have been modified to accommodate using Dynamically Linked Libraries.

Enhancements

  • Enhanced Extract and Replicat to allow the use of a shared object DLL User Exit.
  • Added support for volume names up to 7 bytes when only used for Enscribe.
  • Corrected lost error text on parsing details of @function() calls.
  • Corrected the double reporting of missing audit.
  • Change formatting of warning messages for ambiguous referenced columns during mapping to give clearer indication of unintended name matches.
  • Corrected the requirement for HandleCollisions to be used to skip the Delete portion of a missing target record of a PKUpdate.
  • Corrected the file stat after a User Exit returned Ignore Record such as the Base24 Rename that occurs during a Refresh.
  • Added a new column function to return the size of a column or Enscribe group level field.
  • Corrected the default values of pic 9 fields to ASCII Zeros instead of binary zeros, which could cause an error -8405 when replicating data from OpenSys.
  • Corrected handling of procedure death message from TMFSERVE that caused the GGSCI system command to fail.
  • Corrected the display value of compression stats.
  • Corrected Replicat from not releasing file locks on Key Sequenced Enscribe when the lock length is not the same as the key length.
  • Added the option of CLOSEFILES to the eventActions clause of MAP.
  • Changed to ensure no existing processes are running if the product is reinstall to an existing location.
  • Corrected marker history performance issues by changing read/write processing to do 56K I/O.
  • Allow the warning threshold default of 2 on MaxFiles to be changed.
  • Added full detailed display to the response a remote manager returns from GGSCI> GETMGRVERSION.
  • Added the capture of procedure call FS_FILEPURGE_, which executes during FUP PARTONLY DUP.
  • Added current read location and last completed CSN to both Extract and Replica reports after send report and Stop commands.
  • Correct the timestamp associated with any configured AUX trails after an alter by Extseqno and Extrba.
  • Added SQL/MP error details on error getting partition details from the catalog.
  • Changed the mode of testing if a report file was going to become full from a timer to a prewrite test.
  • Changed Extract from holding aborted transaction data through the rollback unless GetRollBacks is in use.
  • Added a more meaningful message that the Open System Services File System is required.
  • Changed Extract to update the fileheader URI History value with producer info.
  • Corrected the network checkpoint written to REPCTXT to only write actual record length, not size of record.
  • Corrected the formatting of the fractional part of a Timestamp/Datetime datatype.
  • Enhanced Replicat to wait a predetermined amount of time before applying data.
  • Corrected the handling of Unified PkUpdate from OpenSys when columns are compressed out and or missing from a source OpenSys DB.
  • Deprecated the antiquated ATCONFIG for TMF recovery in favor of TMF Tape and Dumps.
  • Corrected to ensure ENTRYLIB exists so a combined library will not be built without it.
  • Corrected Replicat to handle a control that was intercepted without a prior open, caused by the intercept being built without ENTRYLIB.
  • Added process details to the report banners.
  • Corrected handling of NSK formatted names coming from OpenSys where the node name was removed.
  • Corrected a possible trap in an Extract pump when converting floats.
  • Removed the TNS Extract and Replicat object from the distribution.
  • Added the ability to use =Defines in LogParm for non audited capture.
  • Added the ability to reference an expression while doing a SqlExec in a map statement.
  • Corrected the name passed to a User Exit when a Fileop was performed before a DML.
  • Clarified an error message when a remote host was not configured in globals.
  • Added the MaxLogfiles configured for a Logger process from the GGSCI info logger command.
  • Corrected trail stats to match file buckets for marker records that had been previously hidden.
  • Corrected the Defgen output to remove group level Enscribe fields as part of key.
  • Added the ability to use RMTHOSTALT with MGRPORT and other supporting parameters.
  • Added the display of session params to the env command from GGSCI.
  • Added a bounds check on invalid NSK names with extra digits.
  • Corrected the ability to have Extract restart without skipping duplicate records.
  • Corrected and stopped Enscribe Auditcomp records from being sent to an OpenSys target.
  • Added more details to the report display after Extract gets an IP connect to a remote process.
  • Add missing bounds check to ensure one of either BeforeFilter or AfterFilter was provided.
  • Clarified abend message for an incorrectly installed product.
  • Added to the display info on a DirectRead Extract group to show the type, such as, ACITLF, ENTRY, or ADVANTAGE.
  • Corrected the padded allotment to account for the AES initialization vector being appended to the message.
  • Corrected GGSCI from updating REPCTXT records to 4040 bytes when altering a group to use actual count.
  • Corrected limitation of OpenSys ANSI table name longer than 48 bytes.
  • Corrected manager from trapping by adding a bound check on incoming messages to manager when a process is sending messages larger than it can handle.
  • Corrected positioning into a report file when viewing the last or end of a very large report.
  • Corrected dangling logfile opens due to SIGNALTIMEOUT failures.
  • Corrected the error testing during reading of parameter files from view command.
  • Added display of rate per interval when reporting ReportCount.
  • Corrected parsing of Extract parameter AUDSERVPARAM option ARLIBERROR <error>, <action> .
  • Corrected a TMF Extract getting an error “Unable to add new file MRKRGGS” for a marker file from a different Oracle GoldenGate installation on the same node.
  • Deprecated and removed the use of BlowFish encryption from the product. This affects the GGSCI command Encrypt Password, the Logon parameter to Extract and Replicat, as well as Extract encryption over IP.
  • Added RECEIVERPORT for Extract to send RMTTRAIL data to an OpenSys MicroServices remote and properly test valid parameters. This is to be used instead of either PORT or MGRPORT.
  • Corrected Extract to output a restart abend record on restarting after Extract reached the configured Maxfiles causing an abend.

Base 24 for HP NonStop for GoldenGate

Base 24 for HP NonStop for GoldenGate 23ai is available on eDelivery. The following Documentation can be downloaded from the site:

  • D24 Dual Site Supplemental Guide
  • N24 Notifications Supplemental Guide
  • T24 Tokenized Data Supplemental Guide

 

Want to Know More about HP NonStop for GoldenGate?

Documentation