Download Guide to Informix Enterprise Replication, Version 9.2
Transcript
Delete Tables Delete Tables Enterprise Replication creates delete tables only if you use time stamp and/or a procedure written in SPL (Stored Procedure Language) as your conflict-resolution rules. Delete tables keep track of modified rows and are used for conflict resolution. Enterprise Resolution creates and manages these tables. Neither the end user nor the database administrator interacts directly with the delete tables. Delete tables are created on the database server where the data originates and on all the database servers to which data gets replicated. Delete tables are stored in the same dbspaces as their base tables. If the base table has 100 megabytes of data, but only half the rows might be deleted or modified, then 50 megabytes is a reasonable estimate for the size of the delete table. Tip: Delete tables are automatically deleted when the last replicate defined with conflict resolution on a table is deleted. Spooling Directories The aborted-transactions spooling (ATS) and row-information spooling (RIS) hold information about failed transactions. The default location for these directories is /tmp (UNIX) or \tmp (Windows NT). Informix recommends that you not leave the spooling directories in the default location but assign them to directories that you control. For information about ATS and RIS, refer to Chapter 10, “Diagnosing Enterprise Replication.” Setting Up Your Replication Environment 5-7
Related documents
Guide to IBM Informix Enterprise Replication
IBM Informix Dynamic Server Enterprise Replication Guide
Guide to Informix Enterprise Replication, Version 7.3
UCM6510 User Manual
here
IBM Informix Migration Guide
ACS-102 Sistema de Alarme via-rádio de 2 canais Manual
Istruzioni per l`uso originali Robolift compact
UCM6510 User Manual - Grandstream Networks
Chapter
User Guide - COMMON ROMANDIE
Grandstream UCM6510 User Manual