Index

• --ackq option
  • cdr stats rqm
• --add option
  • cdr change replicate (1), (2)
  • cdr change replicateset (1), (2)
• --all option
  • cdr define template
  • cdr error
• --applyasowner option
  • cdr realize template
• --at option (1), (2)
  • time formats
• --ats option (1), (2), (3), (4)
  • cdr define server
  • cdr modify replicate
  • cdr modify server
• --autocreate option
  • cdr change replicate
  • cdr define replicate
  • cdr realize template (1), (2)
• --blocksize option
  • cdr define repair
• --cntrlq option
  • cdr stats rqm
• --conflict option
  • cdr define replicate
• --connect option
  • and database server name
  • connecting to another replication server
• --database option
  • cdr define template
• --dbspace option
  • cdr realize template
• --delete option (1), (2)
  • cdr change replicate
  • cdr change replicateset
• --empty option
  • cdr define replicate
• --every option (1), (2)
• --exclusive option
  • cdr define replicateset
  • cdr define template
• --extratargetrows option
  • cdr check replicate
  • cdr check replicateset
  • cdr define repair
  • cdr realize template
  • cdr start replicate
  • cdr start replicateset
  • cdr sync replicate
  • cdr sync replicateset
• --file option
  • cdr define template
• --filter option
  • cdr define repair
• --firetrigger option (1), (2)
  • cdr modify replicate
• --floatcanon option (1), (2)
• --floatieee option
• --follow option
  • cdr error
• --fullrow option (1), (2)
  • cdr modify replicate
• --idle option
  • cdr define server (1), (2)
  • cdr modify server
• --ignoredel option
• --immed option (1), (2)
• --init option
  • cdr define server
• --leaf option
  • cdr define server
• --master option
  • cdr define replicate
  • cdr define template
  • cdr remaster
• --mirrors option (1), (2)
• --name option
  • cdr define replicate
  • cdr modify replicate
• --nonroot option
  • cdr define server
• --off option
  • cdr alter
• --on option
  • cdr alter
• --optimize option
  • cdr define replicate
• --primaryid option
  • cdr swap shadow
• --primaryname option
  • cdr swap shadow
• --prune option
  • cdr error
• --recvq option
  • cdr stats rqm
• --replicate option
  • cdr define repair
• --replset option
  • cdr define repair
• --ris option (1), (2), (3)
  • cdr define server
  • cdr modify replicate
  • cdr modify server
• --sendq option
  • cdr stats rqm
• --seq option
  • cdr error
• --shadowid option
  • cdr swap shadow
• --shadowname option
  • cdr swap shadow
• --sync option
  • cdr define server
• --syncdatasource option (1), (2)
  • cdr check replicateset
  • cdr delete repair
  • cdr realize template
  • cdr start replicate
  • cdr start replicateset
• --syncq option
  • cdr stats rqm
• --target option
  • cdr realize template
• --verify option
  • cdr change replicate
  • cdr define replicate
  • cdr realize template (1), (2)
• --zap option
  • cdr error
• -e option
• /etc/hosts.equiv file
• \etc\hosts.equiv file
• /etc/hosts file
• \etc\hosts file
• /etc/services file
• \etc\services file
• -f option
• $INFORMIXDIR/bin directory
• $INFORMIXDIR/gls/cv9 directory
• $INFORMIXDIR/incl/esql/cdrerr.h file
• —master option
  • cdr check replicate
  • cdr check replicateset
  • cdr sync replicate
  • cdr sync replicateset
• —nomark option
  • cdr error
• —repair option
  • cdr check replicate
  • cdr check replicateset
• —repl option
  • cdr check replicate
  • cdr sync replicate
• —replset option
  • cdr check replicateset
  • cdr sync replicateset
• —scope option
  • cdr define replicate
• —verbose option
  • cdr check replicate
  • cdr check replicateset
• .rhosts file
• -S option

• Abbreviations
  • cdr define replicate set
  • commands
  • options
• Aborted rows, and ATS files
• Aborted Transaction Spooling.
  • See ATS.
• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• Activating
  • ATS
  • RIS
• Active state
  • defined
  • server
• ADD CRCOLS
  • defining shadow columns
• Adding
  • chunks to storage spaces
  • participants to replicates
  • rowids
• Administering Enterprise Replication
  • CLU
  • ISA
  • overview
• Alarms
  • event
• Alter mode
• Alter operations
  • performing on replicated tables
  • troubleshooting
• ALTER TABLE statement
  • See also IBM Informix Guide to SQL
  • ADD and DROP CRCOLS
  • in-place alters
• Always-apply conflict resolution rule
• Always-apply conflict-resolution rule (1), (2), (3)
• Application
  • specific routines
• Applying data, process
• Arguments
  • SPL routines (1), (2)
• Asynchronous
  • data replication
  • propagation, considerations
• ATS
  • activating (1), (2)
  • capacity planning
  • filenames, description
  • files
    • BLOB and CLOB information
    • BYTE and TEXT data
    • changed column information
    • configuring
    • defined
    • naming conventions
    • preparing to use
    • smart large objects
    • UDT information
    • UDTs
  • modifying directory
  • specifying directory (1), (2), (3), (4)
• ATS files
  • repair using
• Attaching fragments
• Attribute
  • replicate, changing
  • viewing
• Automatic remastering
• Automatic table creation (1), (2)
• Average large object size.
  • See AVG_LO_SIZE configuration parameter.
• AVG_LO_SIZE configuration parameter

• Backups
  • databases, considerations
• Batch jobs
• BEGIN WORK WITHOUT REPLICATION
  • behavior
  • DB-Access
  • ESQL/C
  • example
  • running batch jobs
• Bitmap
  • information in logical log files
• BLOB data type
  • information
    • ATS files
    • RIS files
  • spooled row data
• Blobs.
  • See Simple large object.
• Blobspaces
  • inconsistent replicated data
  • replicating
  • storing simple large objects
• Blocking
  • replication
• Boldface type
• Buffers
  • tables, columns
  • transaction, spooling to disk (1), (2)
• Business models, primary-target systems
• BYTE data
  • ATS files
  • distributing
  • loading with deluxe mode
  • RIS files
  • SPL conflict resolution
  • storing in tblspaces

• Canonical format (1), (2)
• Capacity planning
  • for delete tables
  • primary-target
  • spooling directories
  • update-anywhere
• Capture mechanisms
  • log-based data capture
  • trigger-based data capture
  • trigger-based transaction capture
• Cascading deletes
  • considerations
• cdr alter (1), (2)
• cdr change replicate
  • adding and deleting participants
  • examples
  • syntax
• cdr change replicateset
  • adding
  • adding or deleting replicates
  • examples
• cdr change replicateset.
  • See cdr change replicateset.
• cdr check replicate (1), (2)
• cdr check replicateset (1), (2)
• cdr cleanstart
• cdr connect server (1), (2)
• CDR_DBSPACE configuration parameter (1), (2)
• cdr define repair
  • options
  • syntax
