Release Notes

File-AID/EX 18.02

January 4, 2018

Obtaining the Latest Release Notes

What’s New

File-AID/EX Maintenance Support

Software and Hardware Requirements

Technical Notes

Known Issues

Product Documentation

Support Resources

Obtaining the Latest Release Notes

For the most current version of these Release Notes , go to FrontLine , Compuware’s customer support website. The first time you access FrontLine, you are required to register and obtain a password. After logging onto FrontLine, select your product from the drop-down list. On the left side of the page, click the Documentation link. You will find the latest Release Notes listed with the other product documentation.


What’s New

January 4, 2018

Topaz for Enterprise Data

  Execution suites have been added to allow a list of File-AID/EX specifications to be executed together, in the order specified in the suite definition. Execution suites may contain Related Extract, Related Loader, ConverterPro, and ComparePro specifications as well as other execution suites. They will replace ConverterPro sets, ComparePro sets, and the Batch Execution Utility.

  Execution for File-AID/EX specifications has been enhanced to include selection of the execution server where the specification is to run.

  Export functionality available for File-AID/EX specifications has been enhanced to export as batch so that the specification can be run as part of a batch jobstream in Windows or UNIX without requiring access to the repository.

  A new view is available to list all File-AID/EX specifications. Execution logs are now displayed in this view and have been removed from the File-AID Explorer tree view.

  Support has been added for schema filters in Related Extract.

  New options have been added to Related Loader to choose whether the clear rows option will use database delete or truncate processing and to create constraints before loading.

  Modified date is now available for each File-AID/EX specification.

  Execution history can now be cleared from the console.

October 2, 2017
Topaz for Enterprise Data Media

New media, called Topaz for Enterprise Data, has been created for installing the following:

  File-AID Services

  File-AID Rules Engine

  File-AID/EX

  File-AID Execution Servers

This new packaging means that, starting with release 18.02.03, File-AID Data Privacy and standalone File-AID/EX are no longer ordered as individual products.

Additionally, to use the File-AID/EX and File-AID Data Privacy features that are available in Topaz Workbench, users must install the appropriate options listed above and install the following features during Topaz Workbench installation:

  File-AID/EX feature

  File-AID Data Privacy feature

  Topaz for Enterprise Data feature (allows use of Enterprise Data Editor and Data Visualizer)

File-AID/EX in Topaz Workbench

The File-AID/EX feature in Topaz Workbench includes the following components:

  Related Extract

  Related Loader

  Selection Criteria

  Application Relationship Editor

These components no longer exist in standalone File-AID/EX.

The following components exist in standalone File-AID/EX but can also be launched from Topaz Workbench:

  ConverterPro

  ComparePro

Migration of Specifications

All Related Extract and Related Loader specifications will now open in Topaz Workbench editors. If the existing specification contains any features that are not supported in Topaz Workbench, a message listing the unsupported features appears and warns that these features will be dropped from the specification if it is opened in Topaz Workbench. The following features are not supported:

  Embedded Privacy rules

  File encryption and decryption

  Related Extract options:

-- Dependents to fetch count

-- Schema filters

  Related Loader options:

-- Create contraints before load

-- Lookups during related loader

-- DB2 remote load

ConverterPro Specification Replication Utility

The new Specification Replication Utility makes it easy for users to replicate ConverterPro specifications and adjust connection information in the copy. Users can save a specification copy to the original repository or to a different repository, rename or add a prefix/suffix to the copy, and create an override file in which to provide any connection information that varies between the original specification and the copy. The following connection information can be overridden using an override file:

  Connection template

  File path name

  Connection type to change (source, target, lookup, and/or data generation)

  Data Privacy repository name


File-AID/EX Maintenance Support

Compuware is committed to actively supporting its current product releases. Up-to-date product release support and retirement information is available on FrontLine's FrontLine Support - Product Currency Tables page.


Software and Hardware Requirements

For further information about IBM System z software and hardware compatibility--specifically regarding IBM's z/OS Recommended Service Upgrade, IBM's Extended Address Volumes, IBM DB2 for z/OS, and z/OS product compatibility--refer to https://go.compuware.com/charts/hardware.aspx .

File-AID/EX Enterprise Edition (File-AID/EX Executive)
Hardware Platforms

  Mainframe Systems:

-- z800, z890, z900, z990 mainframe systems

-- z13

-- zEC12, zBC12

-- z196, z114

-- z10-EC/BC

-- z9-EC/BC

-- z900, z990

-- z800, z890

Operating Systems

  IBM z/OS V1.13, 2.1, 2.2, 2.3

  IBM ISPF for the supported z/OS releases

