Set Up the DSNUTILS Enterprise Server Region

Create the DSNUTILS enterprise server region

1. In Visual Studio, open the Server Explorer.

   If it is hidden, display it by choosing View > Server Explorer.

2. Expand Micro Focus Servers.
3. Right-click localhost, and click New Enterprise Server.
   Tip: If you are not currently signed on to the current enterprise server, the Enterprise Server Sign On dialog box appears: click OK to sign on as the SYSAD user. (Alternatively, click Use specific server credentials, then enter a valid username and password.)

   The Create New Enterprise Server dialog box appears.

4. In the Name field, type DSNUTILS.
5. Next to the Template field, click Browse and navigate to the location of the Enterprise Developer server templates, which is VSInstallDir\IDE\Extensions\nnnnnnnn.nnn\Etc\ServerTemplates\ by default.
6. Select JCLTemplate.xml, and click Open.
7. In the Associate with projects box, check JCL1.
8. Click OK.

   The Output window displays notification that the server has been created. If the Output window is not displayed, select View > Output.

9. In the Server Explorer, expand localhost to check that the DSNUTILS server has been added. By using the template, the server already has the necessary options selected for MSS enablement.

Start Enterprise Server Common Web Administration (ESCWA)

• On the Server Explorer, right-click Micro Focus Servers, and then click Administration.

  ESCWA starts in your default browser.

Configure DSNUTILS properties

1. In ESCWA, click NATIVE.
2. In the navigation pane, expand Directory Servers > Default, and select the DSNUTILS enterprise server region.
3. Click GENERAL, and select Properties from the drop-down list.
4. In the ADDITIONAL section, type the following into the Configuration Information field:

   [ES-Environment]
   IDE_PROJPATH=C:\tutorials\MBDT\JCL1

5. Scroll up to the System Directory field, and type in the path to your system directory, which is $IDE_PROJPATH\system.
6. Under REGION FEATURES, ensure that MSS Enabled and JES Enabled are both checked.
7. Click APPLY.

Set up XA resources

1. Click GENERAL > XA Resources.
2. On the XA RESOURCES page, click NEW.
3. Populate the fields on the XA Resource Configuration dialog box as follows:

   Field	Value
   ID	HCOD
   Name	HCODEMO
   Module	esodbcxa.dll
   Open string	DSN=HCODEMO,USRPASS=loginID.Password1
   1 Use your SQL Server authentication credentials.

4. Click SAVE to complete the XA resources setup.

Define the dataset location

1. In ESCWA, click JES > Configuration.
2. In the Default Allocated Dataset Location field, type $IDE_PROJPATH\data.
3. Click APPLY.

Start the DSNUTILS enterprise server region

1. In Server Explorer, expand Micro Focus Servers > localhost.
2. Right-click DSNUTILS, and then click Start.

Create aliases for MBDT

1. In In the navigation pane, expand the DSNUTILS enterprise server region, and then click the arrow that appears to its right.
2. Refresh the ESCWA page.
3. In the right pane, click JES > Alias to open the ALIAS page.
4. Create each alias listed in the table below, one at a time, as follows:
   1. Click NEW.
   2. On the NEW ALIAS dialog box, enter a program and alias pair from the table.
   3. Click SAVE.

   Program	Alias
   HCOTEP2	SQLTP2
   HCOUTILB	SQLUTB

5. In the navigation pane, select the DSNUTILS enterprise server region, and then click the arrow that appears to its right.

Stop the DSNUTILS enterprise server region

1. In Server Explorer, expand Micro Focus Servers > localhost.
2. Right-click DSNUTILS, and then click Stop.