• cdr define replicate (1), (2)
  • defining participants
  • examples
  • syntax
• cdr define replicateset
  • abbreviation
  • creating replicate sets
  • examples
  • syntax
• cdr define replicateset.
  • See cdr define replicateset.
• cdr define server
  • defining replication servers
  • examples
  • options
  • syntax
• cdr define template (1), (2)
  • syntax
• cdr delete repair
  • syntax
• cdr delete replicate
  • deleting a replicate from the global catalog
  • examples
  • syntax
• cdr delete replicateset
  • deleting a replicate set
  • examples
• cdr delete server
  • deleting a replication server
  • examples (1), (2)
  • syntax
• cdr delete template (1), (2), (3), (4), (5)
  • syntax
• cdr disconnect server
  • dropping Enterprise Replication network connection
  • examples
  • syntax
• CDR_DSLOCKWAIT configuration parameter
• CDR_ENV configuration parameter
• cdr error
  • examples
  • options
  • syntax
• CDR_EVALTHREADS configuration parameter (1), (2)
• cdr finderr (1), (2)
• cdr list repair
  • syntax
• cdr list replicate
  • brief
  • examples
  • syntax
  • viewing properties of replicate
• cdr list replicateset
  • examples
  • syntax
  • viewing properties of replicate set
• cdr list server
  • CONNECTION CHANGED column
  • description of output
  • determining current state of server
  • examples (1), (2)
  • ID column
  • QUEUE column
  • SERVER column
  • STATE column
  • STATUS column
  • syntax
  • viewing network connection status
• cdr list template (1), (2), (3)
  • syntax
• CDR_LOGDELTA environment variable
• CDR_MAX_DYNAMIC_LOGS configuration parameter (1), (2)
• cdr modify replicate
  • changing attributes of a replicate
  • examples
  • options
  • restrictions
  • syntax
• cdr modify replicateset
  • changing replication frequency
  • examples
  • syntax
• cdr modify server
  • --mode option
  • changing attributes of server
  • examples
  • options
  • syntax
• CDR_NIFCOMPRESS configuration parameter (1), (2)
• CDR_PERFLOG environment variable
• CDR_QDATA_SBSPACE configuration parameter (1), (2), (3), (4)
• CDR_QHDR_DBSPACE configuration parameter (1), (2), (3)
• CDR_QUEUEMEM configuration parameter (1), (2), (3)
• cdr realize template (1), (2), (3)
  • options
  • syntax
• CDR record type
• cdr remaster
  • option
  • syntax
• cdr remove
  • syntax
• cdr repair (1), (2)
• cdr resume replicate
  • examples
  • resuming a suspended replicate to active
  • syntax
• cdr resume replicateset (1), (2), (3)
• cdr resume server (1), (2)
• CDR_RMSCALEFACT environment variable
• CDR_ROUTER environment variable
• CDR_SBSPACE configuration parameter
• CDR_SERIAL configuration parameter (1), (2)
• cdr start
  • examples
  • restarting on a stopped server
  • syntax
• cdr start repair (1), (2)
• cdr start replicate (1), (2)
  • changing replicate state to active
  • options
  • syntax
• cdr start replicateset
  • changing state of all replicates in a replicate set to active
  • options
  • syntax
• cdr stats recv
  • syntax
• cdr stats rqm
  • options
• cdr stop
  • examples
  • stopping capture of data
  • syntax
• cdr stop repair (1), (2)
• cdr stop replicate
  • examples
  • stopping a replicate
  • syntax
• cdr stop replicateset
  • examples
  • stopping replicates in a replicate set
  • syntax
• CDR_SUPPRESS_ATSRISWARN configuration parameter (1), (2)
• cdr suspend replicate
  • examples
  • halting processing for a replicate
  • syntax
• cdr suspend replicateset
  • examples
  • suspending replicates in a replicate set
  • syntax
• cdr suspend server
  • examples (1), (2)
  • suspending replication of data to the server
  • syntax
• cdr swap shadow (1), (2), (3)
• cdr sync replicate (1), (2)
• cdr sync replicateset (1), (2)
• cdrerr.h file
• cdrserver shadow column
  • See also Shadow columns.
  • behavior with BEGIN WORK WITHOUT REPLICATION
  • cdrserver (1), (2)
• CDRSITES_731 environment variable
• CDRSITES_92X environment variable
• cdrtime shadow column
  • See also Shadow columns.
  • behavior with BEGIN WORK WITHOUT REPLICATION
  • defined
  • defining
  • Enterprise Replication recording value of
• Central registry
  • SQLHOSTS
• Changing
  • column information
    • in ATS files
    • in RIS files
  • columns, replicating
• Checksum functions
• Child database server
• Choosing a replication network topology
• Chunks
  • adding to
    • storage spaces
• Cipher
  • encryption
• CLOB type
  • ATS files
  • RIS files
  • spooled row data
• Clock synchronization (1), (2)
• CLU.
  • See Command-line utility.
• Code, sample, conventions for
• Codeset conversion files
• Cold restores
• Collision
  • defined
  • example
• Columns
  • in transaction tables
  • primary key
  • replicating changed only
  • shadow
    • See Shadow columns.
  • virtual
• Command-line conventions
  • how to read
  • sample diagram
• Command-line utility
  • See also Command.
  • --connect option
  • administering Enterprise Replication
  • commands
  • defined
  • syntax, interpreting
  • terminology
• Commands
  • dbaccess
  • net time
  • onspaces (1), (2), (3)
  • onstat -g ath
  • onstat -g cat
  • onstat -g ddr
  • onstat -g dss
  • onstat -g dtc
  • onstat -g grp
  • onstat -g nif
  • onstat -g que
  • onstat -g rcv
  • onstat -g rep
  • onstat -g rqm
  • onstat utility (1), (2), (3), (4)
  • ping
  • rdate
  • synchronizing clocks
• Commands for Enterprise Replication
  • abbreviations
  • cdr alter
  • cdr change replicate (1), (2), (3)
  • cdr change replicateset (1), (2)
  • cdr check replicate
  • cdr check replicateset
  • cdr cleanstart
  • cdr connect server (1), (2)
  • cdr define repair
  • cdr define replicate (1), (2)
  • cdr define replicateset (1), (2)
  • cdr define replicateset.
    • See cdr define replicateset.
  • cdr define server (1), (2)
  • cdr define template
  • cdr delete repair
  • cdr delete replicate (1), (2)
  • cdr delete replicateset (1), (2), (3)
  • cdr delete server (1), (2)
  • cdr delete template
  • cdr disconnect server (1), (2)
  • cdr error
  • cdr finderr (1), (2)
  • cdr list repair
  • cdr list replicate (1), (2)
  • cdr list replicateset (1), (2)
  • cdr list server (1), (2), (3)
  • cdr list template
  • cdr modify replicate (1), (2)
  • cdr modify replicateset (1), (2)
  • cdr modify server (1), (2)
  • cdr realize template
  • cdr remaster
  • cdr remove
  • cdr repair
  • cdr resume replicate (1), (2)
  • cdr resume replicateset (1), (2)
  • cdr resume server (1), (2)
  • cdr start (1), (2)
  • cdr start repair
  • cdr start replicate (1), (2)
  • cdr start replicateset (1), (2)
  • cdr stats recv
  • cdr stats rqm
  • cdr stop (1), (2)
  • cdr stop repair
  • cdr stop replicate (1), (2)
  • cdr stop replicateset (1), (2)
  • cdr suspend replicate (1), (2)
  • cdr suspend replicateset (1), (2)
  • cdr suspend server (1), (2)
  • cdr swap shadow
  • cdr sync replicate
  • cdr sync replicateset
  • error return codes
  • oninit
  • onmode
  • onstat utility
  • starts
  • summary
