Fix List for InfoSphere DataStage 7.5.3, Parallel Engine Rollup Patch JR35216

Fix readme


Fix List for InfoSphere DataStage 7.5.3, Parallel Engine Rollup Patch JR35216


This document contains a summary of fixes included in IBM InfoSphere DataStage, Version 7.5.3 Parallel Engine rollup patch with fixes grouped by component. Please ensure that all of the individual patches you have already installed are on this list prior to installing this rollup patch. If you have a patch that does not appear on this list, please do not install the rollup patch. Contact IBM Technical support to obtain a new patch which can be installed on top of this rollup patch so that you do not experience loss of functionality as a result of applying the rollup patch.

Fix ID
Parallel Engine
ECASE 20959 Password properties appear unencrypted in Echo & Explain Properties in job log reports for Parallel Plugin jobs.
ECASE 58741 Group operator does not support certain data types for the max and min aggregator functions on AIX.
ECASE 73191 Buildop will not compile on Linux.
ECASE 73547 DecimalToString transform function is not working correctly.
ECASE 75184 Problem reading strings in parallel jobs.
ECASE 75956 Conductor node is not found when the node is not part of the default pool.
ECASE 77352 Nested subrecords are not handled correctly.
ECASE 77726 Job compilation error on AIX for ustring datatype.
ECASE 83202 Jobs that used to abort, now only issue warning for a match not found in the FilePattern expression in the import operator.
ECASE 87339 Transform datatype conversion for character field length of 18 to BIGINT causes truncation.
ECASE 88486 File names for filesets are not being processed correctly by import operator.
ECASE 88658 Decimal assignments from Stage Variables are incorrect in transform.
ECASE 88679 Teradata Enterprise stage is reporting waitonState timeout errors.
ECASE 89006 Transform compilation error occurs for character type conversion to integer.
ECASE 90490 Use of substring in a field with embedded hex 0 in transform results in incorrect data.
ECASE 90721 Numeric num() function in the transformer yields incorrect results.
ECASE 92067 Nested if block in transform is not generating correct code.
ECASE 92496 Numeric String Derivation gives unexpected result for parallel jobs.
ECASE 93003 Truncation of variable length string for the ColumnExport stage generates a warning that is not relevant.
ECASE 96576 File Pattern and File Name Column option does not work correctly in Sequential File stage.
ECASE 98413 ODBC Enterprise operator connection errors occur when used with the DB2 Enterprise operator.
ECASE 101340 Jobs are failing with block write errror on AIX.
ECASE 101682 Incorrect re-use of compiler generated local C++ variable for strings on Linux.
ECASE 102066 Lookup Stage has a performance drop for DataStage 7.5.1A and 7.5.2 Releases.
ECASE 103174 Aggregator reports the immediate previous value instead of 0 for NULL output which is incorrect.
ECASE 107806 Column export does not have support for datatype ustring as an output field type for preserving unicode characters.
ECASE 108134 DB2 EE Operator job reports dataset errors for partitions.
ECASE 110769 Wrapped stage is not terminating correctly when the parallel job aborts.
ECASE 111053 Memory corruption occurs from a DB2 EE Upsert Operator Job run on USS.
ECASE 112783 The orchadmin utility fails with connection timeout errors
ECASE 113241 Lookup stage drops a row which should not be dropped.
ECASE 118144 Lookup table creation performance issue.
ECASE 118556 Joining two timestamp fields with non-zero values for microseconds is not working.
ECASE 120621 Parallel jobs hang for large number of partitions after applying the patch for ecase 117136.
ECASE 121244 DataStage Job compilation error with IBM Compiler V6 which is not reported for IBM Compiler V8 on AIX.
ECASE 123617 Support required for CFF stage to save target dataset directly on USS system as a mainfraime MVS dataset.
ECASE 123773 Left outer join operator is reporting incorrect null values.
ECASE 124875 Job monitor reports negative statistics for the modify operator in parallel job runs at periodically.
ECASE 125655 The BOM file is removed when UTF-16 LE files are created and need to be read.
ECASE 126252 Filesets are generating the same name for the subsequent node. This Is causing data loss for the filesets.
ECASE 128154 File pattern method for reading multiple files is only reading one file per node.
ECASE 129134 Truncation occurs for the string and ustring fields.
ECASE 130437 APT_IMPORT_REJECT_STRING_FIELD_OVERRUN variable is not working for varchar datatype with Unicode extension.
ECASE 131642 IBM047 code page support required.
ECASE 132266 Job fails when import column data uses ustring in the schema.
ECASE 132829 Use of Japanese characters in column names for the FTP plugin in parallel jobs results in invalid character conversion.
ECASE 133213 Scaled integer support is required in the External Source Stage for MainFrame data processing.
ECASE 135194 Time Conversion issue in transform
JR30921 Merge is dropping a master record.
JR31129 isvalid transform function is not working for datatype int64 for values which are greater than the maximum value for int64.
JR31675 Column Name is incorrectly set for output data processing.
JR32005 A SAS 9 JOB FAILS for input records less than 7 bytes.
JR32299 Import operator does not process the rownumber corresponding to source file row number correctly.
JR32317 Datasets failed to get deleted on the physical machine for the mode overwrite option on subsequent run of different number of nodes.
JR32718 Time comparison is not working correctly.
JR33128 Job aborts with fatal error for fields using null values for trim functions in transform.
JR33161 IBM CCSID 1140 and 1141 code page support required for import/export operators.
JR33193 TERADATA_LATIN codepage support required for import/export operators.
JR33758 StringToDecimal function in transform reports different results for DataStage 751 and 751A Releases.
JR33819 ABAP stage aborts for truncated characters in parallel jobs.
JR33828 CFF operator does not process special EBCDIC characters on AIX.
FIX ID Description
DB2 Enterprise and DB2Z
ECASE 131403 DB2 Enterprise stage corrupts data read from a VARGRAPHIC column
ECASE 118596 DB2zLoad stage is now supported on the Parallel (PX) canvas on HP-UX on Intel Itanium
ECASE 123557 DB2zRead stage is now supported on the Parallel (PX) canvas on AIX
ECASE 124713 Warning messages without message IDs are received even when successfully loading using the DB2zLoad stage
ECASE 125754 DB2zRead stage complains about column names when an invalid table name is entered in a user-defined SQL statement
ECASE 125999 DB2zRead stage does not sort data according to the ORDER BY clause when used against non-partitioned tables
JR29413 DB2zLoad stage fails when using a large LOAD statement to load to a remote, partitioned table
JR30609 DB2zLoad stage prints passwords in clear text in the log when verbose output is enabled
JR32587 DB2zLoad stage allocates datasets differently when using FTP than it does when using BatchPipes
FTP Enterprise
ECASE 125136 intermittent error running concurrent ftp jobs
JR30705 FTP EE Stage doesn't handle paths properly.
JR30861 FTP EE suport for absolute paths
Informix Enterprise
ECASE 126397 Informix Enterprise stage is now supported on RedHat Linux on x86
JR30199 When multiple jobs using the Informix Enterprise stage run simultaneously, jobs may hang
ECASE 83311 Importing a table from Teradata fails at the Import Orchestrate Schema screen
ECASE 83330 Locator inforetrieval changed for DataSchema
ECASE 84954 char/char(1) truncate append fails.
ECASE 88354 The Netezza stage appears to swap the contents of columns when using Remote External Tables
ECASE 88422 Localization of Error messages.
ECASE 90276 Use name spaces to avoid symbol conflicts.
ECASE 91152 SQL Statements are failing
ECASE 95596 To update the Stage DSC xml
ECASE 96883 Unique External Table Names
ECASE 97533 null support to the schema
ECASE 100607 Code review inputs
ECASE 103231 Remove second instance of CLASS APT_ODBCException
ECASE 104729 Parse exception for data types: int8, int16, int64
ECASE 104945 Parse exception for "ustring"
ECASE 105791 change in the query for tablenames
ECASE 107090 Warning message for table Drop
ECASE 107595 instantiate product and datastore for locator
ECASE 116470 Check changed for ExecUpdate, removed the metadata processing
ECASE 116682 Incorrect schema string, for "dfloat" datatype
ECASE 118523 NZRead Operator - New addition
ECASE 120011 Multi-node (grid)
ECASE 122350 Enhancements to support update/upsert operator.
ECASE 123107 Problem old version limit 31 chars, new version up to 128
ECASE 126509 Appended "nzr" to the fifo name as pid does not suffice in a pipeline scenario.
ECASE 126952 support for NULLCHAR_LC
ECASE 127544 NULLCHAR changes
ECASE 127544 Replacing NULLCHAR=^ with 'N' to support nzload
ODBC Enterprise
ECASE 72985 Primary Key error as warning
ECASE 94437 Teradata TimeStamp
ECASE 97734 Issue with Teradata TimeStamp
ECASE 98413 Issues during connection creation, and individually check all return codes.
ECASE 104691 Memory Leak in odbclookup
ECASE 105812 support for int64 datatype
ECASE 108046 Added setCustomConnectionOptions
ECASE 108046 Added setCustomConnectionOptions
ECASE 110493 Removing implicit conversions for both SQL_DECIMAL,SQL_NUMERIC with scale=0 SQL_NUMERIC and SQL_DECIMAL handled separately.
ECASE 110691 Modifed e*Ustring to UTF-8
ECASE 111527 Fix for 64-bit ODBC Driver licenses
ECASE 113833 Merging issue
ECASE 115247 reject link related memory issue
ECASE 119683 Invliad syntax and column name.
ECASE 123304 Supressed error msgs. In case of dual query.
ECASE 123988 Disconnect in doFinalProcessing as new DD driver for Teradata not commiting anything.
ECASE 126743 Regression issue with close cmd
ECASE 129568 Commit before Disconnect in doFinal.
ECASE 134769 Neoview validation.
ECASE 134773 Neoview validation.
ECASE 134774 Neoview validation.
ECASE 134905 Neoview validation.
JR29085 disconnect properly in doFinalProcessing
JR29185 Handling of binary data.
JR29367 Fix neoview issues
Oracle Enterprise
ECASE 54823 Node constraint option is not working
ECASE 62474 Support added for Binary_Float and Binary_Double datatypes.
ECASE 66921 Problems connecting to RAC clusters with the EE Oracle operators
ECASE 117889 Wrong length for nchar column.
ECASE 119603 Oracle EE stage doesn't support Oracle table name with "#" charactor.
ECASE 121465 Not stripping spaces when loading varchars to Oracle DB.
ECASE 122143 Cannot use zero-length string, i.e., '', in user defined SQL in Oracle
ECASE 123269 Specifying terminator string in the datastage ctl file.
ECASE 124017 In Oracle lookup Stage database records are not appearing in output file.
ECASE 126707 First column data in the first row is always truncated when reading NVARCHAR columns.
ECASE 126870 Remove references to Oracle 7 and Oracle 8i from code.
ECASE 127301 Orchestrate schema importerr fails to import Oracle tables
ECASE 127327 Query optimization.
ECASE 127395 Failing sometimes for not null columns.
ECASE 127671 Oraread not populating records from nvarchar2(n) datatype where n is an odd number.
ECASE 128303 Option -orapartition in oraread not working when reading a range hash partitioned table
ECASE 128682 Problems when connecting to multiple oracle instances in a parallel job.
ECASE 128751 Oracle EE stage hangs when reading NCHAR column w/ arraysize option
ECASE 129006 DOUBLE type data will be reducing length to 10 in some cases.
ECASE 129281 Jobs doing upsert and with an Oracle Date column are running very slow
ECASE 129322 Support Loader keyword SINGLEROW added with a new env var APT_ORACLE_LOAD_SINGLEROW.
ECASE 129364 Cannot insert Korean characters into US7ASCII Oracle.
ECASE 129474 Getting error while runing job with oracle read as input and oracle write as output in multiple nodes.
ECASE 130528 Load not working after patches with 129901. Fix: Quote column names in control file.
ECASE 130832 Upsert and Lookup processing ustring as string is causing data conversion errors
ECASE 130939 Oracle Load changing blank characters into null so that some records are not inserted in the target table.
ECASE 131471 Oracle NLS getting wrong value of raw datatype while trying to update the table
ECASE 131554 Getting error while trying to append a table having nchar datatype with option APT_ORACLE_LOAD_DELIMITED
ECASE 134115 Allow Oracle EE Stage to connect to Oracle 8i servers from post 8i Oracle clients.
ECASE 134117 Number columns where scale is negative or scale is greater than precision are not processed correctly.
ECASE 134698 Oracle stage should avoid loading into virtual columns of Oracle 11g database.
ECASE 134770 Avoid index maintenance on interval partitioned tables of 11g.
JR29041 SCD STAGE cannot connect through Oracle EE. -12154: TNS:could not resolve the connect identifier specified
JR29207 Sql statements truncated.
JR29262 Unicode conversion errors. Move to OCI character conversion methods. No more ICU.
JR30068 Character sets mixed when writing to Oracle SQL*Loader data file.
JR30392 Make Read, Round Robin partition algorithm non-default
JR30409 Insert statement does not prepare correctly. Buffer overflow.
JR30428 SINGLEROW option does not work with partitioned tables.
JR30476 Upsert should report text of unhandled Oracle error before aborting, and Oracle error not in log if tablespace is full.
JR30485 Problems loading to Oracle when table has UNUSABLEINDEX status.
JR30605 Cannot support more than 5 Oracle EE stages in a job.
JR30942 Unbounded variable length strings default to 81 chars causing errors or truncation.
JR30960 SQL*Loader return code cannot be accurately read. Fix: detect the presence of the SQL*Loader BAD log file.
JR32014 Oracle EE fails to connect if the server string is longer than 128 characters.
JR32340 Oracle EE fails to load columns whose names contain special characers ($ and/or #)
JR32525 Job not aborting if orawrite index rebuild fails. APT_ORA_FAIL_ON_INDEX_FAILURE not working.
JR32541 Issues loading character data to Unicode database when NLS_LANG is NOT set.
JR32603 Oracle function in user defined SQL Statement does not work.
JR32630 The sub-operator APT_OraIndexRebuild should be updated to be wave aware.
JR32796 Round robin partitoner clause found slow.
JR32828 Load method should allow trigger and defaults to resolve not null when not in input schema.
JR32939 Avoidable export layer warnings in Load method.
JR33219 Can't insert date strings even as they match NLS_DATE_FORMAT.
JR33242 Load method very slow in comparsion to 7.5.1.
JR33269 Enabled External Authentication for connecting to Oracle.
JR33490 Very large sql statements (>2^16 characters long) fail to parse.
JR33644 Load method fails to load NULLs to date fields.
JR33670 Load method pads varchar2 columns with blanks when preserve blanks option is present (e111395 regression)
JR33836 Unless APT_ORA_FAIL_ON_INDEX_FAILURE is defined, job must produce only warnings.
JR33876 Lookup not processing EOFs correctly
JR33947 Report count of rows rejected by SQL*Loader in DS log.
JR34017 Honor use_strings option of orawrite. [PX sets this option if output link has strings.]
JR34094 Oracle error should abort the oraread stage job.
JR34111 Because of truncation while fetching value, increase buffer for column defined as NUMBER.
JR34323 Fixed length columns acquire addl spaces when using -use_strings option.
SAS Operator
ECASE 19028 Convert messages to nls bundles
ECASE 19028 Added cast to fix broken comp on Linux
ECASE 19121 fixed typo
ECASE 19145 Support nls directories & filenames
ECASE 19145 Cast return to compile on LINUX
ECASE 19145 Propagate -sas_cs to sasin op
ECASE 19145 Fix output msgs, multiple schemawanted loop.
ECASE 19145 Fix up propsToArgs()
ECASE 19145 sas_trans, noSasOut subtest
ECASE 19145 Fix dataSetName() to compile on LINUX
ECASE 19145 Support resource sasint entry for sas path
ECASE 19145 Spell linux correctly
ECASE 19145 Fix dubug message
ECASE 19145 Call int sas if -sas_cu set, set env at runtime
ECASE 19145 Improved NOTE for SAS errout/stdout msg
ECASE 19145 NOTEs on SAS list, log; msg improvement
ECASE 19145 Use APT_fileLookup(),SAS source file written in sas_cs
ECASE 19145 Fix typo in setSourceFile()
ECASE 19145 Fix #elif sequence to compile on AIX
ECASE 19145 Fix #elif sequence to compile on LINUX
ECASE 19145 Add ustring support
ECASE 19145 compile error on AIX
ECASE 19145 Improve messages, add debug messages
ECASE 19145 Support bounded fields
ECASE 19145 Improve Input from SAS msg
ECASE 19145 add apt_util/converter.h for LINUX
ECASE 19145 add APT_GFIX_SASExternUStringBase
ECASE 19145 sasint from resource file, APT_SAS_COMMAND
ECASE 19145 Do not override APT_SAS_DEBUG_LEVEL -report, 32 character names
ECASE 19145 msg improvement, add sasname to SAS out schema
ECASE 19145 variable in setIcuMap coded wrong
ECASE 19145 collation_sequence debug msg, Use APT_SAS_CHARSET also
ECASE 19145 collation_sequence option
ECASE 19479 added icu libs to link line
ECASE 19652 Double registration of sasop operators
ECASE 24802 Fixed some #elif's so they compiled on Tru64
ECASE 24802 Removed control-M from end of every line.
ECASE 25819 SAS 8.0 on suffix in psds
ECASE 25819 Improve error message
ECASE 38239 SAS international .psds header support
ECASE 38239 Generate psds descripter UString entry
ECASE 39185 section header changed in SAS 9.1 SAS_9_NFORM_LENGTH
ECASE 40283 Seed to APT_RandomNumberGenerator is signed
ECASE 40386 keypunch error fix
ECASE 40386 apt_msg edit
ECASE 42282 SAS 9.1 on eagle.
ECASE 42282 -nonews only not for sas612
ECASE 42282 Fix rename
ECASE 45091 Fix pdsd overwrite
ECASE 46608 check conductor node correctly
ECASE 46608 output reason for failure
ECASE 48272 Do NOT use APT_NLS for a english constant
ECASE 52877 Fix compile error on SUN
ECASE 56475 APT_MSG edit
ECASE 62233 don't segfault when SAS stops reading a dataset before all of the data has been consumed
ECASE 62714 Default log, scan for severity. eImpLogDS
ECASE 62739 Unique psds directory
ECASE 62741 import schema in a text file, getSchemaFile()
ECASE 62754 enhancements to SAS operator in copied/delete
ECASE 62791 use nofmterr
ECASE 62791 Remove Accidental Commit
ECASE 63634 Change ORCHESTRATE to DataStage
ECASE 63634 Fix compare
ECASE 63634 Change wording in psds header
ECASE 67143 APT_SAS_PARAM_ARGUMENT, argument on sas line
ECASE 69618 No Skipping the Pos Field for SAS 9.x,getSchemaFromDS
Sybase ASE
ECASE 10693 Error processing varbinary data type
ECASE 81305 Support load of table owned by another user
ECASE 127870 Unable to run Sybase ASE and Sybase IQ stages together in one job
ECASE 128510 Null values for decimal columns not updated correctly
ECASE 128510 Added support for milliseconds
ECASE 130509 Unsupported Data Type" error for user defined datatypes in some cases'
ECASE 130704 Job does not abort for bcp copy in failed message
ECASE 132819 Problem reading complex query
Sybase IQ
ECASE 69067 truncate length in nls
ECASE 94977 Add code to handle short read for fixedwidth
ECASE 102072 Implemented indp
ECASE 110196 indp not allocated properly
ECASE 112807 Added new environment variable APT_SYBASE_CONVERSION_ERROR to be set to 'on' or 'off'.(default is 'off')
ECASE 112878 Added env to turn off checkpoint for IQ load table
ECASE 113317 Truncate table command failure causes job abort
ECASE 113317 Truncate table command failure causes job abort
ECASE 127204 Better support to get table metadata
ECASE 127870 Unable to run Sybase ASE and Sybase IQ stages together in one job
JR29230 Implement Sybase Custom operator features
JR32222 Added support for fixedwidth load.
JR32523 Improve performance of job startup time and table metadata determination
JR33360 Fatal ct-library error treated as informational
Teradata Enterprise
ECASE 128712 Intermittent failure of jobs loading Teradata tables
ECASE 130430 Request to suppress the PX framework warnings within the Teradata operator
JR29811 Loading UTF-8 data

Rate this page:

(0 users)Average rating

Add comments

Document information

More support for:

InfoSphere DataStage

Software version:


Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation