The following describes the items that are installed during the SharePlex setup process.
SharePlex uses two main directories:
The product directory: This is the SharePlex installation directory, where the SharePlex programs and libraries are stored.
The variable-data directory: This is the SharePlex working directory, where the queue files, log files and other components that comprise the current replication environment are stored.
Note: These directories are often referred to as productdir and vardir, respectively.
Do not remove, rename or edit any files or directories installed by SharePlex. Some directories contain hidden files that are essential for replication. Some files appear empty but must exist under their original names because they are referenced by one or more SharePlex processes. Some items in the directories are for use only under the supervision of Quest Technical Support.
Programs meant for general use in a production environment are documented in the published SharePlex documentation. If you do not find documentation for a program in a SharePlex directory, do not attempt to run it. Contact Quest Technical Support first.
The directory structure and files within the two main SharePlex directories differs slightly between the UNIX and Windows platforms. Files and directories can vary from version to version of SharePlex, but the basic structure appears as follows.
|bin||SharePlex executable files|
|data||Default parameter settings|
|install||(Unix and Linux only) Scripts related to installation, licensing and upgrades|
|lib||SharePlex shared libraries|
|.app-modules||(Unix and Linux only) Hidden internal directory that contains raw executables. Do not use the contents of this directory to launch processes.|
|.meta-inf||(Unix and Linux only) Hidden internal directory that contains meta information used during the installation process.|
|config||Configuration files for this installation of SharePlex.|
|data||Status Database, configuration activation information, user-defined parameter settings, and other user-defined files that direct replication activities.|
|db||Configuration internal database for each activation of a configuration file.|
|dump||Core files (if a process fails)|
|log||SharePlex log files|
|rim||Queue files (working data files)|
|save||Information about active and inactive configurations.|
|state||Information about the current state of SharePlex when a configuration is active, such as the object and sequence caches.|
|temp||Used by the copy and append features and other SharePlex sync-related processes.|
|oos||Stores the transactions that contain out-of-sync operations when the SP_OPO_SAVE_OOS_TRANSACTION parameter is enabled.|
Much of the replication process is controlled and tracked through a series of internal tables that are installed into the source or target database during the installation of SharePlex. They are essential for SharePlex to operate, so do not alter them in any way.
NOTE: Not all tables are used for all databases. If you do not see one, it is not relevant to the database. If you see one not in this list, it is not being used in the current release.
|DEMO_SRC||Used as the source table for the SharePlex demonstrations.|
|DEMO_DEST||Used as the target table for the SharePlex demonstrations.|
|SHAREPLEX_ACTID||Used by Capture to checkpoint its state.|
|SHAREPLEX_ANALYZE||Used by the analyze command.|
|SHAREPLEX_CHANGE_OBJECT||Used by users to stop and resume replication for an object.|
|SHAREPLEX_COMMAND||Used for the flush, abort and purge commands.|
|SHAREPLEX_CONFIG||Used by the activation and Capture processes to mark the start of a new activation.|
|SHAREPLEX_DATA||Used by the SharePlex wallet.|
|SHAREPLEX_DATAEQUATOR||Used by the compare and repair commands and the Post process to synchronize their operations.|
|SHAREPLEX_DATAEQUATOR_INSERT_TEMP||Used as a temporary table by the compare and repair commands.|
|SHAREPLEX_DATAEQUATOR_UPDATE_TEMP||Used as a temporary table by the compare and repair commands.|
|SHAREPLEX_DATAEQUATOR_DELETE_TEMP||Used as a temporary table by the compare and repair commands.|
|SHAREPLEX_DDL_CONTROL||Used to refine control of DDL that is enabled for replication by the SP_OCT_REPLICATE_ALL_DDL parameter.|
|SHAREPLEX_JOBS*||Used by the sp_cnc process and the compare, repair, and copy commands to store information about a job.|
|SHAREPLEX_JOB_STATS||Used by the sp_cnc process and the compare, repair, and copy commands to store information about a job.|
|SHAREPLEX_JOBS_CONFIG||Used by the disable jobs and enable jobs commands.|
|SHAREPLEX_LOB_CACHE||Used by the Capture process when processing VARRAYs stored as LOB.|
|SHAREPLEX_LOBMAP||Used by the Capture process to map LOBIDs and rows when a table with LOB columns does not have PK/UK logging enabled.|
|SHAREPLEX_LOGLIST||Used by the Capture process to track inactive RAC instances.|
|SHAREPLEX_MARKER||Used by the Read process when PK/UK logging is not enabled.|
|SHAREPLEX_OBJMAP||Used by the activation and Capture processes to define the objects in replication.|
|SHAREPLEX_PARTITION_CACHE||Used by the Capture process to map Oracle partition IDs to tables in replication.|
|SHAREPLEX_SYNC_MARKER||Used by the copy command and the Read and Post processes to sync their operations.|
|Used by the Post process to store checkpoints and to mark transactions that were applied in a master-to-master configuration.|
* Additionally, SharePlex creates the SHAREPLEX_JOBID sequence for use by the sp_cnc process and the compare, repair, and copy commands to provide a unique job ID.
On the Windows platform, SharePlex installs the MKS Toolkit® operating environment from Parametric Technology Corporation (PTC), formerly known as Mortice Kern Systems NuTCRACKER. This software enables SharePlex to be ported to all supported platforms in a uniform manner.
SharePlex users have no interaction with the MKS Toolkit software, other than to ensure that its service is running when the SharePlex service is running. The MKS Toolkit is installed in automatic startup mode by default when it is installed during SharePlex installation.
The default folder for MKS Toolkit is C:\Program Files\MKS Toolkit, but a different folder might have been selected during installation. The MKS Toolkit files must not be moved after they are installed.
On Windows systems, SharePlex installs the following Registry entries.