• Communications support module
  • not allowed with ER
• Compliance
  • with industry standards
• Configuration
  • problems, solving (1), (2)
• Configuration parameters
  • See also Parameters, configuration.
  • CDR_SERIAL (1), (2)
  • DBSERVERALIASES (1), (2)
  • DBSERVERNAME (1), (2)
• Configuring
  • ATS and RIS files
  • logical logs files, for Enterprise Replication
  • trusted environment
• CONFLICT field
  • cdr list replicate output
• Conflict resolution
  • and table hierarchies
  • BYTE data
  • cdrserver
  • cdrtime
  • considerations for SPL routine
  • CRCOLS, adding and dropping
  • defined
  • delete tables (1), (2)
  • preparing tables for
  • rules
    • always apply
    • always-apply
    • behavior
    • changing
    • ignore (1), (2)
    • replicating only changed columns
    • shadow columns
    • specifying
    • SPL routines (1), (2)
    • time synchronization
    • timestamp (1), (2)
    • valid combinations
  • scope
    • changing
    • options
    • row (1), (2)
    • specifying
    • transaction (1), (2)
  • shadow columns
  • simple large objects
  • specifying options
  • SPL (1), (2)
  • support for UDRs
  • TEXT data
  • timestamp (1), (2)
  • transactional integrity
  • triggers
  • update-anywhere
• Conflicts, and asynchronous propagation
• Connecting to a database server
• CONNECTION CHANGED column, cdr list server output
• Connection security option
• Connection status, replication servers (1), (2)
• Connections
  • testing network
• Considerations
  • distributed transactions
  • large transactions
  • memory use
  • planning to use Enterprise Replication
  • primary-target replication systems
  • replicating
    • changed columns only
    • extensible data types
  • replication
    • environment
    • volume
  • SPL routines for conflict resolution
  • transaction processing
• Consistency
  • ensuring
• Consistency checking
• Consistency report
• Consolidation replication.
  • See Many-to-one replication.
• Constraints (1), (2), (3), (4), (5), (6)
• Contact information
• Conventions
  • ATS files
  • command-line
  • command-line utility
  • database server groups
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• CRCOLS.
  • See Shadow columns.
• CREATE TABLE statement
• Creating
  • databases with unbuffered logging
  • demonstration databases
  • replicate sets
  • row data sbspace (1), (2)
• Creating templates (1), (2)
• Cross-replication, between simple large objects and smart large objects
• Customizing
  • replicate sets
  • replicates
  • replication server definition

• Data
  • applying
  • capture types
  • distributing
  • inconsistent
  • integrity
  • loading
  • maintaining consistency
  • preparing (1), (2)
  • repair
  • synchronization
  • unloading
• Data-consolidation model, defined
• Data delivery
  • suspending
    • for replicate sets
    • for replicates
    • for replication servers
• Data dissemination model, defined
• Data propagation, considerations for asynchronous
• Data replication
  • asynchronous, defined
  • capture mechanisms
    • log-based data capture
    • trigger-based data capture
    • trigger-based transaction capture
  • defined
  • synchronous, defined
• Data types
  • built-in
  • extensible
  • FLOAT
  • floating-point
  • SERIAL
  • SERIAL and SERIAL8
  • SERIAL8
  • SMALLFLOAT
  • support for
  • supported
  • user-defined
  • user-defined.
    • See User-defined data types.
• Database server groups
  • conventions
  • HDR, defining for
  • registry key
  • SQLHOSTS file (1), (2)
  • UNIX
  • usage (1), (2)
  • Windows
• Database servers
  • aliases (1), (2)
  • connecting to
  • declaring for Enterprise Replication
  • disconnecting from
  • initializing
  • listing
  • preparing environment
  • preparing for HDR
  • removing from Enterprise Replication
  • specifying type
• Databases
  • considerations
    • backing up
    • restoring
  • creating
    • demonstration
    • with unbuffered logging
  • designing, considerations
  • locking
  • logging
  • triggers, changing
  • unbuffered logging
• DataBlade modules
  • preparing for HDR
• Datasync row-specific errors
• DB-Access
  • dbaccess command (1), (2)
    • testing network environment
  • utility
    • BEGIN WORK WITHOUT REPLICATION
    • included databases
• dbexport utility
• dbimport utility
• DBSERVERALIASES configuration parameter (1), (2), (3)
• dbservername, defined
• DBSERVERNAME configuration parameter (1), (2), (3)
• dbspaces
  • delete table storage
  • increasing size
  • monitoring disk usage
  • pathname limitations
  • root
  • size of transaction record
  • spooled transaction records
  • transaction record
• DDRBLOCK mode, preventing (1), (2)
• Deadlock situation, defined
• Decision support systems
  • data consolidation business model
• Declaring database server for Enterprise Replication
• Defaults
  • behavior of Enterprise Replication
  • dbspace for transaction records
  • locale
  • spooling directories
• Defining
  • participants
  • replicates (1), (2)
  • replication servers (1), (2)
  • shadow columns (1), (2), (3)
• Definition Failed state
• Delete tables
  • capacity planning
  • defined (1), (2)
  • disk space
  • in conflict resolution (1), (2)
  • storage
  • timestamp conflict resolution rule
• Deleted state, server
• Deletes, cascading.
  • See Cascading deletes.
• Deleting
  • Enterprise Replication objects
  • replicates from global catalog
  • replication servers
  • templates (1), (2), (3)
• Deluxe mode
  • without replication
• Demonstration databases (1), (2)
• Dependencies, software
• Deployment (1), (2)
• Designing databases and tables
• Determining size
  • logical log files
  • spooled row data sbspace
  • transaction record dbspace
• Dictionary information
• direct
• Direct synchronization
• Directories
  • INFORMIXDIR/bin
  • INFORMIXDIR/gls/cv9
  • specifying
    • ATS location
  • spooling, planning for capacity
• Disabilities, visual
  • reading syntax diagrams
• Disconnect status, replication servers
• Discrepancies, between constraints (1), (2)
• Disk
  • preparing for Enterprise Replication
• Disk space
  • delete table
  • message queue spooling
  • planning
  • shadow columns
