Marker procedures and shadow tables  Reserved names

Chapter 2: Replication Agent for Informix

Transaction log objects for each marked table

Table 2-7 lists the Replication Agent transaction log objects that are created for each primary table that is marked for replication. These objects are created only when a table is marked for replication. These objects are not considered transaction log base objects and are not displayed by the pdb_xlog command as the other objects are.

No permission is granted on these procedures.

Table 2-7: Replication Agent transaction log objects for each marked table

Object

Database name

shadow table

prefixsh_xxx

shadow row procedure

prefixsrp_xxx

LOB shadow table

prefixbsh_xxx

LOB shadow row procedure

prefixbsrp_xxx

insert trigger

prefixinstrg_xxx (or existing-trigger name)

update trigger

prefixupdtrg_xxx (or existing-trigger name)

delete trigger

prefixdeltrg_xxx (or existing-trigger name)

NoteThe marked objects table records the mapping between marked objects and their corresponding shadow tables and shadow row procedures. The pdb_setreptable and pdb_setrepproc commands return the names of the shadow tables and shadow row procedures.




Copyright © 2005. Sybase Inc. All rights reserved. Reserved names

View this book as PDF