File-AID/EX and File-AID/EX Execution Server
Hardware Platforms

  Mainframe Systems:

-- zEC12, zBC12

-- z196, z114

-- z10-EC/BC

-- z9-EC/BC

-- z900, z990

-- z800, z890

  Distributed Systems:

-- AIX Power

-- HP-UX Itanium

-- Linux x86, x64

-- Solaris Sparc

-- Windows x86, x64

Hardware Requirements

  Hardware:

-- Linux x86, x64

-- RISC workstation

-- RS/6000 workstation

-- Sun SPARC workstation

-- Windows x86, x64

  Processor: 1 GHz processor minimum; 3 GHz recommended on Linux; 1 GHz minimum; 3 GHz recommended on Windows

  Hard Disk: 700 MB minimum; 1 GB recommended. Additional disk space may be required when extracting large sets of data.

  RAM: 1 GB minimum; 2 GB recommended; 4 GB recommended

Operating Systems

  HP-UX 11iv2 (11.23), 11iv3 (11.31) on Itanium-based machines.

  IBM AIX Enterprise Edition V6.1.0, 7.1.0

  Microsoft Windows 8.1, 10

  Microsoft Windows Server 2012

  Red Hat Enterprise Linux 6.x, 7.2, 7.3

  Solaris 10 (Sparc processor-based versions only)

Major Subsystems

  IBM DB2 for z/OS: Toleration support for V11.1, 12.1

  IBM IMS Transaction and Database Servers V13.1, 14.1 (only support PSBs generated prior to IMS 11)

Languages

  Oracle Java SE 8 (Java 8is installed automatically on Windows systems during File-AID/EX installation but must be installed manually on UNIX and Linux.)

Corequisites

  Compuware Products and Components:

-- File-AID/RDX 16.3, 17.2. File-AID/EX can load from an extract file created by File-AID/RDX.

-- File-AID Data Privacy: Refer to the File-AID Data Privacy Release Notes.

-- File-AID/EX 18.02.04 is required for Topaz for Enterprise Data 18.02.04.

Distributed

  IBM DB2 for Linux, UNIX, and Windows (LUW): V9.5, 9.7, 10.1, 10.5. DB2 LUW requires IBM DB2 Connect Unlimited Edition for System z for Windows or the type-4 JDBC drivers.

  Microsoft Internet Explorer 10, 11 for the supported Windows releases (for using the installation media and viewing online help)

ISV Software

  Microsoft Access 2010

  Microsoft Excel 2010

  Microsoft SQL Server:

-- Microsoft SQL Server 2012 Standard Edition

-- Microsoft SQL Server 2014 Standard Edition

-- Microsoft SQL Server 2016 Standard Edition

  Oracle JDBC 11.2.0, 12.1.0

  SAP Adaptive Server Enterprise 15

Supported File Types by File-AID/EX Component

The table below indicates which file types are supported by the various File-AID/EX components. File types are supported for the supported versions of third-party products listed in the Software and Hardware Requirements section.

File Type

ConverterPro

ComparePro

Related Extract

Related Loader

IBM AS/400

Yes

 

 

 

IBM DB2 for z/OS

Yes

Yes

 

 

IBM DB2 Load Utility

 

 

 

Yes

IBM DB2 for Linux, UNIX, and Windows

Yes

Yes

Yes

Yes

File-AID/RDX

 

 

 

Yes

IBM IMS Transaction and Database Servers

Yes (source only)

 

 

 

Microsoft Access

Yes

Yes

 

 

Microsoft Excel

Yes

Yes

 

 

Microsoft SQL Server

Yes

Yes

Yes

Yes

MVS

-- VSAM ESDS

Yes

 

 

 

-- VSAM KSDS

Yes

 

 

 

-- QSAM

Yes

 

 

 

Oracle JDBC

Yes

Yes

Yes

Yes

Oracle SQL Loader

 

 

 

Yes

Sybase Adaptive Server Enterprise

Yes

Yes

Yes

Yes

Teradata

-- ConverterPro support for Teradata requires that the specification source and target be different. Use null source if necessary.

Yes

 

 

 

Windows/Unix Files

-- Delimited

Yes

Yes

 

 

-- Fixed

Yes

Yes

 

 

-- Text

 

Yes

 

 

XML

Yes

Yes

 

 

Discontinued Support

  Support for File-AID/EX 16.03 will be discontinued on December 31, 2018.


Technical Notes
Viewing Online Help in Google Chrome

