Configure the installdp1Config2_DOAS SQL file

Edit the installdp1Config2_DOAS.sql file to ensure that the System ID (SysId) matches what is listed in the Network Management Console (NMC), and to update the destination of the data being datapumped.

To edit the installdp1Config2_DOAS.sql file

1. Navigate to %DNADataRoot%\Historical\config\applicationsql\DataPump\<System Name>\installdp1Config2_DOAS.sql file.

2. Update the comments at the top of the file to ensure that the file matches the SysIds in the NMC. For example:

   Note: This information can be retrieved from the NMC.

   **

   ** example:

   **

   ** SYSTEM SYSID

   ** ======== ======

   ** mcc 1

   ** bcc 2

   ** mccdss 3

   ** bccdss 4

   ** es 5
   **
   */

3. Update the DPSystem by entering the destination systems into the insert script, and commenting out the ones you will not use as a destination for data. It is good practice to match the xfr_status columns to the SysID column.

   Note: In single Historical scenarios, only systems with a principal Historical service can be inserted in the DPSystem table.

   For example:

   /****** PUT PROJECT SPECIFIC CONFIG HERE *****/

   -- insert into DPSystem values ('mcc', 'xfr_status1', 1)

   insert into DPSystem values ('bcc', 'xfr_status2', 2)

   -- insert into DPSystem values ('mccdss', 'xfr_status3', 3)

   -- insert into DPSystem values ('bccdss', 'xfr_status4', 4)

   --insert into DPSystem values ('es', 'xfr_status5', 5)

   go