´╗┐Release Notes for ASNA DataGate Monitor® Version: Release date: 2023-08-28

ASNA DataGate Monitor®

DataGate Monitor® is a utility that operates within ASNA DataGate, allowing you to monitor objects in the DataGate database. These objects include: libraries, file, and members.

What's New

DataGate Client

Known Issues

DataGate Client * DataGate 16 features secure database name storage using Windows DPAPI. ASNA has always recommended using PUBLIC database names for websites.
In v16, we further recommend always using the "
Public/" prefix explicitly when referencing database names in website applications, including Monarch.
Otherwise, applications may encounter run-time exceptions that include phrases such as "user profile not loaded" when Windows DPAPI is used in IIS sessions running with anonymous or impersonated credentials.

For example, an AVR-based website might have code similar to the following, which references a DG database name in a DCLDB statement as follows:

DclDB Name(MyDatabase) DBName("IBMSERVER") Access(*Public)

We strongly recommend changing this statement as shown below:

DclDB Name(MyDatabase) DBName("*Public/IBMSERVER") Access(*Public)

If changing existing code is impractical, the only way to avoid errors is to ensure that the configuration of the IIS application pool in which the 
website runs includes the setting "Load User Profile = True".  
Note that this setting may reduce the performance of large-scale website applications.  Configuring IIS is Windows- and version-dependent, but 
generally follows this set of steps:
    1.  Open IIS Manager.
    2.  Under the Application Pools node, select the Application Pool that the website runs under.
    3.  On the right-hand panel, select "Advanced Settings...".  A property dialog appears.
    4.  Scroll to the Load User Profile setting, and ensure that it is set to True.
    5.  Restart IIS.

DataGate Studio

Installation Notes

DataGate Monitor is included in several installation packages from ASNA, including:

If you have already installed any of these products you may not need to download and install this package of DataGate Monitor.

Installing Microsoft's latest service packs, high priority and optional software updates for Windows and the .NET Framework is highly recommended.

Secure Sockets Layer (SSL)

The DataGate client software contained in this release significantly changes the way Secure Sockets Layer (SSL) connections are configured. DataGate SSL support was introduced in Version 15 as an option for secure network communications between DataGate clients and servers.

In prior releases, DataGate client connection configurations, by default, specified an SSL-enabled connection. This allowed many users to enhance the security of their applications by simply installing the new, SSL supporting DataGate release. Unfortunately, other customers experienced connection and security issues due to shifting standards and evolving platform infrastructure supporting SSL, as offered by Windows and IBM i.

In this release, DataGate client users must now "opt-in" when configuring new connections secured with SSL. When a new connection configuration is created, the default setting is to specify a non-SSL, or "clear-text" connection to the server.

DataGate connections are typically configured as "database names". A database name is a collection of properties defining all the information needed to connect to a DataGate server from the client computer. Existing database names are not affected by this change, but new database names are affected:

Database names created by prior releases retain the same SSL configuration as they had when created or modified. The default configuration of new database names will specify non-SSL connections. Creating SSL-Enabled Database Names

Online documentation linked below fully details the process of creating an SSL-enabled database name configuration using DataGate Studio. The process is very similar for users of DataGate Monitor.

More information here

Other DataGate SSL Options

DataGate offers many options for enhancing the security of its client/server connection with SSL. For full details of options available for both the client and server, please consult the online documentation.

Configuring DataGate Connections Programmatically

Connection configurations are represented in DataGate as instances of the SourceProfile class in the DataGate .NET API. While most users and applications will configure connections via database names, some programs use the DataGate API directly.

Users of the SourceProfile class are advised that the changes in this release may represent a breaking change to the behavior of your programs. The default value of the SourceProfile.SslOptions property is now SslOptions.None; in previous releases the default value was SslOptions.Request. If your program does not explicitly set this property, connections made with the SourceProfile instances you create will be clear-text, rather than SSL-enabled.

If you directly create and use SourceProfile instances in your programs, ASNA highly recommends modifying them to explicitly set SourceProfile.SslOptions before deploying this DataGate release.

Database Name Migration From Non-SSL Releases

Database names created by DataGate releases prior to Version 15 do not contain SSL-related configuration information. When these database names are read by Version 15 software, the configuration is migrated to include SSL configuration options. Prior to this release, those migrations would enable SSL connections, unless otherwise explicitly changed by the user. Henceforth, automatic database name migrations will disable SSL in the connections they represent.

Users who deploy applications using the database names contained in configuration files created with prior, non-SSL supported DataGate releases are advised that changes in this release may represent a breaking change in this deployment strategy, for reasons outlined in the previous paragraph.

Software Requirements

DataGate Monitor supports the following software:

Platform support:

DataGate for SQL Server 16.x supports:

ASNA Mobile RPG and ANSA Wings also require:

ASNA Monarch Cocoon also requires:

Classic Database Names and Classic Database Manager

Since users of prior DataGate releases may have registry-based database names already installed on their systems, DataGate monitor provides commands for invoking DataGate "Classic" tools, such as Database Manager. DataGate Studio, AVR.NET, and any other software based on the DataGate .NET client (including DataGate Monitor), can only edit database names residing in DataGate database name .config files. Similarly, Classic software can only access and edit database names residing in the Windows registry. DataGate Monitor cannot create, modify, or delete Classic's registry-based database names. Thus DataGate Monitor provides the "Open with Classic Tools" command for managing Classic database names.

Note that in some cases, Classic database names may be deployed to machines that do not have Classic tools installed, or the Classic tools reside in a non-standard folder. In those cases, attempts to invoke Classic tools from DataGate Monitor will result in a "not found" exception dialog prompt. If Classic tools reside in a non-standard folder, the user may specify that folder via the tree node's Properties dialog.

To access this dialog, select the DataGate Monitor node (the root node in the tree-view panel), and click the "Properties" command in the Actions panel or context menu. The dialog's "Classic Database Manager" tab will be shown, where the user may specify the custom path for the Classic Database Manager, or other tool for accessing Classic database names. Also note that to save this configuration, the console must be running in "author-mode", rather than in the mode provided by the default DataGate Monitor shortcut. (See Custom Configurations.)

Custom Configurations

Microsoft Management Console, unless restricted by system policy, runs in the so-called Author-Mode (see http://technet.microsoft.com/en-us/library/cc779416(v=ws.10).aspx or search for the "author-mode" topic in MMC help), which allows console configuration changes to be saved to an .msc file. The saved configuration can be subsequently accessed in console sessions by specifying the .msc file as a mmc.exe command parameter, or by using the MMC "File|Open..." command when running in author-mode. Note that the default shortcut installed with DataGate Monitor DOES NOT invoke the console in author-mode.

However, it is possible to modify the .msc file used by the shortcut in a console session running in author-mode, and save those modifications to the .msc file. Thereafter, invoking the default shortcut will cause DataGate Monitor to use the modified console settings. Additionally, you may create custom console settings which include multiple snap-ins from among those installed on the system. For example, the Internet Information Server snap-in can run in the same console session as DataGate Monitor.

Note If this software is downloaded via Microsoft Internet Explorer 9 or 10 you may receive a message stating that this file "is not commonly downloaded" when attempting to install it. In this event click the View Downloads button, select the ASNA product to install from that list, and confirm that you'd like to install it.

Similarly, attempting to install the software directly through Microsoft Windows may cause a "Windows protected your PC" message to appear. In this event click the small More Info prompt on the left, and click Run Anyway on the following window.


Changes Since Version:

Clients - DataGate