This appendix outlines components of Oracle GoldenGate code used for customer implementations.
This appendix incudes the following sections:
Program/Macro | Description |
---|---|
AUDDUMP |
A utility program to print the contents of the |
AUDSERV |
Reads audited database changes from TMF audit trails. Started by Extract processes. Must be owned by |
AUDSERVN |
Native version of Audserv. As of release 12.1.2, this is named |
BASELIB |
The intercept library that is bound with programs to facilitate non-TMF based database change logging. The TNS mode can be used with programs written in TAL, and C. |
BASELIBN |
Native version of |
BINDEXIT |
TACL macro that merges Extract and Replicat with user exit routines. |
BINDSKEL |
TACL macro that merges |
CHGNOTE |
Notifies |
COMBLIB |
A macro that combines the Oracle GoldenGate intercept library |
COORDINATOR |
Tracks the status of distributed network transactions to coordinate the processing across multiple nodes. |
DBINIT |
A macro that initializes the Oracle GoldenGate checkpoint and configuration files. |
DDLGEN |
Generates target database table definitions based on NonStop DDL. |
DEFGEN |
Generates source table definitions for Replicat to use for the translation of heterogeneous databases. |
EMSDIST |
Contains EMS messaging and tokens for Oracle GoldenGate messages. |
EMSINST |
A macro that installs EMS event message detail text. |
ENTRYLIB |
A macro that combines the Oracle GoldenGate intercept library |
EVCXFUP |
Contains the FUP scripts to create the |
EXTRACT |
Performs database change extract; formats and outputs results. |
EXTRACTN |
Native version of Extract. |
EXTRR |
Native relinkable version of Extract. Use when you have a native user exit to be linked into Extract. The |
FIXFLS |
Adjusts alternate key pointers and turns auditing on proper Oracle GoldenGate files (for example, after duplicating from another location). |
FUPLOG |
Contains the FUP scripts to create the Logger configuration file |
GGSCI |
User interface to Oracle GoldenGate functions. |
GGSDLL |
The default name of the executable version of native |
GGSLIB |
User library bound with application programs to facilitate non-TMF based database change extract. |
GGSLIBR |
Native relinkable version of |
GGSSRL |
The default name of the executable version of native |
INSTALL |
TACL macro that creates database files and performs other installation tasks. |
KEYGEN |
Program used to generate random keys. Used for encryption. |
LEANBIND |
A macro that removes the several routines out of |
LOGDUMP |
A program that provides the ability to display or search for information stored in log trails, extract trails, or extract flat files. |
LOGDUMPT |
A version of |
LOGGER |
Writes non-TMF audited database changes to log trails. |
MEASFLS |
A utility that interfaces with Measure to collect data about file I/O at specified intervals. |
MEASRPT |
A utility that generates reports based on data collected from MEASFLS. |
MGR |
Carries out resource management functions as configured by system administrators. |
MIGRATE |
Moves checkpoint and other data from an old to a new Oracle GoldenGate installation. |
NLDEXIT |
A macro used to combine a native version of the intercept libraries. |
NLDLIB |
A macro used to create a native version of the intercept libraries. |
READER |
Monitors trails for distributed network transactions and communicates status information to the Coordinator. |
REPLICAT |
Replicates selected database changes from a set of source Enscribe files and SQL tables to a set of target files and tables. |
REPNP |
The TNS version of Replicat; does not contain the privilege code procedures. This can be used for debugging user exits without requiring |
REPR |
A relinkable, native version of Replicat. Used when linking native user exits. |
REVERSE |
"Reverses" operations in an extract file so that Replicat can selectively back out changes rather than replicate them. |
SCANGRP |
A utility used by the MIGRATE utility to scan and convert group records. |
SEGDUMP |
A utility program used to examine the contents of the private context segment maintained by |
SERVER |
Another name for the Collector that receives data over TCP/IP and writes data to remote trails. |
SFGEXIT |
A program that can be activated within NonStop Safeguard to audit update access file opens and issue a message if no Oracle GoldenGate intercept program is bound in. |
SQLCOMPS |
List of SQLCOMP commands for Oracle GoldenGate programs. |
SYNCFILE |
Performs file replication of non-database files based on a user-set schedule. |
TMFARLB2 |
A distributed TMF audit read library. |
TMFARUL2 |
A distributed TMF audit read library. |
UNPAKIT |
A macro that performs the |
The Oracle GoldenGate database is created at installation time with the INSTALL macro. Each database file and its function are listed in the next table.
Database File | Description |
---|---|
AUDCFG |
A dynamically created shared segment file used for |
AUDSPEC |
Contains audit management configuration parameters set up with GGSCI and read by Manager to perform audit management tasks. |
CONTEXT |
Contains Extract checkpoints to facilitate continuous processing of audit for particular Extract groups. Used by Manager to determine whether particular audit resources are still required. |
EXTCTXT |
Contains Extract checkpoints to track restart points within extract files in case Extract halts prematurely. Also contains information about individual extract trail dimensions and management. |
EXTCTXT0 |
Alternate key file for |
GROUP |
Contains each distinct Extract processing group. |
LOGCONF |
Stores logger configuration. |
LOGGGS |
Keeps log of critical events. |
MRKRGGS |
Audited file that accepts audit marker records. |
REMCTXT |
Contains the names of local and remote |
REPCTXT |
Contains Replicat checkpoints to facilitate continuous processing of extract information. Used by Manager to determine whether particular extract file resources are still required. |
REPCTXT0 |
Alternate key file for |
REPGRP |
Contains each distinct Replicat processing group. |
RMTCTXT |
Contains checkpoints for remote extract files. |
SYNCGRP |
Contains each distinct Syncfile processing group. |
Component | Description |
---|---|
TMF Audit Trails |
Contain change data information for source file and table insert, update and delete operations. Audit trails are read by Extract processes with Audserv for relevant database changes. Each audit trail can be read from one of four locations: the original location (on disk), from a disk dump, restored to disk from tape, or from a duplicate created by Manager. |
Extract Files |
Created by Extract processes. Extract files contain formatted database change records that can be input to Replicat processes, user-written applications or utilities. Extract processes can write to a single extract file, or a sequence of extract files known as extract trails. Manager purges extract files. |
SQL and Enscribe Database Files |
Database files that are the source of extract and target of delivery activities. |
Parameter Files |
Parameter files provide run-time parameters for all Oracle GoldenGate processes. There is no facility for entering parameters interactively, so parameter files are required. |
Report Files |
Extract and Replicat generate reports detailing statistical highlights of processing. Report files can be virtually any format, including spooler, edit files or the home terminal. |
DDL Dictionaries |
Dictionaries are an optional component of Extract and Replicat processing. DDL dictionaries describe Enscribe records processed by Extract and Replicat. This lets you describe record selection and column mapping criteria for both Extract and Replicat activities. The dictionaries must have been compiled using C30 or later DDL. |
SQL Catalogs |
Provide the definition of extracted SQL database change records. You need read access to the catalog associated with any source and target SQL tables. The catalogs allow Extract and Replicat to decode audit records and to build replicate SQL operations. |
User Exit Routines |
Object files you create that are bound in with Extract or Replicat to perform customized routines. |
Error Console |
Extract and Replicat send errors and warnings to both the error console and to the report file. The default error console is the home terminal. You can change the error console with the statement |
File | Description |
---|---|
DDLEXIT |
DDL for creating copy files for user exit and API routines. |
DEMOCL |
C include library for user exit demos. |
DEMOCOBL |
COBOL copy library for user exit demos. |
DEMOEDDL |
Sample DDL scripts for sample Enscribe files. |
DEMOFUPS |
Sample FUP scripts to create sample Enscribe source files. |
DEMOFUPT |
Sample FUP scripts to create sample Enscribe target files. |
DEMOOLDE |
Source code for the DEMOLEDO Enscribe demo program that performs inserts and updates for sample files. |
DEMOLDEO |
Program used to generate insert and update operations for sample Enscribe files. |
DEMOLDS |
Sample data for tables created by DEMOSQL. |
DEMOSQL |
SQL table creation DDL for sample TMF delivery User Tutorial example. |
DEMOXC |
An example user exit written in C. |
DEMOXCOB |
An example user exit written in COBOL. |
HELP |
Help file for GGSCI. |
TCPERRS |
Contains TCP/IP error handling parameters. |
TMPLMSA |
|
TMPLMSS |
|
TMPLORA |
|
TMPLTDM |
|
TMPLSYB |
|
TMPLDB2 |
|
TMPLDB2M |
|
USEREXC |
Blank template that can be used as a starting point for C user exits. |
USEREXT |
Blank template that can be used as a starting point for TAL user exits. |
XLIBC |
Include library for writing C user exits and interfacing to API. |
XLIBCOB |
Copy library for writing COBOL user exits and interfacing to API. |