Wednesday, October 26, 2016

What are the various Golden Gate sub directories for?
 
Question What are the functions of the various sub directories within the Golden Gate installation directory?
  • dirchk
Contains the checkpoint files created by Extract and Replicat processes, which store current read and write positions to support data accuracy and fault tolerance. Written in internal GoldenGate format. File name format is <group name><sequence number>.<ext> where <sequence number> is a sequential number appended to aged files and <ext> is either cpe for Extract checkpoint files or cpr for Replicate checkpoint files. Do not edit these files.
Examples: ext1.cpe rep1.cpr
  • dirdat
The default location for Golden Gate trail files and extract files created by Extract processes to store records of extracted data for further processing, either by the Replicate process or another application or utility. Written in internal Golden Gate format. File name format is a user-defined two-character prefix followed by either a six-digit sequence number (trail files) or the user-defined name of the associated Extract process group (extract files). Do not edit these files.
Examples: rt000001 finance
  • dirdef
The default location for data definitions files created by the DEFGEN utility to contain source or target data definitions used in a heterogeneous synchronization environment. Written in external ASCII. File name format is a user-defined name specified in the DEFGEN parameter file. These files may be edited to add definitions for newly created tables. If you are unsure of how to edit a definitions file, contact GoldenGate technical support.
Example: defs.dat
  • dirpcs
Default location for status files. File name is <group>.<extension> where <group> is the name of the group and <extension> is either pce (Extract), pcr (Replicat), or pcm (Manager). These files are only created while a process is running. The file shows the program name, the process name, the port and process id that is running. Do not edit these files.
Examples: mgr.pcm ext.pce
  • dirprm
The default location for GoldenGate parameter files created by GoldenGate users to store run-time parameters for GoldenGate process groups or utilities. Written in external ASCII format. File name format is <group name/user-defined name>.prm or mgr.prm. These files may be edited to change GoldenGate parameter values. They can be edited directly from a text editor or by using the EDIT PARAMS command in GGSCI.
Examples: defgen.prm finance.prm

  • dirrpt
The default location for process report files created by Extract, Replicat, and Manager processes to report statistical information relating to a processing run. Written in external ASCII format. File name format is <group name><sequence number>.rpt where <sequence number> is a sequential number appended to aged files. Do not edit these files.
Examples: ABC.rpt MGR4.rpt
  • dirsql
The default location for scripts created by the TRIGGEN utility to contain SQL syntax for creating GoldenGate logging triggers and GoldenGate log tables. Written in external format.
File name format is a user-defined name or the defaults of GGSLOG (table-creation script) or the table name (trigger-creation script), with the extension of .sql. These scripts can be edited if needed.
Examples: ggslog.sql account.sql
  • dirtmp
The default location for storing large transactions when the size exceeds the allocated memory size. Do not edit these files.

No comments:

Post a Comment