• Disk usage, monitoring
• Distributed transactions
  • defined
  • two-phase commit
• Distributing
  • BYTE and TEXT data
  • data, process for
• Distribution replication.
  • See One-to-many replication.
• DNS.
  • See Domain Name Service.
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Domain Name Service
• Dotted decimal format of syntax diagrams
• DRINTERVAL configuration parameter
• DROP CRCOLS statement
• DROP TABLE statement (1), (2)
• Dropped status, replication servers
• Dropping
  • rowids
  • shadow columns
• DSS.
  • See Decision support systems.
• Dynamic log
  • setting CDR_MAX_DYNAMIC_LOGS

• Easy set up (1), (2)
• Empty master replicate
• en_us.8859-1 locale
• Enabling triggers
• ENCRYPT_CDR configuration parameter (1), (2), (3)
• ENCRYPT_CIPHERS configuration parameter (1), (2)
• ENCRYPT_MAC configuration parameter (1), (2)
• ENCRYPT_MACFILE configuration parameter (1), (2)
• ENCRYPT_SWITCH configuration parameter (1), (2)
• Encryption
  • cipher renegotiation
  • combining with client/server in SQLHOSTS
  • configuration parameters for
  • enabling with ENCRYPT_CDR
  • HDR, not supported with
  • MAC files, specifying
  • message authentication code generation
  • overview
  • specifying ciphers and modes
• English locale
• Enterprise Replication
  • administering
  • administration overview
  • alter operations
  • and cascading deletes
  • and triggers
  • batch jobs
  • consistency
  • data types
  • database server groups for HDR
  • default behavior
  • defined
  • deleting and recreating objects
  • displaying statistics (1), (2)
  • encryption, configuring
  • event alarms
  • flexible architecture
  • high availability (1), (2)
  • managing
  • performance
  • process for replicating data
  • queues
  • role of logical log files
  • selecting replication systems
  • server
    • administrator
    • defined
    • definitions in global catalog
  • starting
  • stopping
  • supported database servers
  • synonyms
  • terminology
  • threads
    • list of
    • restarting
    • stopping
  • using Global Language Support
  • views
• Environment
  • database server, preparing
  • network
    • preparing
    • testing (1), (2)
  • trusted, configuring
• Environment variables
  • CDR_LOGDELTA
  • CDR_PERFLOG
  • CDR_RMSCALEFACT
  • CDR_ROUTER
  • CDRSITES_731
  • CDRSITES_92X
  • INFORMIXDIR
  • INFORMIXSERVER (1), (2), (3), (4)
  • INFORMIXSQLHOSTS (1), (2)
  • setting
  • TZ
• Error messages
• Errors
  • datasync row-specific
  • interpreting error numbers
  • logging
    • changing
    • setting up
  • message files
    • cdrerr.h
  • replication server status
  • return codes
  • table
    • managing
• ESQL/C, BEGIN WORK WITHOUT REPLICATION
• Evaluating
  • data
    • for replication (1), (2)
  • data, examples of
  • rows (1), (2)
• Event alarm
• Examples
  • adding replicates to replicate sets
  • ATS filenames
  • BEGIN WORK WITHOUT REPLICATION (1), (2)
  • BYTE and TEXT data
    • in ATS files (1), (2)
    • in RIS files (1), (2)
  • cdr delete replicateset
  • collision
  • DB-Access
  • defining replicate sets
  • deleting
    • replicates
    • replicates from replicate sets
    • replication servers
  • evaluating data
  • hierarchy
  • hosts.equiv
  • non-exclusive replicate sets
  • participant definition
  • preparing data for replication
  • primary-target
  • replication (1), (2)
  • replication environment
  • resuming
    • replicates
    • replication servers
  • RIS filenames
  • services file
  • set
  • SQLHOSTS file
  • stopping
    • replicates
  • suspending
    • replicates
    • replication
  • unloading shadow columns
  • update-anywhere
  • updating shadow columns
  • using ESQL/C
• Exclusive lock
• Exclusive replicate sets
  • --exclusive option (1), (2), (3)
  • adding replicates to
  • characteristics of
  • defined
  • referential constraints
  • resuming replicates
  • starting replicates
  • stopping replicates
  • suspending replicates
• Extended data types
  • support for

• Fail-safe replication system
• Failed rows, repair jobs (1), (2)
• Failed transactions
  • and RIS files (1), (2)
  • recorded in ATS files (1), (2)
• Failure of replication
• Features
  • new (1), (2)
• Files
  • /etc/hosts
  • \etc\hosts
  • /etc/hosts.equiv
  • \etc\hosts.equiv
  • /etc/services
  • \etc\services
  • .rhosts
  • cdrerr.h (1), (2)
  • hosts
  • hosts.equiv
  • logical-log
  • ONCONFIG (1), (2)
  • services (1), (2)
  • SQLHOSTS (1), (2), (3)
• Fixed and Known Defects File
• FLOAT data type
• Floating-point
  • data types
  • numbers
    • canonical format (1), (2)
    • IEEE format
  • values, and canonical message format
• Forbidden SQL statements
• Forest of trees
  • combining with HDR
  • defined
  • illustrated
  • network topology
• Fragments
  • attaching
• Frequency
  • attributes
    • description of
  • defined
  • replication, specifying
• FREQUENCY field, cdr list replicate output
• Full row replication, changing
• Fully connected topology
  • defined
  • support for
  • using HDR with
• Functions, writing for UDT replication

• Global catalog
  • contents of
  • defined
  • leaf servers (1), (2)
  • root and nonroot servers
  • synchronizing
• Global Language Support (GLS)
  • defined
  • locale of date
  • support of
  • using with Enterprise Replication
• GLS.
  • See Global Language Support.
• Grouper
• Grouper paging file, setting up
• Groups.
  • See Database server groups.
• Guidelines for configuring logical log files

• Hardware platforms
  • dissimilar
  • heterogeneous
• HDR.
  • See High-Availability Data Replication.
• Help
• Heterogeneous hardware, replicating on
• Hierarchical routing topologies
  • combing with HDR
  • SQLHOSTS
  • supported types
  • synchronization server (1), (2)
  • terminology
• Hierarchical tree
  • defined
  • network topology
  • using HDR with
• Hierarchies
  • replicating table hierarchies
  • replication examples
• High availability
  • planning
    • primary-target
  • using Enterprise Replication for
• High-Availability Data Replication
  • database server groups
  • database server groups, defining
  • DRINTERVAL setting
  • encryption not supported
  • forest of trees topology
  • hierarchical routing topologies
  • loading data
  • logging sbspaces for spooled row data
  • managing (1), (2)
  • oninit -D command
  • onmode -d standard command
  • performance
  • preparing servers
  • primary server failure
  • primary-target replication systems
  • replication system
  • secondary server, switching to
  • spooled row data sbspace logging
  • starting primary without ER or HDR
  • UDRs, preparing for
  • UDTs, preparing for
  • update-anywhere replication
  • with fully connected topology
  • with hierarchical tree topology
