Set Up the DSNUTILS Enterprise Server Region

Create the DSNUTILS enterprise server region

In Eclipse, open the Server Explorer view.
If it is hidden, display it by choosing Window > Show View > Server Explorer.
Expand Local [localhost:10086]
Right-click Default [127.0.0.1:86], 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 New Enterprise Server dialog box appears.
In the Name field, type DSNUTILS.
Next to the Template field, click Browse and navigate to the location of the Enterprise Developer server templates, which is %ProgramFiles(x86)%\Micro Focus\Enterprise Developer\etc\ServerTemplates by default.
Select JCLTemplate.xml, and click Open.
In the Associate with projects box, check JCL1.
Click Finish.
In the Server Explorer view, expand Default [127.0.0.1:86] to check to see that the 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)

From the Eclipse Server Explorer, expand Local [localhost:10086].
Right-click Default [127.0.0.1:86] and then click Open Administration Page.
The Region and Server List page in ESCWA is displayed in your default browser.

Configure DSNUTILS properties

In ESCWA, click NATIVE.
In the navigation pane, expand Directory Servers > Default, and select the DSNUTILS enterprise server region.
Click GENERAL, and select Properties from the drop-down list.
In the ADDITIONAL section, type the following into the Configuration Information field:
```
[ES-Environment]
IDE_PROJPATH=eclipse-workspace\JCL1
```
Where eclipse-workspace is the full path to your default Eclipse workspace.
Scroll up to the System Directory field, and type in the path to your system directory, which is $IDE_PROJPATH\system.
Under REGION FEATURES, ensure that MSS Enabled and JES Enabled are both checked.
Click APPLY.

Set up XA resources

Click GENERAL > XA Resources.
On the XA RESOURCES page, click NEW.

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.Password`¹
¹ Use your SQL Server authentication credentials.

Click SAVE to complete the XA resources setup.

Define the dataset location

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

Start the DSNUTILS enterprise server region

In Server Explorer, expand Local [localhost:10086] > Default [127.0.0.1:86].
Right-click DSNUTILS, and then click Start.

Note: If you start the enterprise server region outside the Eclipse IDE, then the environment variable IDE_LOADLIB must be specified and the directory and any subdirectories used by the region must exist.

Create aliases for MBDT

In In the navigation pane, expand the DSNUTILS enterprise server region, and then click the arrow that appears to its right.
Refresh the ESCWA page.
In the right pane, click JES > Alias to open the ALIAS page.

Create each alias listed in the table below, one at a time, as follows:

Click NEW.
On the NEW ALIAS dialog box, enter a program and alias pair from the table.
Click SAVE.

Program	Alias
HCOTEP2	SQLTP2
HCOUTILB	SQLUTB

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

In Server Explorer, expand Local [localhost:10086] > Default [127.0.0.1:86].
Right-click DSNUTILS, and then click Stop.