Product Readmes
Abstract
Certain APAR fixes require post-installation steps to use the fixes. The following tables list only those fixes. For the complete list of fixes, refer to the links in the Related Information section at the end of this document.
Content
| Information Server, Version 8.7 Fix Pack 2 | |||
| After you install a fix pack, review the following table to find fixes that impact your jobs. If you find an applicable fix, follow the instructions to use that fix in your jobs. | |||
| Connectivity | |||
Fix ID | What this fix does | Instructions | More details |
| For Connector jobs of Timestamp data: Adds the environment variable CC_SE_TIMESTAMP_FF to handle microseconds of Timestamp data correctly. | To handle microseconds of Timestamp data correctly: Add the environment variable CC_SE_TIMESTAMP_FF and set the value to MICROSECONDS You can set other values for the environment variable. Refer to the text file in the "More details" column. | ||
| For FTP Enterprise stage: Sets the environment variable APT_PFTP_SSH_SERVER for support of SUN SFTP Server on Solaris platform. | To provide the support of SUN SFTP Server on Solaris platform: Add the environment variable, APT_PFTP_SSH_SERVER and set the value to SUNSSH. | ||
| For the DataStage repository: Runs a repair tool to delete the duplicate Connector objects found, so that Fix Pack installation finishes successfully. | To delete the duplicate Connector objects: Run a new utility that corrects the repository Connector objects before running the Fix Pack Installation. | ||
| For the ODBC Connector jobs: Sets the environment variable to avoid the crashing of jobs while using the new driver manager of v127/U0090 or more in the SQLGetDiagRec API. | To avoid the crashing of ODBC Connector jobs on UNIX platform: Set the CC_ODBC_USE_NEW_DRIVER_MANAGER environment variable to 1. | ||
| For the interpretation of empty values in FTP plugin: Adds the environmental variable DSFTP_EMPTY_IS_NULL to consider the empty values as NULL. | To avoid the interpretation of empty values in FTP plugin between DataStage releases: Set the DSFTP_EMPTY_IS_NULL environment variable to 1 | ||
| For the imported metadata: Sets the environment variable to omit the prefix and position tags to the imported metadata. | To omit the prefix and position tags to the imported metadata: Add and set the APT_ODBC_MDI_NO_PREFIX_POSITION environment variable. | ||
| For BTET mode in Teradata plugin: Implements the BTET_MODE environment variable by adding it in Datastage administrator. | To make Teradata plugin to use the BTET mode in transaction semantics: Set the BTET_MODE environment variable to True. | ||
| InfoSphere DataStage Core | |||
Fix ID | What this fix does | Instructions | More details |
| For the istool ODBAdmin commands: Adds the authfile support to the countdb and purgedb commands. | To extend the functionality of the istool ODBAdmin countdb command by adding the authfile support: istool ODBAdmin countdb -domain D -authfile af.txt -server S -all Refer to the text file in the "More details" column to use the purgedb command with the authfile support. | ||
| For the EngMonApp error: Requires an update to the operations database schema, where the storage type of XMLTYPE columns must be modified. | If you already have a DSODB database set up for Operations Console, you must update the schema to match the latest specification. For more information, refer to the text file in the "More details" column. | ||
| For the execute command: Resolves an issue introduced by security enhancements. | The fix comprises both server and client changes. The server side fix must be applied. The client side fix is optional, but the fix will not be effective. With only the server fix applied jobs will revert to the functionality prior to the introduction of the obfuscation code. That is, the encrypted strings will appear as is in the job log. If only the client fix is applied sequences with Command Activity stages will no longer run after compilation as they will call a non-existent routine on the server. | ||
| For explicit partitioning for binary keys: Allows a column of Binary type to be selected as a key field when choosing the Hash partitioning type. | When selecting the Hash partitioning type, set the column type to Binary. | ||
| InfoSphere DataStage Engine | |||
Fix ID | What this fix does | Instructions | More details |
| Provides a new version of the DataStage Server Engine startup/shutdown script. | This fix pack will lay down a new version of the DataStage Server Engine startup/shutdown script. The fix pack install will automatically update the INSTANCETAG and DSHOME values in ds.rc. Any changes made to the script by the user will need to be integrated manually after applying the fix pack. The previous version of the script will be saved in <IIS path>/Server/DSEngine/sample/ds.rc.preJR40394. If changes to ds.rc were required to allow the script to work in the user's environment, application of the new version can be bypassed with the creation of the file called ds.rc.preJR40394. | ||
| For performance issue on AIX when semop() and semclr() are used: Uses the internal code for semaphore operations on AIX. | The semaphore array is no longer used; that is, ipcs -s will no longer display 0xadec8700. | ||
| For dsjob -wait behavior: The behaviour of dsjob -wait or -jobstatus is changed when the Inactivity timeout is reached. | To revert to the original behaviour: Set the environment variable, DSE_SLAVE_CLOSE_SOCKET_ON_EXEC to 1 in $DSHOME/dsenv Refer to the text file in the "More details" column for further details. | ||
| InfoSphere Information Server Framework (ISF) | |||
Fix ID | What this fix does | Instructions | More details |
| For security vulnerabilities in IS web console: Enable security integration in the WebSphere session management settings and addresses the various security vulnerabilities in the Information Server Web Console. | To enable security integration in the WebSphere session management settings:
| ||
| For Web UI Autocomplete security vulnerability: Prevents saving of passwords in various Information Server Web Console screens. | To prevent saving of password: Install the fix pack. If passwords had been previously saved in the Browser before installation of this patch. Clear the saved password and form history from the browser cache. For more information on clearing saved passwords and form history from the browser. Refer to the text file in the "More details" column. | ||
JR44260 | For securing cookies: Sets the attribute so that the cookies are only transferred over secure https communication channels using SSL encryption. Sets the attribute so that cookies are not passed to JavaScript running in the browser. | To secure cookies that are only transferred over secure https communication channels using SSL encryption: Set the Secure attribute. To secure cookies so that they are not passed to JavaScript running in the browser: Set the HTTPOnly attribute. For more information on setting attributes. Refer to the text file in the "More details" column. | |
| XML pack | |||
Fix ID | What this fix does | Instructions | More details |
| For Japanese characters: Displays Japanese characters properly while using within the XML Stage. | To display Japanese characters properly while using within the XML Stage: Re-enter the Japanese characters again in the assembly editor of the XML Stage after applying the fix pack. | ||
| For Boolean values: Accepts 0 and 1 as Boolean values by schema library manager. | To accept Boolean values by schema library manager: Re-import the xsd's again after applying the fix pack. | ||
| Information Server, Version 8.7 Fix Pack 1 | |||
| After you install a fix pack, review the following table to find fixes that impact your jobs. If you find an applicable fix, follow the instructions to use that fix in your jobs. | |||
| Connectivity | |||
Fix ID | What this fix does | Instructions | More details |
| For Teradata Multiload stage: Removes the AXSMOD np_axsmod.so directive from the control file. | To remove the AXSMOD np_axsmod.so directive: Set the checkpoint option to 0. Set the DS_TDM_NO_NPAXSMOD environment variable. | ||
| For IWAY Enterprise stage: Marks the query as pass through to DB2 to support non ANSI SQL syntax like REPLACE function. | To enable the query as pass through to DB2:
| ||
| InfoSphere DataStage | |||
Fix ID | What this fix does | Instructions | More details |
| Explains manual step that must be performed before the patch is usable. | Follow the instructions described in the readme.txt file in the path Server/DSODB/scripts/{database}/readme.txt where {database} is the database type for the DSODB database. For example: Server/DSODB/scripts/DB2_LUW_9_7/readme.txt. Step A in the readme.txt must always be followed even if a DSODB database already exists, as this step generates the scripts to either create a new database to include these additions, or to add the required schema additions to an existing DSODB database. When running Step A, the 'upgrade' option needs to be specified if the DSODB database already exists. If a DSODB database already exists then the other arguments to the command in Step A must be the same as that specified when the DSODB database was created. The actions for Step B are dependant on whether a DSODB database already existed before installing this patch, and are as described in the readme.txt file. If a DSODB database already existed then after running this manual upgrade to the database, the AppWatcher process needs to be restarted. This can be done from the Control Panel services menu or from a command window: net stop "DataStage AppWatcher Service" net start "DataStage AppWatcher Service" Ignore these instructions if the Operations Console Rollup Patch for 8.7 has previously been installed, or if no DSODB database has been created. | ||
| Resolves the crash while re-importing an existing table when using Data Connections to import MetaData. | If you have experienced a problem when importing metadata and saving the table definitions, delete those tables and then re-import. | ||
| Fixes the issue of XMLOutput not maintaining references, thereby showing Impact Analysis results correctly. | Re-load or save the columns to Table Definitions after installing the patch. | ||
| Allows the DSD.OshMonitor startup retry period to be configured via an environment variable, thereby enabling display of Job Monitoring data for GRID job that has been queued for more than 5 minutes. | Set the environment variable OSHMON_INIT_RETRY to an integer value, in seconds, greater than 300. | ||
| Causes the Terminator activity to forcibly shut down parallel jobs. | Specify the number of seconds in the environment variable PXShutdownTimeout. SIGTERM and SIGKILL will be sent, respectively, with the specified gap after sending SIGINT. | ||
| Enhances MCM to exclude EXGRID.DLL from the switching model to prevent issues with other applications. |
| ||
| Deploys the DSHARestart.vbs script for Windows IS installations that are configured for High Availability. | Refer technote 1591193. | ||
| Allows custom update and inserts SQL statements in ODBC stage. | This fix reinstates the default behavior of the ODBC stage as it was originally designed. To use old job designs, set environment variable DSODBC_EXECUTE_MULTI_STMTS_AS_ONE to allow the behavior of e97866. | ||
| Cleans up Agent.pid and LoggingAgent.pid files. | This fix pack lays down updated copies of the sample High Availability scripts, hence ensure that you have taken backups of these scripts if they are customized. | ||
| Parallel engine | |||
Fix ID | What this fix does | Instructions | More details |
| Includes MKS upgrade in the Windows Suite Install version of the Fixpack. | No special user actions are required for a Suite installation as the new MKS toolkit is part of the Suite install. However, it is not part of the Update Installer version of the Fixpack. The new MKS toolkit is available on Fix Central and you can install it before or after installing 8.7 fp1. | ||
| Case conversion functions for charset ASCL_ISO8859-1 converts all characters correctly. Functions affected are uppercase_string(), lowercase_string() of Modify stage and DownCase(), Upcase() of DataStage. | For case conversions of string type: Set APT_TRANSLITERATE_CASE_USES_NLS_MAP for using Job's NLS map for case conversions of string type. If APT_TRANSLITERATE_CASE_USES_NLS_MAP is added in job properties, the job should be recompiled. If APT_TRANSLITERATE_CASE_USES_NLS_MAP is added at project level, no job compilation is required and the variable gets effected to all jobs in the project. | ||
| Adds Hadoop File System (HDFS) support to the sequential file stage for use by the new Big Data File System (BDFS) stage. | The enhancement is included in the Linux 64-bit version of Information Server. Refer Tech Note 1515617 for details on the usage of BDFS stage. | ||
| Ensures a response matches the request for a PX job deployed as an ISD service. | The parallel framework detects the problem and applies one-node constraint to force processing stages to run on one-node configuration. To prevent the parallel framework from applying one-node constraint: Set APT_ONE_NODE_CONSTRAINT=false. This reverts back to the old behavior. | ||
| Ensures multi-valued OR conditions in PX transformers deliver correct data in output and also makes sure that they always compile. | Force compile the jobs that show problems in handling NULL column data. | ||
| XML pack | |||
Fix ID | What this fix does | Instructions | More details |
| Shows all XML schema elements in the library after import. | To show all elements in the library:
| ||
Related Information
[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.7.0.2;8.7.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27024855