Release Notes for IBM WebSphere Transformation Extender, V220.127.116.11
These release notes contain the information required to install and operate IBM® WebSphere® Transformation Extender, version 18.104.22.168.
IBM WebSphere® Transformation Extender, version 22.214.171.124
release notes (rev. 1)
© Copyright IBM Corporation 2006, 2012. All Rights Reserved.
1. About this release
2. Installation and configuration information
3. Upgrade and migration information
4. Known limitations, problems, and workarounds
5. New and changed behavior
6. Resolved Authorized Program Analysis Reports (APARs)
7. Command Server Notes
For the following products:
- IBM WebSphere Transformation Extender with Command Server
- IBM WebSphere Transformation Extender with Launcher
- IBM WebSphere Transformation Extender Design Studio
8. Software Development Kit notes
9. Launcher Studio Notes
For IBM WebSphere Transformation Extender Launcher Studio
10. Contacting customer support
11. Notices and trademarks
1. ABOUT THIS RELEASE
This release is a full version of the product. Version 126.96.36.199 can coexist on the same computer with earlier point releases of the product starting from Version 8.1.
Where to find the software to download
To download the software for WebSphere Transformation Extender Version 188.8.131.52, go to Passport Advantage Online.
After you install the software for this release, go to WebSphere Transformation Extender Support downloads to download and install any Interim Fix releases. For details about the Interim Fix, go to the IBM WebSphere Transformation Extender Support web site.
For information about known problems and workarounds in Version 8.3, go to http://www.ibm.com/support/docview.wss?&uid=swg21413038.
For answers to frequently asked questions and workarounds for known problems in all WebSphere Transformation Extender releases, view the tech notes that are on the IBM Support web site.
For information about the documentation and how to access it, see the Documentation release notes.
The sections in this file provide release notes for the IBM WebSphere Transformation Extender products listed below. There are also sections for notes that apply to specific products.
- IBM WebSphere Transformation Extender with Command Server
- IBM WebSphere Transformation Extender with Launcher
- IBM WebSphere Transformation Extender with Launcher Studio
- IBM WebSphere Transformation Extender Design Studio with SDK
- IBM WebSphere Transformation Extender for Application Programming
WebSphere DataPower® SOA Appliances
New functionality is described in the "What's New" topic of the WebSphere Transformation Extender documentation.
For the latest information about support for Enterprise Packs and Industry Packs, see WebSphere DataPower SOA Appliances support of WebSphere Transformation Extender Enterprise Application Packs and Industry Packs.
To see which versions of IBM WebSphere DataPower that this release of WebSphere Transformation Extender supports:
- Go to the IBM WebSphere DataPower Documentation web page:
- Navigate to the release and DataPower SOA Appliance.
- Locate the software or system requirements and product compatibility information for DataPower integration with WebSphere Transformation Extender that is included in the available information center, PDF file, or release notes file.
Java™ Runtime Environment (JRE)
WebSphere Transformation Extender 8.3 installs the IBM version of Java™ 2 Runtime Environment, Standard Edition, Version 1.6.0 SR6.
Use the installed version of JRE. If you configure WebSphere Transformation Extender to use a different JRE, it must be the same version as the installed JRE version.
The JRE is not included with the WebSphere Transformation Extender for z/OS® product, Version 8.3.
To do before opening the Design Studio
By default, Eclipse applications cache plug-ins. In certain circumstances, the default Eclipse behavior might prevent Design Studio from opening, cause Design Studio to be unstable or to exhibit the behavior of an earlier release, or cause the run map process to fail.
To avoid these problems, take one of the following steps before you open the Design Studio application:
- Clear the cached version of the Design Studio plug-ins by running the cleanextenderstudio.bat batch file. The cleanextenderstudio.bat batch file is installed at the root of install_dir
- Delete the .metadata folder that is in your workspace, and then reimport the workspace, or switch to a different workspace.
Run the cleanextenderstudio.bat batch file to clear the cached version of the Design Studio plug-ins under the following circumstances:
- Your workspace got corrupted.
In this case, the open process fails when Eclipse attempts to open the Design Studio.
- You installed a patch provided by the WebSphere Transformation Extender customer support team that copied files to the wtxstudio directory.
In this case, when Eclipse attempts to open the Design Studio, it uses the cached versions of the Design Studio plug-ins from the prior release on which this patch was installed, which causes the open Design Studio process to fail.
- You installed a fix pack release on top of a WebSphere Transformation Extender 8.3 release.
In this case, when Eclipse attempts to open the Design Studio, it uses the cached versions of the Design Studio plug-ins from the prior release on which this fix pack was installed, which causes the open Design Studio process to fail.
Delete the .metadata folder and reimport the workspace, or switch to a different workspace under the following circumstance:
- You ran a map that could not be loaded into memory, which caused the map to fail and the Design Studio application to terminate abnormally. When you tried to reopen the application, the open process failed.
The ODBC Adapter supports both IBM and DataDirect ODBC drivers. ODBC drivers from other vendors might work, but they are not tested for compatibility with WebSphere Transformation Extender. Because of this, the ODBC Adapter is usually better suited for use with IBM and DataDirect ODBC drivers.
However, when designing a map to connect to a DB2 data source that is located on a Linux®, UNIX®, Microsoft® Windows® or z/OS system, you might prefer to use the DB2 Adapter. The DB2 Adapter connects to the DB2 database without using an ODBC driver manager and still provides all the functionality that is present in the ODBC Adapter.
Specify the ODBC Adapter from either the map command line, for example,
-DBTYPE ODBC, or from the Database Interface Designer, for example, in the "Adapter Type" field of the "Database Definition" window.
For more details about using the ODBC adapter, see the related topics in the WebSphere Transformation Extender information center.
For the DB2 Adapter to connect with a DB2 database from a Linux, UNIX, or Microsoft Windows system, install an IBM Data Server Client Package. An IBM Data Server Client Package is available for you to download from the Internet for free. Select an IBM Data Server Client Package that includes the CLI driver, which the DB2 Adapter uses to connect to a DB2 database. When configuring a database connection for a z/OS or IBM i operating system, you also need a DB2 Connect license. For further information about choosing, installing, and configuring an IBM Data Server Client Package, see the IBM Data Server Clients and Drivers topic in the IBM DB2 Database for Linux, UNIX, and Windows Information Center.
Specify the DB2 Adapter from either the map command line, for example,
-DBTYPE DB2, or from the Database Interface Designer, for example, in the "Adapter Type" field of the "Database Definition" window.
For more details about using the DB2 adapter, see the related topics in the WebSphere Transformation Extender information center.
BEA Tuxedo Adapter
WebSphere Transformation Extender products no longer include the BEA Tuxedo Adapter.
WebSphere Transformation Extender Version 8.3 includes Version 7.0 of the WebSphere FTP Adapter, WebSphere Email Adapter, and WebSphere Adapter for SAP Software. See the WebSphere adapter requirements.
Native schema support
Opening maps referencing XML Schemas
The initial map open process fully parses and validates the schema, but also creates a read-only, intermediary native schema type tree (.mtx) file. However, on subsequent open processes, it just retrieves the WebSphere Transformation Extender-specific information that is stored in this .mtx file, similar to how it retrieves the information from a type tree (.mtt) file. Retrieving the information from this cached file on subsequent open processes, is designed to improve the response time for opening maps that reference an XML Schema.
Support of Restart attribute and Reject function
WebSphere Transformation Extender information, including the Restart information, is stored in temporary, read-only native schema type tree (.mtx) files. Any changes to schemas referenced in these .mtx files might cause the process that maps items from the schema, to update the .mtx file, and remove the Restart information that was stored there. If this occurs, or if the file gets deleted, you must recreate the Restart attribute by right-clicking the type in the card in the Design Studio, and clicking Restart.
WebSphere Transformation Extender, Version 8.3 products are available in the following languages:
- Brazilian Portuguese
- English (United States)
- Simplified Chinese
- Traditional Chinese
2. INSTALLATION AND CONFIGURATION INFORMATION
When you use WebSphere Transformation Extender with another product, ensure that you satisfy the system requirements of the base product and apply all required fixes to the base product. For information about product fixes, go to http://www.ibm.com/support/entry/portal/Downloads.
On all Microsoft Windows operating systems, ensure that the WebSphere Transformation Extender installation directory has Write permission for the logged-in user.
Installing and uninstalling WebSphere Transformation Extender products and online library
For the procedure to install WebSphere Transformation Extender products, go to http://www.ibm.com/support/docview.wss?uid=swg27022110.
For the procedure to uninstall WebSphere Transformation Extender products, go to
For the procedure to install the WebSphere Transformation Extender online library, go to
Default installation location
WebSphere Transformation Extender products are installed in the default location
c:\IBM\WebSphere Transformation Extender 8.3
If you installed a previous version of WebSphere Transformation Extender, you can reuse your existing references to the installation location of the previous release. To reuse existing references, change the target installation location of Version 8.3 to match the path of the previous installation. For example, if you previously installed WebSphere Transformation Extender Version 8.2, change the installation path for Version 8.3 to c:\Program Files\IBM\WebSphere Transformation Extender 8.3.
If you reinstall WebSphere Transformation Extender Version 184.108.40.206, you must reinstall the product in the same path as the initial installation.
Design Studio shared library requirements
Design Studio does not support 64-bit libraries. Install a 32-bit version of any product or component that shares a library with Design Studio. If you install both a 32-bit version of the product and a 64-bit version, ensure that the 32-bit version occurs first in the PATH statement.
For example, when you install both the 32-bit version and the 64-bit version of WebSphere MQ Explorer V7.0, ensure that the products occur in the PATH statement in the following order:
C:\Program Files (x86)\IBM\WebSphere MQ\bin;C:\Program Files (x86)\IBM\WebSphere MQ\bin64;
Changing the JVM heap size in Design Studio
WebSphere Transformation Extender Design Studio sets a default Java Virtual Machine (JVM) heap size. You can adjust the heap size of the JVM to meet the needs of your installation. To change the heap size, edit the C:\IBM\WebSphere Transformation Extender 8.3\ExtenderStudio.bat file and change the value of the -Xmx640M parameter. For example, to set the default heap size to 1 GB, change -Xmx640M to -Xmx1024M.
Installing on your Windows Vista or Windows 7 operating system
If you are installing the WebSphere Transformation Extender products on your Microsoft® Windows Vista® or Microsoft Windows 7 operating system, do not specify c:\Program Files in your target installation location because of compatibility issues.
Before using third-party software with WebSphere Transformation Extender installed on your Windows Vista or Windows 7 operating system, check with your vendor to ensure that it is compatible with the Windows Vista operating system.
Installing the example files
To install the WebSphere Transformation Extender example files on Windows operating systems:
- After you begin installing the WebSphere Transformation Extender Design Studio, in the Setup Type window, click Custom installation.
- In the Select Components window, ensure that Example Files is selected.
The result is that the WebSphere Transformation Extender Design Studio installs the example files in the install_dir\examples folder.
WebSphere adapter requirements
For WebSphere adapter system requirements, go to http://www.ibm.com/support/docview.wss?uid=swg21405567.
Support for DataDirect ODBC drivers
WebSphere Transformation Extender supports DataDirect ODBC drivers release 6.0 on both UNIX® and Windows® systems. To see which databases and platforms the DataDirect ODBC drivers support, view the DataDirect support matrices on the following web pages:
For 32-bit driver platforms, go to http://www.datadirect.com/products/odbc/matrix/connectodbc.htm.
For 64-bit driver platforms, go to http://www.datadirect.com/products/odbc64/matrix/connect64odbc.htm.
Prerequisite procedures for running ODBC Adapters with DataDirect ODBC drivers
To run the ODBC Adapters with DataDirect ODBC drivers on Windows or UNIX operating systems, you must do the following procedures:
- Install the IBM-branded ODBC drivers on Windows or UNIX.
- Configure the ODBC DSN on Windows or configure the odbc.ini file to define the ODBC DSN on UNIX.
- Configure WebSphere Transformation Extender to access the ODBC DSN so that you can run maps on Windows or UNIX.
ODBC User's Guide:
The ODBC User's Guide is available in both PDF and HTML file formats on Windows and UNIX.
The PDF file (odbcuser.pdf) is located in < wtx install dir>\odbc\books\odbcuser.
The HTML help is located in < wtx install dir>\odbc\html.
You can navigate to the HTML version by opening the help.htm file that is under the html subdirectory.
You can also navigate to the ODBC User's Guide by opening the books.pdf file under < wtx install dir>\odbc\books. The books.pdf file points to the User Guide as well as to other documentation.
The PDF file (odbcuser.pdf) is located in odbc_drivers/book.
The HTML help is located in odbc_drivers/help.
You can navigate to the HTML version by opening the help.htm file that is under the help subdirectory.
You can also navigate to the ODBC User's Guide by opening the books.pdf file under odbc_drivers/book. The books.pdf file points to the User Guide as well as to other documentation.
To read about the new features of DataDirect ODBC drivers release 6.0, view the Preface section in the "What's New in This Release?" topic of the PDF or HTML version of the ODBC User's Guide.
Installing and configuring IBM-branded ODBC drivers on Windows
To install the IBM-branded ODBC drivers:
- Select custom installation in the Setup program.
- Make sure that the component for the "IBM WTX Branded ODBC Drivers" is selected in the Select Components window.
- Complete entering the selections in the Setup program.
To configure the ODBC DSN:
- Select Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
- Select the System DSN tab, and then click Add.
- In the Create New Data Source window, select the WTX IBM ODBC driver for this release and click Finish.
- Enter the appropriate values in the window that opens for the WTX IBM ODBC driver that you selected.
- Select the option that tests the connection from the WTX IBM ODBC driver to the database server that you previously configured. This step is optional.
Installing and configuring IBM-branded ODBC drivers on UNIX
To install IBM-branded ODBC drivers:
Select the appropriate ODBC driver option to install. Specific WebSphere Transformation Extender product installations include IBM-branded ODBC drivers for the following operating systems:
- HP-UX (Itanium™)
- HP-UX (Itanium)
The IBM-branded ODBC drivers are installed on the UNIX operating systems listed above under the odbc_drivers subdirectory of the WebSphere Transformation Extender installation location. The readme.txt file in the odbc_drivers subdirectory contains details about the contents of the subdirectory, such as the release notes, configuration information, and instructions about how to access the ODBC driver help system.
To configure the odbc.ini file to define the ODBC DSN:
Configure the odbc.ini file, which is located in the odbc_drivers subdirectory, to define the ODBC DSN. For instructions, see "Configuring the Product on UNIX/Linux > Data Source Configuration > Configuration Through the odbc.ini File" in the ODBC User's Guide.
For your maps to use the ODBC settings in the odbc.ini file at run time, you must first run the WebSphere Transformation Extender "setup" script. For details about how to run the "setup" script, see the Configuring UNIX environment variables section. After you run the script, the ODBC library paths are automatically configured.
Configuring access to the ODBC DSN
To configure WebSphere Transformation Extender to access the ODBC DSN so that you can run maps that use ODBC Adapters on Windows or UNIX:
- Start the Database Interface Designer (DID) and create a new or open an existing database query file.
A database query file has a .mdq file extension.
- Define a new database.
- Click Database > New.
The Database Definition window opens.
- For the Database Name setting, enter the name of the database that you are defining.
- For the "Adapter > Type" setting, select ODBC.
- For the "Data Source > Database Interface Designer" setting, enter or select the ODBC DSN that you specified in the "To configure the ODBC DSN" procedure on Windows.
- For the "Data Source > Runtime" setting, enter or select the ODBC DSN that you configured on Windows or UNIX. If the map is run on Windows, enter the ODBC DSN that you configured in the "To configure the ODBC DSN" procedure. If the map is run on UNIX, enter the ODBC DSN that you configured in the "To configure the odbc.ini file to define the ODBC DSN" procedure.
- Click OK.
- When you define a database card in the Map Designer, reference the WebSphere Transformation Extender ODBC connection with the following parameters:
- Database Query File
This is the name of the file that you used in step 1.
This is the name of the database that you defined in step 2b.
- When you define a database adapter operation in a map rule through the GET, PUT, or DBLOOKUP functions, you can reference the WebSphere Transformation Extender ODBC connection with the following command line options:
- When you use an MDQ file:
- -MDQ <mdq file>
<mdq file> is the name of the file that you used in step 1.
- -DBNAME<db name>
<db name> is the name of the database that you defined in step 2b.
a. When you do not use an MDQ file:
- -DBTYPE ODBC
- -SOURCE <data source>
<data source> is the DSN that you used in the "To configure the ODBC DSN" procedure on Windows, and the "To configure the odbc.ini file to define the ODBC DSN" procedure on UNIX.
Installation error: uncompress not found
The WebSphere Transformation Extender installation programs for UNIX operating systems rely on the UNIX "uncompress" program. The "uncompress" program might not be available in some Linux installations. If you encounter the installation error "uncompress: not found," install the "uncompress" program.
Configuring UNIX environment variables
The environment variables required to execute a WebSphere Transformation Extender map or system must be set prior to execution.
You can set the environment variables (PATH, DTX_TMP_DIR, DTX_HOME_DIR, and the appropriate library path variable for your platform) by running the setup program.
After you log on to your computer, execute the setup program in the WebSphere Transformation Extender installation directory before executing a map or system file (using the Launcher). This sets the required environment variables for this session only. Modify the .profile script to set the environment variables for all sessions.
Note: The following command procedure assumes that your UNIX command line environment is the Korn (ksh) shell.
Execute the command as follows:
. / install_dir/setup
where install_dir is the directory where you installed the WebSphere Transformation Extender products.
Note: There must be a space between the initial period (.) and the command path.
Soft DATA Segment or Heap Size on UNIX systems
Using the default setting for the Soft DATA segment or heap size parameter can cause problems on UNIX platforms. The root user must reset the Soft DATA Segment value to a value larger than the default.
Note: On AIX platforms, use IBM's smit (System Management Interface Tool) utility to reset the Soft DATA Segment value.
Set this value one time for each user (not for each session). Choosing the correct value depends on the following factors:
- Amount of memory available on the machine
- Size of data being processed
- Type of processing occurring on the respective data
- Other major applications that run on the machine
If memory permits, start with the default value and increase it as needed. Use the following command to test the value by temporarily setting the value within your own environment:
ulimit -d <value>
Note: When setting the Soft DATA Segment value, the change takes effect only for the current session.
Required IBM XL C/C++ Runtime Package Maintenance Level
If you are currently using either the 220.127.116.11 or 18.104.22.168 maintenance levels of the IBM XL C/C++ runtime environment component for AIX 5 (xlC.aix50.rte runtime package), you must install maintenance level 22.214.171.124 or later to use the WebSphere Transformation Extender software on AIX platforms.
If you are currently using a maintenance level that is within the 126.96.36.199 through 188.8.131.52 range, or any other level that does not include the fix for AIX APAR IY87291, you must install the AIX APAR fix.
To download the latest maintenance level of xlC.aix50.rte runtime package or the AIX fix for APAR IY87291, contact IBM AIX support.
To use the WebSphere Transformation Extender software on AIX V9.0 operating systems, you must install the required IBM XL C/C++ runtime package maintenance level 184.108.40.206 or later. To download the PTF, go to http://www.ibm.com/support/entry/portal/Downloads/Software/Rational/XL_C~C++_for_AIX.
Running the maxdata script on AIX platforms
The maxdata script is provided to increase the maximum values for memory availability on your AIX system. Run the maxdata script prior to executing any WebSphere Transformation Extender maps. The script requires a 777 permission level. Run the script only once for each executable and run it on the executable(s) whenever the executable gets updated or replaced during the installation of a patch or update.
HP-UX product requirements
To run the Launcher on HP-UX platform, use the following settings for max_thread_proc and maxdsiz:
|Kernel Parameters||Default Value||Increase To|
|max_thread_proc||64 processes||512 processes|
|maxdsiz||64 MBytes||<user dependent>|
The value of maxdsiz depends on the amount of available memory and the size of the data used in the maps being run. The default of 64 MBytes is typically not enough. If memory permits, set maxdsiz to 512 MBytes for large data.
Patch requirement for Red Hat Enterprise Linux on IBM z systems
On computers that run on Red Hat® Enterprise Linux on IBM z systems, you must install the RHEL 5 Server Update 4. Without this update, the Management Console and Launcher Administration trigger a Java exception error.
Recommended patches for Java-based adapters
To use any of the following Java-based adapters, install the patches recommended for your HP-UX version and Quality Pack:
- CORBA Adapter
- Java Class Adapter
- Java Message Service (JMS) Adapter
- JNDI Adapter
To obtain the patches, go to the Hewlett-Packard web site http://www.hp.com/products1/unix/java/java2/sdkrte14/downloads/index_pa-risc.html
On HP-UX version 11.11 systems, the PHSS_28871 patch is required to run any of the Java-based adapters listed above.
Configuring Java-based adapters
To configure the Java-based adapters, you modify the CLASSPATH environment variable, either directly or by adding the JAR file entries to the [External Jar Files] section of the dtx.ini file. For example:
[External Jar Files]
Note: N represents the next available number if multiple jar entries exist.
[External Jar Files]
Note: Environment variables cannot be used in these entries.
1. (This step is not required for AIX and HP-UX platforms.) Install Java™ 2 SDK, Enterprise Edition (J2EE™) v1.6.0 and set environmental variable J2EE_HOME to point to the installed directory. Update the CLASSPATH environment variable as described below.
|Platform||CLASSPATH Environment Variable|
2. The IBM version of Java™ 2 Runtime Environment, Standard Edition v1.6.0 is provided with this release. Make sure the environment variable JAVAHOME points to the installed location of this version of the JRE, and that the CLASSPATH environment variable includes:
3. For Windows platforms only: Set the PATH environment variable to include the following:
Where install_dir is the directory where you installed the WebSphere Transformation Extender products.
4. For UNIX systems only: Ensure that the client-side LIBPATH environment variable contains a reference to the directory where Java 2 JRE is installed. This is the directory where the libjvm.s* and libjava.* files are located. For example:
|Platform||Library Path Environment Variable|
(SHLIB_PATH should point to the hotspot subdirectory instead of classic.)
Follow any provider-specific installation and setup instructions.
SNMP Adapter and SNMP Agent software requirements
The WebSphere Transformation Extender SNMP Collection is no longer a separate product installation. The SNMP Adapter is automatically included with all base editions of WebSphere Transformation Extender version 220.127.116.11. The SNMP Agent is an optionally installed component of WebSphere Transformation Extender with Launcher.
To use the SNMP Adapter or the SNMP Agent, you must install the Java™ Dynamic Management Kit (JDMK) runtime module available from Project OpenDMK.
1. An existing jdmkrt.jar file from a previous installation of the SNMP Collection prevents the version 18.104.22.168 SNMP Adapter or SNMP Agent from working. Remove any existing jdmkrt.jar file:
- On Windows systems, from the WTX installation directory.
- On UNIX systems, from the /libs subdirectory.
3. Add the jdmkrt.jar file to the CLASSPATH as described in the Configuring Java-based adapters topic of the Resource Adapters overview.
To use the SNMP adapter from the Design Studio, add the jdmkrt.jar file to the dtx.ini file, as described in the Configuring Java-based adapters topic.
Installing CICS Adapter when WebSphere Transformation Extender for Application Programming is not installed
Use this procedure to install the required CICS server-side components when WebSphere Transformation Extender for Application Programming is not installed on a z/OS system. This procedure is not required on a system where WebSphere Transformation Extender for Application Programming is installed.
The CICS adapter requires the cicssrvr.loadlib file that is shipped with WebSphere Transformation Extender and is located in the installation directory. The cicssrvr.loadlib file includes server-side components required to use the CICS adapter to connect to CICS.
To install the cicssrvr.loadlib file:
1) Transfer the cicssrvr.loadlib file in binary mode from the
installation directory on your computer to a z/OS data set with
80-byte fixed-length records (RECFM=FB, LRECL=80,
This means no ASCII-to-EBCDIC translation and no
elimination of carriage-return or line-feed characters.
2) After you have installed the file on z/OS, issue the TSO
RECEIVE command to create a load library from it. At the
"READY" prompt, type the following:
The following messages are displayed:
INMR901I Dataset MY.UPLOAD from USER on NODENAME
INMR906A Enter restore parameters or 'DELETE' or 'END' +
3) Type the name of the load library to be created as follows:
Messages are displayed, indicating that the load library is being created.
4) Define the programs to the CICS region that will be
running the CICS Adapter server-side components.
The programs can be defined to CICS by adding the following
statements to the CICS CSD definitions. To update the CSD, use
either the DFHCSDUP CICS batch utility program or use the CEDA
transaction and use the following statements as an example:
DESCRIPTION(3270 BRIDGE EXIT)
5) Add the cicssrvr load library to the DFHRPL concatenation
for the CICS region that will be running the CICS adapter
JCA Gateway Adapter
This version of the J2EE Connector Architecture (JCA) Gateway adapter consists of two installation components: client-side and server-side. The client-side is the machine upon which the WebSphere Transformation Extender product is installed and running. The server-side is the application server.
WebSphere Transformation Extender must be installed before installing the JCA Gateway adapter on the client-side machine.
A J2EE-compliant application server that supports the EJB 2.0 and JCA 1.0 specifications is required.
The following indicates the supported JNDI drivers for use with the JNDI Adapter:
- COS Naming service provider, 1.2.1 release
- DNS Service Provider, 1.2 release
- File system service provider, 1.2 beta 3 release
- LDAP service provider, 1.2.4 release
- RMI registry service provider, 1.2.1 release
The MIME adapter requires the j2ee.jar and mail.jar files, or equivalent jar files that contain the J2EE and "javax.mail" classes. These modules are not shipped with WebSphere Transformation Extender. After installing the jar files from an appropriate j2ee installation, modify the CLASSPATH to include the modules.
WebSphere Transformation Extender supports the S/MIME adapter on Windows and 32-bit non-Windows operating systems. However, it does not support the adapter on HP Itanium operating systems.
If you use the S/MIME adapter on a supported non-Windows operating system, set the SMIMEDIR environment variable and specify a valid path for your environment. For example, set the path as:
CMD: export SMIMEDIR=/sol10t2000home/qalocal/automation/inst32/83SMIME
Oracle and Oracle AQ Adapters
This release supports Oracle database and Oracle AQ versions 10g and 11g.
Support for Oracle databases does not include support for the Oracle Exadata platform.
The m4ora.dll and libm4ora.so module support both version 10g and version 11g Oracle clients.
Sybase 15 Adapter
Sybase database versions 12.5 and 15 are supported in this release. The Sybase database adapter library file for version 12.5 is installed by default and is referred to as the "base" product. However, both version 12.5 and 15 libraries are provided in the product installation directory.
To use version 15, rename the version 15 library file (for example, m4sybs15.dll) to the "base" library file name (for example, m4sybs.dll).
Sybase database adapter "base" library files:
- m4sybs.dll (Windows)
- libm4sybs.so(.sl) (UNIX)
After the installation process completes, use the following platform-specific instructions to rename a "versioned" library file (version 15 in this case) to the base library file.
- Change the directory to install_dir/libs.
- Make a copy of libm4sybs.so(.sl) for "backup" purposes.
- Rename libm4sybs15.so(.sl) to libm4sybs.so(.sl).
To revert back to version 12.5, you can repeat the same process using the additional version 12.5 library that was installed with the product. For example, rename libm4sybs12.so(.sl) to libm4sybs.so(.sl).
- Go to the product installation directory.
- Make a copy of m4sybs.dll for "backup" purposes.
- Rename m4sybs15.dll to m4sybs.dll.
To revert back to version 12.5, you can repeat the same process using the additional version 12.5 library that was installed with the product. For example, rename m4sybs12.dll to m4sybs.dll.
3. UPGRADE AND MIGRATION INFORMATION
- Maps, type trees, and systems from versions 5.0 and later can be used with 8.3. You must regenerate systems. Although it is not always required for running maps from an earlier version, you should reanalyze and save the type trees, and save and recompile the maps; otherwise, the processes must convert the files each time they load the files.
- If you are migrating from 8.0 to 8.3, you must run your database triggering scripts in order to successfully run source-triggered database systems. After version 8.3 is installed on the supported Oracle or SQL Server databases, no earlier release of WebSphere Transformation Extender can use triggering on that database, because the client and source reference different names.
- To use the new code page functionality, you must make new selections for the Data Language and National Language type properties in your type trees.
- If you previously used a non-international version of WebSphere Transformation Extender (formerly DataStage TX or Mercator), Native has been redefined to be Latin1 instead of ASCII.
- During installation, if you are prompted to register this version as the default program for opening WebSphere Transformation Extender file types and you choose "Yes," all WebSphere Transformation Extender files, such as *.mtt or *.mms, open with this version (8.3).
- When you use the dsmapconv command (Map Migration utility) to convert a map from WebSphere Transformation Extender version 6.7.1 to WebSphere Transformation Extender version 8.3, after the type tree has converted successfully, some of the input map rules might not be able to be converted, and will cause the dsmapconv map conversion process to fail. You can view the results in the dsmapconv log file.
If the dsmapconv map conversion process fails because some map rules were unable to be converted, use Map Designer to complete the conversion process:
- Open the map.
- Delete the unresolved rules.
- Compile and rerun the map.
Opening Files from an earlier version
When a source file from an earlier version of a WebSphere Transformation Extender product component is saved in the current version, the content and structure of that file is automatically converted to the format for the current version.
After conversion to the current version formats, do not open these files in earlier versions of a WebSphere Transformation Extender product component. After conversion, the format of the map source has changed and there are added features that are not supported in the earlier versions.
- *.mtt files are converted in memory when the file is opened. The backup *.omt file is created when the file is saved.
- *.mms files do not need to be converted for the current version.
- A map created in an earlier version opens in the current version.
- *.msl files do not need to be regenerated. They are converted dynamically.
- *.mmc files do not need to be recompiled.
- *.msd files still work the same way, creating an *.osd when the file is opened.
- *.mdq files open in the current version.
Preparing maps to run in this version
- Analyze each type tree file for logic and structure and then save it in the current version of the Type Designer.
- Regenerate type trees for queries, tables, and stored procedures.
- For maps that will be executed using a current version of the Command Server or Launcher, build all maps using the equivalent (current) version of the Map Designer.
- Build and generate the Launcher system (.msl) file or the command file for all systems defined in the current version of the Integration Flow Designer.
- Change any script file that uses the unsupported "lci -start" and "lci -stop" features to start and stop the UNIX Launchers to the supported commands, as follows:
Unsupported Command Supported Command lci -start launcher.sh -start lci -stop launcher.sh -stop <listen_port>
Where <listen_port> is the number of the first designated listening port in the range specified in the LauncherAdmin.bin file. The default value is "5015" and it is not required for the -start option. However, if it is provided, it must match the first listening port specified in the LauncherAdmin.bin file.
- If you have designed maps that could produce 0 bytes of data to an adapter (this is especially critical for R/3 adapters), you must change the OnSuccess setting to CreateOnContent or use the -XO adapter option.
- When you open a map that references a custom adapter or an adapter that is no longer supported in version 8.3, the Source or Target in the Edit Card dialog is blank. The map builds successfully, but returns a "Source not available" or "Target not available" message when it executes. The solution is to select an adapter from the list in the Edit Card dialog.
Converting type trees generated in earlier versions
You can invoke the dsxmlconv utility command from the command line to convert type trees that were generated in WebSphere Transformation Extender versions earlier than V8.0.
Performance of maps
If you are migrating from an earlier version, you should be aware of the relative performance of running maps in this version.
4. KNOWN LIMITATIONS, PROBLEMS, AND WORKAROUNDS
For the latest documentation updates and for information about known problems and workarounds in Version 8.3, go to http://www.ibm.com/support/docview.wss?&uid=swg21413038.
5. NEW AND CHANGED BEHAVIOR
New platform support
All WebSphere Transformation Extender components are supported on 32-bit and 64-bit Itanium operating systems.
Removed platform support
WebSphere Transformation Extender Version 8.3 is not supported on HP-UX on PA-RISC systems.
Deprecated components and functions
Use the following functions rather than the deprecated functions to develop new solution implementations using WebSphere Transformation Extender Version 8.3. Plan to update existing solution implementations of WebSphere Transformation Extender that use the deprecated functions, as follows:
|Deprecated Function||Use This Function|
|Base64 adapter||Base64 functions|
|FS Manager adapter||None identified|
|Quoted Printable adapter||Quoted functions|
|XML importer||Native schema|
Removed components and functions
The following components and functions were deprecated in earlier releases and are not included in Version 8.3:
- EJB API
- FHL adapter
- JCA Gateway/Connector
- QualityStage adapter and importer
- Siebel adapters, importers and Pack
- PeopleSoft adapters, importers and Pack
Mapping data objects from one output card to another
In previous versions of the WebSphere Transformation Extender Map Designer, to map data objects from one output card to another output card, you could press the ALT key and drag the object into the new destination. The WebSphere Transformation Extender 8.3 Design Studio supports the drag-and-drop method of mapping objects from one output card to another. When mapping between very large output cards, an alternate method can be more effective. Select the source field and copy the data using the Copy menu item or CTRL+C, and then select the target field and paste the data using the Paste menu item or
Improved error message for missing XML schema
At runtime, a missing schema generates the error message "XML Parser: Invalid metadata location" when the schema is used as a type tree or as type-tree metadata, or when the schema is referenced from another schema that is being used. In WebSphere Transformation Extender version 22.214.171.124, the message is displayed in the map status message and logged in the audit log, as well as being logged in the trace log and the XML error log.
Example files installation
The WebSphere Transformation Extender Design Studio product no longer includes example files in the Typical installation, but instead, it includes them in the Custom installation. See Installing the example files.
SNMP Agent tracing
When you run the SNMP Agent on UNIX operating systems with tracing enabled, log information about the Launcher and associated map events is not only output to a file, but also output to the standard output console.
To disable the logging of messages to the output console, modify the logging.properties file in the following way:
- Open the logging.properties file, which is located under the java/lib subdirectory of the path where WebSphere Transformation Extender is installed.
- Set the following entry to OFF and then save the file:
java.util.logging.ConsoleHandler.level = OFF
When you run the SNMP Agent with the java.util.logging.ConsoleHandler.level set to OFF, the log information is no longer output to the console screen; it is only output to the log file.
6. RESOLVED AUTHORIZED PROGRAM ANALYSIS REPORTS (APARs)
For a list of APARs that are resolved in Version 126.96.36.199, go to http://www.ibm.com/support/docview.wss?&uid=swg27021445.
7. COMMAND SERVER NOTES
These notes are for the Command Server component of the following products:
- IBM WebSphere Transformation Extender with Command Server
- IBM WebSphere Transformation Extender with Launcher
- IBM WebSphere Transformation Extender Design Studio
Because procedures for Command Servers for Windows, HP-UX, RS/6000 AIX, and Solaris platforms might differ slightly, the installation program provides specific instructions to guide you.
The Command Servers for Microsoft Windows are components of the client installation and are installed with the IBM WebSphere Transformation Extender with Command Server and IBM WebSphere Transformation Extender with Launcher. These Command Servers are also available as components of the Command Server installation for Windows-based platforms to be installed on your server for run-time purposes.
With IBM WebSphere Transformation Extender Design Studio, you can use the Map Designer to run maps at design time.
The HP-UX, RS/6000 AIX, and Solaris Command Servers are components of each platform-specific Command Server server installation for run-time purposes.
The additional Command Servers for z/OS (Batch and CICS) are available on platform-specific media. For system requirements and installation procedures for these Command Servers, see the platform-specific readme, release notes, and the Program Directory.
Additional UNIX Run-Time Information
You must manually set the shared library path according to your platform.
Do not execute the setup program if you want to configure the environment variables manually. Instead, follow the procedure in Set Location for Temporary Files (DTX_TMP_DIR).
Set Location for Temporary Files (DTX_TMP_DIR)
During map execution, the Command Server creates temporary files for resource handling and for retaining debug information. The default directory for these temporary files is /tmp. To specify a different directory where for temporary files, set the DTX_TMP_DIR environment variable. For example:
If multiple users or groups are to access the Command Server engine, define a DTX_TMP_DIR instead of using the default /tmp directory. Define and export the DTX_TMP_DIR variable manually or with the setup script. The directory specified for DTX_TMP_DIR must have permission 777 to provide permission to the user, the group, and all others. Define and export the DTX_TMP_DIR variable before you set the directory permission. To set the permission, run the chmod command:
chmod 777 $DTX_TMP_DIR
Enabling Environmental Debug Information (DTX_DEBUG)
When the DTX_DEBUG environment variable is defined, the Command Server can produce environmental diagnostic information that can be helpful when a problem is encountered during map execution. By default, the DTX_DEBUG environment variable is not defined and environmental debug information is not recorded.
When you define the DTX_DEBUG environment variable, environmental debug information is recorded in a file named dtxinfo.log located in the directory defined by the DTX_TMP_DIR environment variable (or in the /tmp directory, if DTX_TMP_DIR is not defined).
To enable the environmental debug facility, set the DTX_DEBUG environment variable to TRUE. For example:
To disable the environmental debug facility, set the DTX_DEBUG environment variable to FALSE. For example:
The following is a sample of the information contained in the environmental debug file:
PROCESS_ID: 2309, API_REF: 1
Date/Time: Fri Jul 25 14:30:09.279783 2003
FILE: mercmain.c, line: 714
info: [IBM WebSphere Transformation Extender Product
PROCESS_ID: 2309, API_REF: 1
Date/Time: Fri Jul 25 14:30:09.280252 2003
FILE: mercmain.c, line: 744
info: [IBM WebSphere Transformation Extender RUNNING:
Fri Jul 25 14:30:09 2003]
PROCESS_ID: 2309, API_REF: 1
Date/Time: Fri Jul 25 14:30:09.470357 2003
FILE: mercrun.c, line: 1951
New Map File - Fri Jul 25 14:30:09 2003
Setting Shared Libraries Environment Variables
After you have installed mapping components on UNIX platforms, set the appropriate shared object path environment variable to access the shared libraries. This procedure varies slightly depending on the platform being used.
For example, to set this variable for an IBM RS/6000 AIX platform, enter the following:
Note: Because the RS/6000 AIX platform caches shared libraries, if you update a shared library on the disk, you will not be able to see the update. Use the slibclean command as the root user to remove the old shared library from system memory.
To set this variable for an HP-UX platform, enter the following:
To set this variable for Solaris platform, enter the following:
Note: In these examples, install_dir/libs is the directory where the shared libraries are located.
8. SOFTWARE DEVELOPMENT KIT NOTES
In version 8.3, the Software Development Kit is packaged with the Design Studio. When installing Design Studio, select Custom Install to install the Software Development Kit components.
Any base version of WebSphere Transformation Extender can be used as the runtime environment with the Software Development Kit:
- WebSphere Transformation Extender for Application Programming
- WebSphere Transformation Extender with Command Server
- WebSphere Transformation Extender for Integration Servers
- WebSphere Transformation Extender with Launcher
Online Library Installation
Software Development Kit documentation links to the Online Library and the Resource Adapters Library are dependent on the installation of the Online Library.
IBM WebSphere Transformation Extender for Application Programming
Programming Interface Product Requirements
The IBM WebSphere Transformation Extender Programming Interface consists of C, C#, COM, CORBA, Java, and RMI APIs.
The required header files, library files, and IDLs for these APIs are located in the following directories:
|Files||Windows Directory||UNIX Directory|
Linking an application to an alternate ICU library version
This release of WebSphere Transformation Extender uses ICU version 3.2.
A WebSphere Transformation Extender Application Programming Interface (API) user can link an application to a version of ICU other than ICU V3.2 by including the ICU version's lib names in the link line.
For example, to link your application to ICU V3.4.1, use the following link line:
-licuuc341 licuuc18n341 licudata341
If you do not want to specify the version numbers in the link line, the ICU team recommends that you start the icu-config script from the $(ICU_INSTALL)/bin/ directory.
To start the icu-config script, include the following code in your makefile:
If you are using ICU V3.4.1, the icu-config script returns the following required link lines:
-licui18n341 -licuuc341 -licudata341
9. LAUNCHER STUDIO NOTES
These notes are for the Launcher Administration, Management Console, and Resource Registry components of the IBM WebSphere Transformation Extender Launcher Studio product.
This section contains the following topics:
- Configuration requirements
- Display Errors
To use these products in a non-Windows environments, the X Window server must be running on the local host machine or system. You must set the DISPLAY environment variable and export it.
The DISPLAY environment variable identifies the X Window server that is to display the X Window WTX GUI client. The syntax might vary depending on the shell version that you are using. To set the DISPLAY environment variable:
- The DISPLAY environment variable name must be in uppercase letters.
- The display_name is the IP address or domain name of the local host machine that is to display the X Window WTX GUI client application.
- server_display is the number assigned to the X Window server that is to display on the host machine.
Because most local host machines have a maximum of one display monitor, keyboard, and mouse, in most cases, you specify the server_display as :0, and omit the screen_number .
If your system has more than one monitor (display screen) as in multi-headed systems, each monitor is identified by a unique screen number. You specify the screen_number by appending it to the end of the X server_display specification, for example, :0.1. The default screen_number is 0, which refers to the primary screen, and when it is 0, you do not need to specify it; for example, you can specify only the server_display simply as :0.
- mycomputer.ibm.com is the domain name of the local host that is to display the X Window WTX GUI client application.
- 0 is the value for the server_display that is assigned to the DISPLAY environment variable.
The host system exports the value to the X Window client so that it will display the X Window WTX GUI client application on the primary screen of the computer with the mycomputer.ibm.com domain name through the X server assigned as 0.
- 192.168.1.110 is the IP address of the local host that is to display the X Window WTX GUI client application.
- 0 is the value for the server_display that is assigned to the DISPLAY environment variable.
The host system exports the value to the X Window client so that it will display the X Window WTX GUI client application on the primary screen of the computer with the 192.168.1.110 IP address through the X server assigned as 0.
To avoid display errors related to font.properties when starting the Launcher Administration, Management Console, or Resource Registry, ensure that the display X server has access to all fonts used in the font.properties of the Java installation.
On Solaris JVMs, the font.properties consistently refer to fonts that are not included with Exceed. This can sometimes cause problems such as distortions when displaying GUIs. To resolve this problem, a customized font.properties can be placed in your $HOME/lib directory, which will remove references to the problem fonts.
10. CONTACTING CUSTOMER SUPPORT
Contact Customer Support at 1-800-IBM-SERV, or go to the support portal.
11. NOTICES AND TRADEMARKS
This information was developed for products and services offered in
IBM may not offer the products, services, or features discussed in
this document in other countries. Consult your local IBM
representative for information on the products and services currently
available in your area. Any reference to an IBM product, program, or
service is not intended to state or imply that only that IBM product,
program, or service may be used. Any functionally equivalent product,
program, or service that does not infringe any IBM intellectual
property right may be used instead. However, it is the user's
responsibility to evaluate and verify the operation of any non-IBM
product, program, or service.
IBM may have patents or pending patent applications covering subject
matter described in this document. The furnishing of this document
does not grant you any license to these patents. You can send license
inquiries, in writing, to:
IBM Director of Licensing
North Castle Drive
Armonk, NY 10504-1785
For license inquiries regarding double-byte (DBCS) information,
contact the IBM Intellectual Property Department in your country or
send inquiries, in writing, to:
IBM World Trade Asia Corporation Licensing
2-31 Roppongi 3-chome, Minato-ku
Tokyo 106-0032, Japan
The following paragraph does not apply to the United Kingdom or any
other country where such provisions are inconsistent with local law:
INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE
Some states do not allow disclaimer of express or implied warranties
in certain transactions, therefore, this statement may not apply to you.
This information could include technical inaccuracies or
typographical errors. Changes are periodically made to the
information herein; these changes will be incorporated in new
editions of the publication. IBM may make improvements and/or
changes in the product(s) and/or the program(s) described in this
publication at any time without notice.
Any references in this information to non-IBM web sites are provided
for convenience only and do not in any manner serve as an endorsement
of those web sites. The materials at those web sites are not part of
the materials for this IBM product and use of those web sites is at
your own risk.
IBM may use or distribute any of the information you supply in any
way it believes appropriate without incurring any obligation to you.
Licensees of this program who wish to have information about it for
the purpose of enabling: (i) the exchange of information between
independently created programs and other programs (including this
one) and (ii) the mutual use of the information which has been
exchanged, should contact:
577 Airport Blvd., Suite 800
Burlingame, CA 94010
Such information may be available, subject to appropriate terms and
conditions, including in some cases, payment of a fee.
The licensed program described in this document and all licensed
material available for it are provided by IBM under terms of the IBM
Customer Agreement, IBM International Program License Agreement or
any equivalent agreement between us.
Any performance data contained herein was determined in a controlled
environment. Therefore, the results obtained in other operating
environments may vary significantly. Some measurements may have been
made on development-level systems and there is no guarantee that
these measurements will be the same on generally available systems.
Furthermore, some measurements may have been estimated through
extrapolation. Actual results may vary. Users of this document should
verify the applicable data for their specific environment.
Information concerning non-IBM products was obtained from the
suppliers of those products, their published announcements or other
publicly available sources. IBM has not tested those products and
cannot confirm the accuracy of performance, compatibility or any
other claims related to non-IBM products. Questions on the
capabilities of non-IBM products should be addressed to the suppliers
of those products.
All statements regarding IBM's future direction or intent are subject
to change or withdrawal without notice, a nd represent goals and
This information contains examples of data and reports used in daily
business operations. To illustrate them as completely as possible,
the examples include the names of individuals, companies, brands, and
products. All of these names are fictitious and any similarity to the
names and addresses used by an actual business enterprise is entirely
This information contains sample application programs in source
language, which illustrate programming techniques on various
operating platforms. You may copy, modify, and distribute these
sample programs in any form without payment to IBM, for the purposes
of developing, using, marketing or distributing application programs
conforming to the application programming interface for the operating
platform for which the sample programs are written. These examples
have not been thoroughly tested under all conditions. IBM, therefore,
cannot guarantee or imply reliability, serviceability, or function
of these programs.
If you are viewing this information softcopy, the photographs and
color illustrations may not appear.
Programming interface information
Programming interface information, if provided, is intended to help
you create application software using this program.
General-use programming interfaces allow you to write application
software that obtain the services of this program's tools.
However, this information may also contain diagnosis, modification,
and tuning information. Diagnosis, modification and tuning
information is provided to help you debug your application software.
Warning: Do not use this diagnosis, modification, and tuning
information as a programming interface because it is subject to
Trademarks and service marks
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
- Adobe, the Adobe logo, PostScript, and the PostScript logo are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, and/or other countries.
- IT Infrastructure Library is a registered trademark of the Central Computer and Telecommunications Agency which is now part of the Office of Government Commerce
- Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
- Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.
- Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.
- ITIL is a registered trademark, and a registered community trademark of the Office of Government Commerce, and is registered in the U.S. Patent and Trademark Office
- UNIX is a registered trademark of The Open Group in the United States and other countries.
- Cell Broadband Engine is a trademark of Sony Computer Entertainment, Inc. in the United States, other countries, or both and is used under license therefrom.
- Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.
- Oracle and all Oracle-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.
Other product and service names might be trademarks of IBM or other companies.
This product includes software developed by the Eclipse Project