The syscdr_ddr Table
The syscdr_ddr table contains information about the status of log capture and the proximity or status of transaction blocking (DDRBLOCK) or transaction spooling.
| Column | Type | Description |
|---|---|---|
| ddr_state | char(24) | The current state of log capture:
|
| ddr_snoopy_loguniq | integer | The current log ID at which transactions are being captured for replication |
| ddr_snoopy_logpos | integer | The current log position at which transactions are being captured for replication |
| ddr_replay_loguniq | integer | The current log ID at which transactions have been applied |
| ddr_replay_logpos | integer | The current log position at which transactions have been applied. This is the position from which the log would need to be replayed to recover Enterprise Replication if Enterprise Replication or the database server shut down. |
| ddr_curr_loguniq | integer | The current log ID |
| ddr_curr_logpos | integer | The current log position |
| ddr_logsnoop_cached | integer | The number of log pages that log capture read from its cache |
| ddr_logsnoop_disk | integer | The number of times that log capture had to read log pages from disk |
| ddr_log_tossed | integer | The number of log pages that could not be stored in the cache because the log capture buffer cache was full |
| ddr_logs_ignored | integer | The number of log records that were ignored because they were extensible log records unknown to Enterprise Replication |
| ddr_dlog_requests | integer | The number of times that a dynamic log was requested to be created to prevent DDRBLOCK state |
| ddr_total_logspace | integer | The total number of log pages in the replication system |
| ddr_logspace2wrap | integer | The number of log spaces until log capture runs into a log wrap |
| ddr_logpage2block | integer | The number of log pages until log capture runs into a DDRBLOCK state |
| ddr_logneeds | integer | The number of log pages necessary to prevent a log wrap to avoid a DDRBLOCK state |
| ddr_logcatchup | integer | The number of log pages necessary to process before going out of a DDRBLOCK state |
| ddr_loglag_state | char(10) | The state of DDR log lag: on or off |
| ddr_cur_loglag_act | char(24) | The action being taken to prevent log wrapping |
| ddr_logstage_diskusage | float | The amount of used log staging disk space as a percentage of the total space |
| ddr_logstage_hwm4disk | integer | The maximum allowable disk space for log staging in KB |
| ddr_logstage_maxused | float | The maximum disk space ever used for log staging in KB |
| ddr_logstage_lfile_cnt | integer | The number of staged log files |