• High-availability replication system
• High-Performance Loader
• HKEY_LOCAL_MACHINE
• hostname, in sqlhosts
• hosts.equiv file
• Hosts file, preparing
• HPL.
  • See High-Performance Loader.

• IBM Informix Server Administrator (1), (2)
  • setting up SQLHOSTS registry (1), (2)
• ID column, cdr list server output
• Identifier
• Idle timeout
  • modifying
  • setting
  • specifying
• IEEE floating point format (1), (2)
• Ignore conflict-resolution rule (1), (2), (3), (4)
  • database action
• Immediate frequency
• In-place alters
  • ADD and DROP CRCOLS
• Inactive state
  • defined
• Inconsistent data with blobspaces or sbspaces
• Increasing storage space size
• Industry standards, compliance with
• Information consistency, update-anywhere
• Informix-Admin group, Windows
• Informix Dynamic Server documentation set
• informix user
• INFORMIXDIR environment variable
• INFORMIXSERVER environment variable (1), (2), (3), (4)
• INFORMIXSQLHOSTS environment variable (1), (2)
• Initial synchronization (1), (2), (3), (4)
• Initializing
  • database server
• Installation Guides
• Installing
  • UDTs
• Instantiating templates (1), (2), (3)
• Integrity, data
• Interval formats
• Invalid sbspace
• IP address
  • specifying in hosts file
• ISO 8859-1 code set

• Keys
  • primary
    • and constraints
    • and SERIAL data types
    • and UDT columns
    • removing constraints
• Keywords
  • in syntax diagrams

• Large objects
  • replicating only changed columns
• Large transactions
  • grouper paging file
• Large transactions, considerations for Enterprise Replication
• Leaf servers
  • defined
  • global catalog (1), (2)
  • limited catalog
  • specifying
  • SQLHOSTS information
• Limitations, SPL conflict resolution
• Limited SQL statements
• LOAD statement (1), (2), (3)
• Loading data
  • ER servers
  • HDR servers
• Local status, replication servers
• Locales
  • different
  • Enterprise Replication
  • specifying nondefault
• Lock
  • monitoring with onstat -k
  • type codes
• Locking databases
• Locks, exclusive.
  • See Exclusive lock.
• Log-based data capture
• Logging
  • aborted transactions
  • databases, preparing
  • errors
  • unbuffered (1), (2)
• LOGGING configuration parameter
• Logging mode, for spooled row data sbspaces
• Logical log
  • files (1), (2)
    • and maximum transaction size
    • bitmap information about updated columns
    • capacity planning
    • configuration guidelines
    • determining size
    • disk space, error
    • disk space, requirements
    • dynamically adding
    • increasing size
    • overwriting
    • reading of
    • role in Enterprise Replication
    • size
    • switching
• Logical Log Record reduction option, and Enterprise Replication
• Long identifiers
• LRD label, RIS files
• LRH label, RIS files
• LRS label, RIS files
• LTXEHWM configuration parameter (1), (2)
• LTXHWM configuration parameter (1), (2)

• Machine-independent format (1), (2)
• Machine notes
• Maintaining consistency
• Managing
  • Enterprise Replication, overview
  • replicate sets
  • replicates (1), (2)
  • replication servers
• Manual remastering (1), (2)
• Manual repair
• Many-to-one replication
• Master replicates (1), (2)
  • defined
  • strict
• Maximum transaction size, and logical log files
• Memory queues
  • preventing overflows
• Memory use considerations
• Message authentication code files (1), (2)
• Message formats
  • canonical
  • IEEE
• Message queues
  • CDR_QUEUEMEM configuration parameter
  • defined
  • planning disk space
• mode option, cdr modify server
• Modes
  • encryption
• Modifying
  • primary-key constraint
  • replicate sets
  • templates
• Monitoring
  • dbspaces, onstat command
  • disk usage
  • sbspaces
    • oncheck command
    • onstat command
• Multiple references to a smart large object
• Multiple updates to the same row

• net time command, synchronizing clocks
• nettype
  • defined
• Network connections
  • dropping
  • encryption, setting up for
  • managing (1), (2)
  • reestablishing
  • troubleshooting
  • viewing status
• Network environment
  • preparing
  • testing
• Network topologies
  • choosing
  • forest of trees
  • fully connected
  • hierarchical tree
  • supported types
• New features (1), (2)
• New table, bringing up-to-date
• Non-exclusive replicate sets
  • adding replicates
  • characteristics
  • defined
  • example
• Nonoptimized SPL routine
• Nonroot servers
  • defined
  • global catalog (1), (2)
  • specifying type
  • SQLHOSTS information

• OLTP
  • data dissemination business model
• oncheck command, monitoring sbspaces
• ONCONFIG configuration file
  • configuration parameters (1), (2)
  • configuring encryption
  • setting
    • DBSERVERALIASES
    • DBSERVERNAME
    • parameters (1), (2)
• ONCONFIG configuration parameter
  • See Parameters, configuration.
• One-to-many replication
• oninit -D command
• oninit command
  • initializing database servers
• Online help
• Online manuals
• Online notes (1), (2)
• Online transaction processing.
  • See OLTP.
• onload utility
• onmode -d standard command
• onmode command
• onspaces command
  • adding chunks
  • creating
    • row data sbspace
    • transaction record dbspace
• onstat command (1), (2)
  • Enterprise Replication options
• onstat utility
  • -g ath command
  • -g cat command
  • -g ddr command
  • -g dss command
  • -g dtc command
  • -g grp command
  • -g nif command
  • -g que command
  • -g rcv command
  • -g rep command
  • -g rqm command
  • -g sync command
  • -k option
  • monitoring
    • dbspaces
    • sbspaces
• onunload utility (1), (2)
• Operating system
  • synchronizing time (1), (2)
• Optical devices, not supported
• Optimized SPL routine, defined
• Options
  • --add (1), (2)
  • --ats
  • --delete
  • --ris
  • SQLHOSTS
    • defined
