The cdr utility
You use the cdr utility to configure and control Enterprise Replication from the command line on your UNIX or Windows operating system.
You must be the Enterprise Replication server administrator to run any of the cdr commands except the cdr list commands, unless otherwise noted.
The cdr utility requires a certain amount of memory resources. If you encounter out-of-memory errors for cdr commands, your operating system limits on memory use might be set too low. For example, you can run the ulimit command in a UNIX environment to configure limits on memory resources. Increase the values for memory resources to avoid out-of-memory errors.
You can run cdr commands from within SQL statements by using the SQL administration API. Most cdr commands that perform actions are supported by the SQL administration API; cdr commands that show information are not supported.
- Interpret the cdr utility syntax
The cdr utility uses specific terminology and conventions. - cdr add onconfig
The cdr add onconfig command adds one or more values to a configuration parameter in the ONCONFIG file. - cdr alter
The cdr alter command puts the specified tables in alter mode. - cdr autoconfig serv
The cdr autoconfig serv command can autoconfigure connectivity for servers in a high-availability cluster or Enterprise Replication domain, and can automatically configure replication. - cdr change grid
The cdr change grid command adds or deletes replication servers to or from a grid. - cdr change gridtable
The cdr change gridtable command has multiple uses. It can verify that specific tables can be used in gird queries and then add the tables to a list of verified tables, and it can delete tables from the list of verified tables. - cdr change onconfig
The cdr change onconfig command replaces the existing value of a configuration parameter with a new value in the ONCONFIG file. - cdr change replicate
The cdr change replicate command modifies an existing replicate by adding or deleting one or more participants. - cdr change replicateset
The cdr change replicateset command changes a replicate set by adding or deleting replicates. - cdr change shardCollection
The cdr change shardCollection command changes the sharding definition that determines which database servers are part of the shard cluster. - cdr check queue
Use the cdr check queue command to check the consistency of Enterprise Replication metadata, and to check the consistency of user data before running critical tasks in the Enterprise Replication domain. The command returns successfully when all of the commands that were queued when cdr check queue was run are complete. - cdr check replicate
The cdr check replicate command compares the data on replication servers to create a report that lists data inconsistencies and can optionally repair the inconsistent data within a replicate. - cdr check replicateset
The cdr check replicateset command compares the data on replication servers to create a report listing data inconsistencies. Optionally you can use the command to repair the inconsistent data within a replicate. - cdr check sec2er
The cdr check sec2er command determines whether a high availability cluster can be converted to replication servers. - cdr cleanstart
The cdr cleanstart command starts an Enterprise Replication server with empty queues. - cdr connect server
The cdr connect server command reestablishes a connection to a database server that has been disconnected with a cdr disconnect server command. - cdr define grid
The cdr define grid command creates a named grid of replication servers to simply administration. - cdr define qod
The cdr define qod command defines a master server for monitoring the quality of data (QOD) for replication servers. - cdr define region
The cdr define region command creates a region that contains a subset of the servers in a grid. - cdr define replicate
The cdr define replicate command defines a replicate on the specified replication servers. - cdr define replicateset
The cdr define replicateset command defines a replicate set on all the servers that are included as participants in the replicates. A replicate set is a collection of several replicates to be managed together. - cdr define server
The cdr define server command defines a replication server in an Enterprise Replication domain. You can add a replication server to an existing domain or create a new domain. - cdr define shardCollection
The cdr define shardCollection command creates a sharding definition for distributing a table or collection across multiple shard servers. - cdr define template
The cdr define template command creates a template for replicates and a replicate set. - cdr delete grid
The cdr delete grid command deletes the specified grid. - cdr delete region
The cdr delete region command deletes a region from a grid. - cdr delete replicate
The cdr delete replicate command deletes a replicate. - cdr delete replicateset
The cdr delete replicateset command deletes an exclusive or non-exclusive replicate set from the global catalog. - cdr delete server
The cdr delete server disables a database server from participating in Enterprise Replication. - cdr delete shardCollection
The cdr delete shardCollection command deletes a sharding definition, and then stops data sharding. - cdr delete template
The cdr delete template command deletes a template from the replication domain. It also deletes any underlying replicate sets associated with the template (these will exist if the template has been realized). No replicates are deleted. - cdr disable grid
The cdr disable grid command removes the authorization to run grid routines from users or servers. - cdr disable server
The cdr disable server command disables replication on a server. - cdr disconnect server
The cdr disconnect server command stops a server connection. - cdr enable grid
The cdr enable grid command authorizes users to run commands on the grid and designates servers from which grid commands can be run. - cdr enable server
The cdr enable server command enables replication on a replication server that was disabled by the cdr disable server command. - cdr error
The cdr error command manages the syscdrerror table and provides convenient displays of errors. - cdr finderr
The cdr finderr command looks up a specific Enterprise Replication return code and displays the corresponding error text. - cdr list grid
The cdr list grid command shows information about a grid. - cdr list replicate
The cdr list replicate command displays information about the replicates on the current server. - cdr list replicateset
The cdr list replicateset command displays information about the replication sets defined on the current server. - cdr list server
The cdr list server command displays a list of the Enterprise Replication servers that are visible to the server on which the command is run. - cdr list shardCollection
The cdr list shardCollection command displays the sharding definition for all database servers in a shard cluster. - cdr list catalog
The cdr list catalog command lists the commands that created the specified replication objects. - cdr list template
The cdr list template command displays information about the templates on the server on which the command is run. - cdr migrate server
The cdr migrate server command automates data migration task between two or more servers. This command also automates setting up of Enterprise Replication between two Informix server instances. - cdr modify grid
The cdr modify grid command modifies grid attributes. - cdr modify replicate
The cdr modify replicate command modifies replicate attributes. - cdr modify replicateset
The cdr modify replicateset command modifies all the replicates in a replicate set. - cdr modify server
The cdr modify server command modifies the Enterprise Replication attributes of a database server. - cdr realize template
The cdr realize template command creates the replicates, replicate set, and participant tables as specified in a template, and then synchronizes data on all or a subset of the database servers within the replication domain. - cdr remaster
The cdr remaster command changes the SELECT clause or the server from which to base the master replicate definition of an existing master replicate. This command can also convert a classic (non-master) replicate to a master replicate. - cdr remaster gridtable
The cdr remaster gridtable command validates tables in a grid after an alter operation. - cdr remaster replicateset
The cdr remaster replicateset command updates the definitions of the set of replicates whose participants were changed by ALTER operations. - cdr remove onconfig
The cdr remove onconfig command removes the specified value from a configuration parameter in the ONCONFIG file. - cdr repair
The cdr repair command synchronizes data based on ATS or RIS files. - cdr reset qod
The cdr reset qod command resets failed-transaction counts for replicates on replicate servers. Connection Manager service-level agreements (SLA) that contains a FAILURE or LATENCY redirection policy use failed-transaction counts to determine where to route client requests. - cdr resume replicate
The cdr resume replicate command resumes delivery of replication data. - cdr resume replicateset
The cdr resume replicateset command resumes delivery of replication data for all the replicates in a replicate set. - cdr resume server
The cdr resume server command resumes delivery of replication data to a suspended database server. - cdr start
The cdr start command starts Enterprise Replication processing. - cdr start qod
The cdr start qod command starts quality of data (QOD) monitoring for replication servers. - cdr start replicate
The cdr start replicate command starts the capture and transmittal of replication transactions. - cdr start replicateset
The cdr start replicateset command starts the capture and transmittal of replication transactions for all the replicates in a replicate set. - cdr start sec2er
The cdr start sec2er command converts a high availability cluster to replication servers. - cdr stats rqm
The cdr stats rqm command displays information about the reliable queue manager (RQM) queues used for Enterprise Replication. - cdr stats recv
The cdr stats recv command displays receiver parallelism statistics and latency statistics by source node. - cdr stats check
The cdr stats check command displays the progress of a consistency check that specified a progress report task name. - cdr stats sync
The cdr stats sync command displays the progress of a synchronization operation that specified a progress report task name. - cdr stop
The cdr stop command stops replication on the server to which you are connected without shutting down the database server. - cdr stop qod
The cdr stop qod command stops quality of data (QOD) monitoring for replication servers. - cdr stop replicate
The cdr stop replicate command stops the capture, transmittal, and reception of transactions for replication. - cdr stop replicateset
The cdr stop replicateset command stops capture and transmittal transactions for all the replicates in a replicate set. - cdr suspend replicate
The cdr suspend replicate command suspends delivery of replication data. - cdr suspend replicateset
The cdr suspend replicateset command suspends delivery of replication data for all the replicates in a replicate set. - cdr suspend server
The cdr suspend server command suspends the delivery of replication data to a database server from either a specified list of database servers or from all database servers in the domain. - cdr swap shadow
The cdr swap shadow command switches a replicate with its shadow replicate during manual remastering. - cdr sync replicate
The cdr sync replicate command synchronizes data among replication servers to repair inconsistent data within a replicate. - cdr sync replicateset
ASDF The cdr sync replicateset command synchronizes data among replication servers to repair inconsistent data within a replicate set. - cdr -V
The cdr -V command displays the version of Informix® that is currently running. - cdr view
The cdr view command shows information about every Enterprise Replication server in the domain.
Parent topic: Appendixes
Related tasks:
Related information: