A list of significant updates to InfoSphere Information Server Version 8.5 since its initial release.
This document contains short descriptions of product and documentation updates that were added after the initial release of InfoSphere Information Server, Version 8.5.
Table of contents
More information about InfoSphere Information Server, Version 8.5
April 15, 2011: Fix Pack 1 download
Product updates for Version 8.5 Fix Pack 1
Connectivity: Additional stages
InfoSphere Blueprint Director
InfoSphere Business Glossary Client for Eclipse
InfoSphere Business Glossary Anywhere
InfoSphere Information Analyzer
istool command line
Documentation updates for Version 8.5 Fix Pack 1
Connectors: ODBC, DB2, and Oracle
Update Installer: Installing updates and additional products
December 1, 2010
InfoSphere Dynamic Relational Stage Connector
November 30, 2011: InfoSphere Information Server
Fix Pack 2 contains fixes for components of InfoSphere Information Server
List of fixes for InfoSphere Information Server, Version 8.5 Fix Pack 2
Documentation updates for InfoSphere Information Server introduced November 30, 2011
Several tasks were clarified for installing and administering InfoSphere Information Server:
- Certificates and non-root users for WebSphere Application Server
- Metadata repository moving and clustering
- HTTP server for front-end load balancing
- Password restrictions
- SEMMSL for kernel parameters
April 15, 2011 Connectivity: Additional stages
The following stages, which were previously available in separate patches, are now included in Version 8.5, Fix Pack 1:
- CDC Transaction stage
- XML Transformation stage
- DRS Connector stage
April 15, 2011 InfoSphere Blueprint Director
An updated version of InfoSphere Blueprint Director is available with Fix Pack 1. You can obtain and download the product from the Fix Pack 1 download document at http://www.ibm.com/support/docview.wss?uid=swg24029154.
April 15, 2011 InfoSphere Business Glossary Client for Eclipse
An updated version of InfoSphere Business Glossary Client for Eclipse is available with Fix Pack 1. You can obtain and download the product from the Fix Pack 1 download document at http://www.ibm.com/support/docview.wss?uid=swg24029154.
April 15, 2011 InfoSphere Business Glossary Anywhere
An updated version of InfoSphere Business Glossary Anywhere is available with Fix Pack 1. You can obtain and download the product from the Fix Pack 1 download document at http://www.ibm.com/support/docview.wss?uid=swg24029154.
April 15, 2011 InfoSphere DataStage
Viewing job logs
You can view the job log for any open job directly from the InfoSphere DataStage and QualityStage Designer client. Access the log from the Designer client menu bar.
Export and Import job environment variables
You can export environment variables to a file from the InfoSphere DataStage and QualityStage Administrator client. You can use the file to import environment variables from the file to other projects. The imported environment variables can then apply to all jobs within a project. Refer to
April 15, 2011 InfoSphere Information Analyzer
An updated version of InfoSphere Information Analyzer is available with Fix Pack 1. No new features were introduced, but fixes for InfoSphere Information Analyzer are included.
April 15, 2011 InfoSphere QualityStage
China rule sets: Change in folder location
The location of the People's Republic of China rule sets in the repository view of the InfoSphere DataStage and QualityStage Designer client has changed. For the list of predefined rule sets, including the rule sets for People's Republic of China, refer to
Predefined rule sets.
April 15, 2011 istool command line
New istool command option to export creation tool information about common metadata assets
The -creationToolOnly option exports creation tool information about common metadata assets to an ISX file that can be imported into another installation of InfoSphere Information Server.
Creation tool information specifies the bridge or connector that imported the common metadata asset from a third-party tool, database, or file.
When you export a common metadata asset by using the istool command, the creation tool information is not exported for the assets that contain the exported asset. For example, if you export a database table, creation tool information is not exported for the containing host, database, and database schema.
The -creationToolOnly option fixes this problem by exporting creation tool information for all the assets that you specify. You can then import the creation tool assets by using the istool import command with the -cm option. This makes the creation tool information available for previously imported common metadata assets in the target repository.
Documentation of the -creationToolOnly option is provided in this technote: http://www.ibm.com/support/docview.wss?&uid=swg21460637
Documentation updates for connectors introduced April 15, 2011
DB2 connector documentation was updated to improve overall quality and usability.
ODBC connector, DB2 connector, and Oracle connector documentation was updated with miscellaneous changes, including information about additional properties that were added to support the DRS connector.
Documentation updates for InfoSphere DataStage introduced April 15, 2011
Alphabetical list of stages
You can view an alphabetized list of all the stages that are available in InfoSphere Information Server, Version 8.5, as included with the base installation or with add-on installations. Refer to
Documentation updates for using the Update Installer to install updates and additional products introduced April 15, 2011
Tasks were clarified for updating InfoSphere Information Server, Version 8.5, and installing additional products https://www.ibm.com/support/docview.wss?uid=swg27016531.
December 15, 2010 InfoSphere CDC Transaction Stage
You can use the CDC Transaction stage in an IBM InfoSphere DataStage job to read data that is captured by IBM InfoSphere Change Data Capture (InfoSphere CDC) and apply the change data to a target database.
The CDC Transaction stage integrates the replication capabilities that are provided by InfoSphere CDC with the ETL capabilities that are provided by InfoSphere DataStage. You can use these products together to perform real time, continuous replication with guaranteed delivery and transactional integrity in the event of failure.
Documentation updates for CDC Transaction stage introduced December 15, 2010
CDC Transaction stage documentation was introduced December 15, 2010, including:
Online Help in the installed IBM InfoSphere Information Server, Version 8.5, information center, which you can access by using the Help button in the stage editor.
The Internet-accessible IBM InfoSphere Information Server, Version 8.5 information center at http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.conn.cdc.doc/topics/c_cdc_container.html.
The IBM InfoSphere Information Server Connectivity Guide for IBM InfoSphere Change Data Capture, which is named i46decdc.pdf, is available in the CDC Transaction stage patch.
December 1, 2010 InfoSphere Dynamic Relational Stage Connector
The Dynamic Relational Stage Connector can be configured to connect to a variety of relational database management systems through the native database interfaces. The database type is specified through the stage property and a job parameter can be used for this. The DRS Connector supports the following features:
- IBM DB2, Oracle and ODBC database types
- Parallel and server jobs
- Database read, write, and lookup operations
- Manual and auto-generated SQL statements. Manual statements can be specified in the stage directly or in the file on the engine tier
- Creating or truncating a target table before writing data to it
- Array mode of operation
- Control over transaction size and isolation level
- Bulk load write mode (IBM DB2 and Oracle only)
- Record ordering across multiple input links (parallel jobs only)
- Rejecting bad records in combination with the Transformer stage (server jobs only)
- Running custom SQL statements on the database BEFORE any records are processed by the stage
- Running custom SQL statements on the database AFTER all the records were processed by the stage
- Using derivation attributes of the output link columns for auto-generated SELECT statements
- Case-sensitive or case-insensitive handling of the specified table and column names
- Connector Migration Tool was enhanced to support migration of jobs with legacy Dynamic RDBMS stage (DRS plug-in) to jobs with DRS Connector stage
October 22, 2010 InfoSphere DataStage XML Transformation
XML Transformation is used to create powerful hierarchical transformations, as well as parse and compose XML data. XML Transformation provides these capabilities:
Schema Library Manager - You can import XML schemas into the metadata repository and organize schemas into libraries that can be shared across all IBM InfoSphere DataStage projects. For more information, see http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.stages.xml.usage.doc/topics/schemalibrarymanager.html.
Assembly Editor - You can create an assembly, which is a series of steps that perform enrichments and transformations on hierarchical data. For more information, see http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.stages.xml.usage.doc/topics/assemblyeditor.html.
An XML parser and an XML composer - For more information, see http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.stages.xml.usage.doc/topics/xmlparserstep.html and http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.stages.xml.usage.doc/topics/composerstep.html.
Transformation steps - You use the transformation steps to sort, aggregate, regroup, join, and perform other actions on XML data. For more information, see http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.stages.xml.usage.doc/topics/assemblysteps_parent.html.
Test facility - You can test the assembly while it is still in design mode to determine if the XML transformations are working as you expect. For more information, see http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.stages.xml.usage.doc/topics/testinganassembly.html.
Parallel parsing - Processes different parts of an XML document at the same time. For more information, see http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.stages.xml.usage.doc/topics/largescaleparallelparsing.html.
Documentation updates for XML Transformation introduced October 22, 2010
XML Transformation documentation was introduced October 22, 2010, including:
Online Help in the installed IBM InfoSphere Information Server, Version 8.5, information center, which you can access by using the Help button and the question mark icon in the Assembly Editor and Schema Library Manager windows.
The Internet-accessible IBM InfoSphere Information Server, Version 8.5 information center at http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.stages.xml.usage.doc/topics/introduction_to_xml_stage.html.
The IBM InfoSphere DataStage, Version 8.5, XML Transformation Guide, which is named i46dexfm.pdf and available on the client system in the \IBM\InformationServer\Documentation\en_US directory.
The files for the examples that are described in the documentation are available at http://www.ibm.com/support/docview.wss?uid=swg27019894.
- Installation instructions for fix packs
- Release notes for InfoSphere Information Server V8.5
- Information center for InfoSphere Information Server V8.5
- New for InfoSphere Information Server V8.5
- Announcement: IBM InfoSphere Information Server V8.5 including IBM InfoSphere Foundation Tools helps deliver trustworthy information
|Information Management||InfoSphere Business Glossary|
|Information Management||InfoSphere FastTrack|
|Information Management||InfoSphere Information Analyzer|
|Information Management||InfoSphere Metadata Workbench|