• Options for Enterprise Replication
  • --ackq
  • --add (1), (2)
  • --all (1), (2)
  • --applyasowner (1), (2)
  • --at (1), (2)
  • --ats (1), (2), (3), (4), (5), (6)
  • --autocreate (1), (2), (3), (4)
  • --blocksize
  • --cntrlq (1), (2)
  • --conflict (1), (2)
  • --connect (1), (2), (3)
  • --database
  • --dbspace (1), (2)
  • --delete (1), (2)
  • --empty (1), (2)
  • --every (1), (2)
  • --exclusive (1), (2), (3)
  • --extratargetrows (1), (2), (3), (4), (5), (6), (7), (8), (9)
  • --file (1), (2)
  • --filter
  • --firetrigger (1), (2), (3)
  • --floatcanon (1), (2)
  • --floatieee
  • --follow
  • --fullrow (1), (2), (3)
  • --idle (1), (2), (3)
  • --ignoredel
  • --immed (1), (2)
  • --init (1), (2)
  • --leaf (1), (2)
  • --master (1), (2), (3), (4)
  • --mirrors (1), (2)
  • --mode
  • --name (1), (2), (3)
  • -–repair (1), (2)
  • -–repl
  • -–replset
  • -–verbose (1), (2)
  • --nomark
  • --nonroot (1), (2)
  • --off
  • --on
  • --optimize (1), (2)
  • --primaryid (1), (2)
  • --primaryname (1), (2)
  • --prune
  • --recvq
  • --replicate
  • --replset
  • --ris (1), (2), (3), (4), (5)
  • --scope (1), (2)
  • --sendq
  • --seq
  • --shadowid (1), (2)
  • --shadowname (1), (2)
  • --sync (1), (2)
  • --syncdatasource (1), (2), (3), (4), (5), (6), (7)
  • --target (1), (2)
  • --verify (1), (2), (3), (4)
  • --zap
  • —all (1), (2), (3), (4)
  • —master (1), (2), (3), (4)
  • —repl (1), (2)
  • abbreviations
  • conflict resolution
  • frequency
  • order
  • participant owner
  • primary
  • receive-only
  • scope
• Out-of-row data, sharing during replication
• Overflowing memory queues, preventing
• Overwriting logical log files
• Owner, table

• Parameters, configuration
  • AVG_LO_SIZE
  • CDR_DBSPACE (1), (2)
  • CDR_DSLOCKWAIT
  • CDR_ENV
  • CDR_EVALTHREADS (1), (2)
  • CDR_MAX_DYNAMIC_LOGS
  • CDR_NIFCOMPRESS (1), (2)
  • CDR_QDATA_SBSPACE (1), (2), (3), (4)
  • CDR_QHDR_DBSPACE (1), (2), (3)
  • CDR_QUEUEMEM (1), (2), (3)
  • CDR_SBSPACE
  • CDR_SUPPRESS_ATSRISWARN
  • configuration (1), (2)
  • ENCRYPT_CDR
  • ENCRYPT_CIPHERS
  • ENCRYPT_MAC
  • ENCRYPT_MACFILE
  • ENCRYPT_SWITCH
  • LOGGING
  • LTXEHWM (1), (2)
  • LTXHWM (1), (2)
  • Parameters, configuration
    • CDR_SUPPRESS_ATSRISWARN
  • setting in ONCONFIG file (1), (2)
• Parent-child
  • defined
• Parent database server
• Participant definition
  • contents
  • example
• Participant modifiers
  • defined
  • restrictions (1), (2), (3)
• Participant type
  • changing
  • default
  • Primary
  • Target
• Participants
  • adding to replicates (1), (2), (3)
  • changing mode
  • defined (1), (2), (3)
  • defining (1), (2)
  • deleting from replicates
  • modifier
  • new (1), (2)
  • owner option
  • primary option
  • receive-only option
  • removing from replicates
  • specifying type
  • update-anywhere
• Pathname
  • ATS and RIS directories
  • dbspaces
  • sbspaces
• Pending state, defined
• Performance
  • Enterprise Replication
• Permitted SQL statements
• ping command, testing network connection
• Planning
  • considerations
  • disk space requirements
• Port numbers
  • services file
• Preparing
  • consistent data
  • data for replication
    • defined
    • example
  • database server environment
  • disk
    • Enterprise Replication
  • hosts file
  • logging databases
  • network environment
  • services file
  • SQLHOSTS connectivity information
  • tables for conflict resolution
  • UDR replication
  • UDT replication
  • using ATS
  • using RIS
• Preventing
  • DDRBLOCK mode
  • memory queues from overflowing
• Primary
  • option
  • participant type
• Primary conflict-resolution rule (1), (2)
• Primary key
  • constraints (1), (2)
  • modifying column
  • removing constraint
  • replicating changed columns
  • SERIAL data types
  • UDT columns
  • updates
• Primary-target
  • example
  • replication systems
    • business models
    • combining with HDR
    • considerations
    • defined
• Printed manuals
• Problems
  • solving configuration (1), (2)
• Procedure conflict-resolution rule
• Properties
  • replicate sets

• QUEUE column
  • cdr list server output
• Queues.
  • See Memory queues.
• Quiescent state (1), (2)

• RAW table
  • unsupported
• rdate command, synchronizing clocks
• Realizing templates (1), (2)
• Receive-only
  • option
  • participant type.
    • See Target participant type.
• Receive-only servers
• Receive queues
  • See also Memory queues.
  • defined (1), (2), (3)
• Recording failed transactions, in ATS files
• Recreating
  • Enterprise Replication objects
  • replicates
  • replication servers
• Referential constraint
  • time-based replication
• Referential integrity (1), (2), (3)
  • replicate sets
• regedt32 program and sqlhosts registry
• Registering
  • UDTs
• Release Notes
• Reliable Queue Manager
• Remastering, manual
• Remastering replicates
• Removing
  • primary key constraint
• RENAME COLUMN statement
• RENAME TABLE statement (1), (2)
• Repair jobs (1), (2), (3), (4), (5), (6)
• Repairing data
  • and log files
  • ATS, RIS files
  • manually
  • partial row
  • using consistency checking
• Replicate definitions
• Replicate information
  • storage
• Replicate sets
  • adding and deleting replicates
  • changing replication frequency
  • changing state
  • creating
  • customizing
  • defined
  • defining
  • deleting (1), (2)
  • examples
  • exclusive
  • frequency
  • listing
  • managing (1), (2)
  • modifying (1), (2), (3)
  • non-exclusive
  • recreating
  • referential constraints
  • resuming (1), (2)
  • starting (1), (2)
  • stopping (1), (2)
  • supported versions
  • suspending (1), (2)
  • viewing properties
• Replicates
  • activating
    • ATS
    • RIS
  • active state
  • adding
    • participants
    • replicate sets
  • adding to replicate sets
  • CONFLICT field
  • conflict options
  • customizing
  • defined (1), (2)
  • defining (1), (2), (3)
  • deleting
    • global catalog
    • participants
    • replicate sets
  • deleting from replicate sets
  • deleting from the global catalog
  • displaying information about
  • FREQUENCY field
  • inactive state
  • listing
  • managing (1), (2)
  • modifying (1), (2)
  • recreating
  • resuming (1), (2)
    • exclusive replicate sets
  • starting (1), (2)
    • exclusive replicate sets
  • STATE field
  • stopping (1), (2)
    • exclusive replicate sets
  • suspending (1), (2)
    • exclusive replicate sets
  • viewing properties
• Replicating
  • changed columns only (1), (2)
  • extensible data types
    • considerations
  • floating-point values
  • large objects
  • multiple references to a smart large object
  • simple large objects (1), (2)
  • smart large objects (1), (2)
  • table hierarchies
  • UDTs
• Replicating data
  • capturing transactions
  • evaluating
    • data
    • row images
  • process
