Generating the configuration for the Data Virtualization Remote Agent

Generate the Configuration hash and Instance ID that is used to deploy the Data Virtualization Remote Agent.

1. Navigate to the Run SQL page.
2. Enter the following SQL command and then enter the value for each parameter listed in the following table.

   call dvsys.generateconfighash('<Agent name>','<Agent description>', <Data port>, <Management port>, 'peerAuthentication', null, -1, -1,'DV_EXTERNAL_NODE_HOSTNAME_PORT=<Exposed Cloud hostname:port>‘, ?, ?, ?);

   Table 1. Parameter, parameter descriptions, and default values that you use to generate the configuration for the Remote Agent.

   Parameter	Description	Default value
   Agent name	Enter the name of the Remote Agent. You can only use uppercase or lowercase letters, numbers, and the underscore symbol ( _ ).	Defaults to the hostname where the agent runs.
   Agent description	Enter an optional textual description of the Remote Agent. Do not include new lines or single quotation marks.	–
   Data port	Enter the Data communications port. See Table 2. Network ports and descriptions.	6414
   Management port	Enter the Management port. See Table 2. Network ports and descriptions.	7777
   Exposed Cloud hostname:port	Enter the hostname and port for accessing the Remote Agent data port, if it is different from the actual hostname and data port. For example: Secure Gateway for IBM Cloud is Cloud_hostname:port. If you use this parameter, you must specify it as: DV_EXTERNAL_NODE_HOSTNAME_PORT=hostname:port	–

3. Select Run All.
4. Expand the Results output and export it.
   • In the Output values column, take a note of the Instance ID and Configuration hash.

     • Instance ID is listed in the first row.
     • Configuration Hash is listed in the second row.
   After you generate this information, proceed to deploy the Remote Agent on Linux® or Windows.
   To deploy on Linux, see Deploying the Remote Agent on Linux.
   To deploy on Windows, see Deploying the Remote Agent on Windows.