A Google Chrome security update prohibits viewing of WebHelp when the help is deployed locally from a file server (as opposed to a Web server). Attempting to view locally deployed help displays a blank help window. Compuware suggests that online help be viewed using Internet Explorer. Alternatively, Chrome's security feature can be turned off by launching Chrome with the command line option --allow-file-access-from-files. This method should only be used when opening local WebHelp that you trust.

File-AID Rules Engine Compatibility

The version of the File-AID Rules Engine installed with File-AID/EX must match the version of File-AID Services and Topaz Workbench.

Setting Preferences and Advanced Properties

When setting preferences and advanced properties (particularly those affecting encoding) in ConverterPro, these properties are not also modified in ComparePro. The opposite is also true, if preferences and advanced properties settings are changed in ComparePro, it does not modify settings in ConverterPro.

Open Source

This product contains the use of open source software packages. Any open source software that was modified as part of its use within this tool suite has been included on the product media in a folder named 'Open Source'. Within those files, any modifications to the original code structure have been documented with comments indicating they are changes made by Compuware and not the original author. In addition, the license files for those corresponding open source packages are also included in a folder named 'Licenses'.


Known Issues
Windows User Authority Installation Requirements

Due to current registry update requirements, an installer must have Administrator authority or be a member of the Administrator group. Any other authority level will cause the installation to fail.

ComparePro

There is a known limitation where ComparePro jobs being executed by a Remote Execution Server will not function if using the standard default Derby repository. Compuware suggests creating a separate repository in one of the other supported database types in this case.


Product Documentation

The product installation package does not include the product documentation. The following File-AID/EX documentation is available in electronic format on the product documentation site at Compuware’s FrontLine customer support website, https://go.compuware.com .

  Release Notes in HTML format

  The product manuals in PDF format, which may include a PDX index file and associated folder.

Access the File-AID/EX documentation on the FrontLine documentation site at https://go.compuware.com .

PDF and PDX Files

View and print the PDF files with Adobe Reader version 6.0 or more current. Download a free copy of the reader from Adobe’s website, http://www.adobe.com .

Note: With a few minor exceptions, the provided PDF files comply with the requirements of section 508 of the Rehabilitation Act of 1973.

How to Use a PDX File to Search a Compuware Documentation Set

Compuware creates a PDX file for each release of every mainframe product. The file is available in ZIP format on FrontLine, Compuware’s customer support website, along with this README and a folder containing two data files. By pre-cataloging the content of the product’s PDFs, the PDX file allows you to quickly search across the entire documentation set without having to search each PDF individually.

To use the PDX file for a Compuware product:

1. Go to FrontLine ( https://go.compuware.com ) and navigate to the Documentation page for the desired product.

2. Download all of the PDF files for that product to the same local directory. (The Compuware Installer PDF is only cataloged in the Enterprise Common Components PDX file.)

3. Download the ZIP containing the product’s index file.

4. Extract the contents of the ZIP, sending it to the same directory as the PDF files. Be sure to select “All files/folders in archive” and “Use folder names.”

5. Double click the product’s PDX file (< product >Index.pdx). A Search dialog box will appear with the index pre-selected.

6. Enter a word or phrase to search for. To optimize your search, select one or more qualifiers such as “Whole words only,” then click Search.

Your search results will appear almost instantly, grouped by document. Each document with results can be expanded to show a list of matches, with each match including a brief sample of the context in which it occurred. Every match is hyperlinked to the specific page in the PDF where it was found, enabling you to quickly locate the information you’re looking for.

HTML Format

For your convenience, Compuware also provides the File-AID/EX manuals in the Hypertext Markup Language (HTML) format. View HTML files with any standard web browser. Click the icon in the HTML column on the selected FrontLine Documentation page.


Support Resources

Compuware provides a variety of support resources to make it easy for you to find the information you need.

Compuware FrontLine Customer Solutions Website

You can access online information for Compuware products via our FrontLine Customer Solutions website at https://go.compuware.com .

Compuware FrontLine provides access to critical information about your Compuware products. You can review frequently asked questions, read or download documentation, access product fixes, or e-mail your questions or comments. The first time you access Compuware FrontLine, you are required to register and obtain a password. Registration is free.

Contacting Customer Solutions

Phone

  USA and Canada: 1-800-538-7822 or 1-313-227-5444.

  All other countries: Contact your local Compuware office. Contact information is available at https://go.compuware.com .

Web

You can report issues via the Quick Link Create & View Support Cases on the Compuware FrontLine home page.

Note: Please report all high-priority issues by telephone.

Mail

Compuware Customer Solutions
Compuware Corporation
One Campus Martius
Detroit, MI 48226-5099

Corporate Website

To access Compuware’s site on the Web, go to http://www.compuware.com .

The Compuware site provides a variety of product and support information.