• Replicating only changed columns, advantages
• Replication
  • blocking
  • choosing network topology
  • environment
    • considerations
    • managing
  • examples (1), (2)
  • frequency
    • changing (1), (2)
    • replicate sets
    • specifying
  • models
    • primary-target
    • update-anywhere
  • order error, defined
  • restarting
  • stopping
  • suspending
  • tree, illustrated
  • volume (1), (2)
• Replication failure
• Replication servers
  • connecting
  • customizing
  • defined (1), (2)
  • defining (1), (2), (3)
  • deleting (1), (2)
  • listing
  • managing (1), (2)
  • modifying (1), (2), (3)
  • recreating
  • resuming
  • resynchronizing
  • state, defined
  • suspending
  • synchronizing
  • troubleshooting
  • viewing attributes
• Replication systems
  • high-availability
  • primary-target (1), (2)
  • supported by Enterprise Replication
  • update-anywhere (1), (2)
• Replication topologies
  • forest of trees
  • fully-connected
  • hierarchical
  • hierarchical tree
  • terminology
• Requirements
  • disk space
    • delete tables
    • logical log files
    • message queue spooling
    • planning
    • shadow columns
• Restores
  • cold
  • warm
• Restoring databases, considerations
• Restrictions
  • participant modifiers
• Resuming
  • replicate sets
  • suspended
    • replicates
    • replication servers
• Resynchronizing replication servers
• Return codes
  • defined
• RIS files
  • activating (1), (2)
  • BLOB and CLOB information
  • BYTE and TEXT data
  • capacity planning
  • changed column information
  • configuring
  • defined
  • filenames, defined
  • modifying directory
  • preparing to use
  • repair using
  • specifying directory (1), (2), (3)
  • UDT information
• root dbspace
  • transaction records
• Root servers
  • defined
  • global catalog (1), (2)
  • SQLHOSTS information
• Routines
  • application-specific
• Row conflict resolution scope (1), (2), (3), (4)
• Row data
  • creating sbspace
  • storage
• Row Information Spooling.
  • See RIS., RIS.
• ROWID
  • locking information
• ROWIDS
  • adding and dropping
• Rows
  • replicating entire
• RQM.
  • See Reliable Queue Manager.
• RRD label, ATS files
• RRH label, ATS files
• RRS label, ATS files
• Rules
  • See also Conflict resolution.
  • conflict resolution
    • extensible data types
    • simple large objects
    • smart large objects
  • time-stamp

• Sample-code conventions
• sbspaces
  • grouper paging file
  • guidelines for spooled data
  • inconsistent replicated data
  • increasing sizes
  • invalid
  • monitoring disk usage
  • pathname limitations
  • row data (1), (2)
  • spooled row data (1), (2)
• SBSPACETEMP configuration parameter
• Scope
  • See also Conflict resolution.
  • --scope option (1), (2)
  • defined
  • options
  • row (1), (2)
  • transaction
• Screen reader
  • reading syntax diagrams
• Secondary conflict-resolution rule
• Security.
  • See Encryption.
• Security, connections
• SELECT statements
  • limitations
  • participant modifier
  • shadow columns
• Send queues
  • See also Memory queues.
  • defined (1), (2)
• Sequence objects
• SERIAL data type (1), (2)
• SERIAL8 data type (1), (2)
• Server.
  • See Database server.
• Server administrator, Enterprise Replication
• SERVER column, cdr list server output
• Server connections, stopping
• Server definitions, global catalog
• Server groups.
  • See Database server groups.
• Server state, global catalog
• servicename, defined
• services file
  • example
  • preparing
• set
  • examples
• Setting
  • AVG_LO_SIZE configuration parameter
  • CDR_QDATA_SBSPACE configuration parameter
  • environment variables
  • idle timeout
  • LOGGING parameter
• Setting up
  • easy (1), (2)
  • error logging
  • SQLHOSTS file
  • SQLHOSTS registry
  • SQLHOSTS registry key
• Shadow columns
  • ADD CRCOLS
  • adding
  • ATS files
  • behavior with BEGIN WORK WITHOUT REPLICATION (1), (2)
  • cdrserver (1), (2)
  • cdrtime (1), (2)
  • conflict resolution rules
  • creating (1), (2), (3)
  • defined
  • disk space requirements (1), (2)
  • dropping (1), (2)
  • High-Performance Loader
  • loading and unloading data
  • UNLOAD statement
  • updating with DB-Access
  • WITH CRCOLS statement
• Shadow replicates (1), (2), (3), (4)
  • defined
• Simple large objects
  • conflict resolution
  • cross-replication
  • replicating (1), (2)
    • from blobspaces
    • from tblspaces
  • SPL conflict resolution (1), (2), (3)
  • storing
    • blobspaces
    • tblspaces
  • timestamp conflict resolution
• Size
  • storage spaces
  • transaction record dbspace
• SMALLFLOAT data type
• Smart blobs.
  • See Smart large object.
• Smart large objects
  • ATS files
  • cross replication
  • multiple references
  • replicating (1), (2)
  • replicating only changed columns
  • specifying default behavior
  • SPL conflict resolution
  • spooled row data
  • storing in sbspaces
• SMI tables
  • summary
  • syscdr_rqm
  • syscdrack_buf
  • syscdrack_txn
  • syscdrctrl_buf
  • syscdrctrl_txn
  • syscdrerror (1), (2), (3)
  • syscdrpart
  • syscdrprog
  • syscdrq
  • syscdrqueued
  • syscdrrecv_buf
  • syscdrrecv_stats
  • syscdrrecv_txn
  • syscdrrepl
  • syscdrreplset
  • syscdrs
  • syscdrsend_buf
  • syscdrsend_txn
  • syscdrserver
  • syscdrtx
• Software dependencies
• Solving configuration problems (1), (2)
• Source server, synchronization
• Specifying
  • ATS directory
  • conflict resolution
    • rules
    • scope
  • database server type
  • default behavior for smart large objects
  • location
    • ATS directory
  • replication frequency
  • RIS directory
• SPL conflict resolution
  • limitations
  • rule (1), (2), (3)
  • simple large object (1), (2), (3)
  • smart large object
• SPL routines
  • arguments
  • considerations
  • delete table
  • information passed by Enterprise Replication
  • limitations for conflict resolution
  • nonoptimized
  • optimized
• Spooled row data sbspace
  • changing logging mode
  • dropping
  • guidelines for creating
  • logging and HDR
  • logging mode
• Spooled transactions
  • defined
  • storage
  • troubleshooting
• Spooling
  • directories
    • ATS and RIS
    • capacity planning
    • default
  • more than usual, causes of
  • planning for disk space
• SQL code
• SQL statements
  • forbidden
  • limited
  • permitted
  • supported
• SQLHOSTS
  • hierarchical routine topologies
  • INFORMIXSQLHOSTS environment variable
  • leaf servers
  • nonroot servers
  • on UNIX
  • on Windows
  • preparing connectivity information
  • registry key (1), (2), (3)
    • local
    • setting up
    • shared
  • root servers
  • setting up with ISA (1), (2)
  • specifying registry host machine
