5.1.2 Editing a Connection

  1. Click Connections in the navigation pane.

  2. In the connections list, click the edit (pencil) icon next to the connection that you want to edit.

    Alternatively,

    Click the connection name from the connections list, to display the Connection Details and Connection Configuration sections.

To edit the Connection Details:
  1. Click Edit in the Connection Details section, to edit the description, Agent or Datasource connection details.
  2. Click Save to save your edits.
To edit the Connection Configuration:

This tab modifies the behavior of the agent.

A check mark under Use Default indicates that a parameter is set to the default value.

The current setting is shown under Value.

If the parameter is a toggle, a check mark under Value indicates that it is enabled.

To change a setting
  1. Clear the Use Default check box.
  2. Edit Value.
  3. Click Save.

Parameter Details

  • Agent Message Timeout: Specifies a time interval, in seconds, after which the Server abends, if it has not received a message from the Agent.

  • Truncate Trailing Spaces When Comparing Values: Space (U+0020) and Ideographic Space (U+3000) are the truncate targets. This parameter works only for String or Binary columns. You can configure the truncated length with the truncate_spaces_len entry in the veridata.cfg file of the Oracle GoldenGate Veridata Server. This parameter also truncates the column padding character if the padding character is one of the targe spaces. This parameter does not trim trailing spaces on LOB data.

  • Compare Fetch Size: Sets the number of rows that are fetched at once for the initial comparison and for the confirm out of sync using batch or join. Increasing the batch size may increase throughput, as compared to standard database access.

    Exclusively, for the Oracle and PostgreSQL databases, the default value is 1000 and it fetches a batch size of 1000 rows; the minimum value that you can enter is 100. Any lesser value that you enter automatically changes to 100. The maximum value is 100000. For databases other than Oracle and PostgreSQL (SQL Server, Sybase, or DB2), the default value is 0, minimum is 0, and maximum value is 1000.