• SQLHOSTS file
  • database server groups for HDR
  • encryption, setting up
  • example
  • format
  • server group
  • setting up
  • specifying location
  • UNIX
• Starting
  • replicates
• starts command
• STATE column, cdr list server output
• STATE field, cdr list replicate output
• Statements
  • ALTER TABLE
  • BEGIN WORK WITHOUT REPLICATION
  • CREATE TABLE
  • DROP CRCOLS
  • LOAD (1), (2)
  • SELECT
  • SQL, supported
  • UNLOAD (1), (2)
  • WITH CRCOLS
• States
  • active
  • inactive
• STATUS column, cdr list server output
• Stopping
  • replicates
• Storage
  • delete tables
  • increasing size of spaces
  • spooled transactions
• Stored Procedure Language.
  • See SPL routine.
• stores_demo database
• Storing
  • data in tblspaces
• streamread support function (1), (2), (3)
• streamwrite support function (1), (2), (3)
• Strict master replicates
• Summary
  • SMI tables
• superstores_demo database
• Support functions
  • replicating UDTs (1), (2)
  • streamread (1), (2)
  • streamwrite (1), (2)
  • writing (1), (2)
• Supported
  • data types
  • database servers
  • SQL statements
  • table types
• Suspended state (1), (2)
• Suspending
  • replicate sets
  • replicates
  • replication
• Swap log position
• Switching logical log files
• Synchronization (1), (2), (3)
  • servers (1), (2)
  • times
• Synchronizing
  • clocks
    • net time command
    • rdate command
  • data
    • onload and onunload utilities
    • using DB-Access
    • using ESQL/C
  • global catalog
  • operating system times (1), (2)
• Synchronous data replication
  • defined
  • two-phase commit technology
• Synonyms, and Enterprise Replication
• Syntax
  • command-line utility
  • participant definition
• Syntax diagrams
  • conventions for
  • keywords in
  • reading in a screen reader
  • variables in
• Syntax segment
• syscdr database
• syscdr_rqm table
• syscdrack_buf table
• syscdrack_txn table
• syscdrctrl_buf table
• syscdrctrl_txn table
• syscdrerror table (1), (2), (3)
• syscdrlatency table
• syscdrpart table
• syscdrprog table
• syscdrq table
• syscdrqueued table
• syscdrrecv_buf table
• syscdrrecv_stats table
• syscdrrecv_txn table
• syscdrrepl table
• syscdrreplset table
• syscdrs table
• syscdrsend_buf table
• syscdrsend_txn table
• syscdrserver table
• syscdrtx table
• sysmaster database
  • SMI tables
• System Monitoring Interface.
  • See SMI table.
• System name
  • hosts file
• System requirements
  • database
  • software

• Table
  • buffer
  • designing, considerations
  • locking
  • preparing for conflict resolution
  • RAW
  • SMI (1), (2)
  • temporary
  • transaction
  • unsupported
• Table creation
  • automatic (1), (2)
  • templates (1), (2), (3)
• Table hierarchy
  • replicating
• Table types
  • unsupported
• Target participant type
• Tblspace
  • storing BYTE and TEXT data (1), (2)
• Templates (1), (2), (3)
  • defined
  • deleting
  • managing
  • modifying (1), (2)
  • realizing
  • verification option
  • viewing
• Temporary tables
• Terminology
  • command-line utility
  • Enterprise Replication
  • Enterprise Replication servers
  • global catalog
  • hierarchical topology
  • master replicate
  • participant
  • replicate
  • replicate set
  • replication servers
  • shadow replicate
  • templates
• Testing
  • network environment
  • trusted environment
• TEXT data
  • ATS files
  • distributing
  • RIS files
  • SPL conflict resolution
  • storing in tblspaces
  • types, loading
• Threads used by Enterprise Replication
• Time formats
• Time synchronization (1), (2), (3)
• Timeout
  • idle, setting
  • status, replication servers
• Timestamp conflict resolution rule (1), (2), (3), (4)
  • database action
  • defined
  • delete table
  • simple large object
• TOC Notes
• Tools for loading and unloading data
• Topology, choosing network
• Transaction conflict resolution scope (1), (2), (3)
• Transaction records
  • default dbspace
  • storage
• Transactional integrity
• Transactions
  • buffers, spooling to disk (1), (2)
  • constraint checking
  • distributed
  • evaluation examples (1), (2)
  • evaluation logic
  • failed, ATS and RIS files (1), (2)
  • large
  • processing (1), (2)
  • tables
• Tree
  • defined
  • topology, illustrated
• Triggers
  • activating with replication
  • changing
  • data capture
  • defined
  • enabling
  • errors with Enterprise Replication
  • firing
  • permissions
  • primary key updates
  • transaction capture
• Troubleshooting
  • configuration problems (1), (2)
  • spooled transactions
• Troubleshooting Enterprise Replication
  • alter operations
• TRUNCATE statement
• Trusted environment
  • configuring
  • testing
• Two-phase commit protocol
  • defined
  • distributed transactions
• TXH label, ATS files
• Typographical conventions
• TZ environment variable

• UDRs
  • HDR servers, preparing
  • installing
  • preparing to replicate
  • registering
  • SPL conflict resolution
• UDTs.
  • See User-defined data types
• Unbuffered logging (1), (2)
• UNIX
  • database server groups
  • onmode command
  • SQLHOSTS file (1), (2)
• UNLOAD statement (1), (2)
• unload utility
• Unloading data (1), (2)
• Unsupported table types
• Up-to-date, with replication
• Update-anywhere
  • examples
  • participants
  • replication system
    • combining with HDR
    • defined
• Update-anywhere replication systems
• Updates
  • multiple-row images
  • primary key
  • WHERE clause column
• Updating shadow columns
• UPSERTs
  • defined
  • replicating only changed columns
• User-defined data types
  • ATS files
  • columns, primary key
  • HDR servers, preparing
  • information in ATS files
  • information in RIS files
  • installing
  • installing and registering
  • loading with deluxe mode
  • preparing to replicate
  • registering
  • replicating
    • only changed columns
    • preparation
  • spooled row data
  • support
  • support functions
• Users, informix
• Utilities
  • dbexport
  • dbimport
  • onunload
  • unload

• Values, sending floating-point
• Variables.
  • See Environment variable.
• Variables, in syntax diagrams
• Verification, master replicate
• Viewing
  • Enterprise Replication
  • replicate attributes
  • replication server attributes
  • templates (1), (2), (3)
• Virtual column
  • support
• Visual disabilities
  • reading syntax diagrams

• Warm restores
• WHERE clause
  • column updates
• Windows
  • database server groups
  • Informix-Admin group
  • onmode command
  • SQLHOSTS registry host
• WITH CRCOLS statement
  • defining shadow columns
• Workflow replication business model
• Workload partitioning business model
• Writing
  • support functions
  • transaction buffers to disk