what is new in DataStage 7.5.3

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
shin0066
Premium Member
Premium Member
Posts: 69
Joined: Tue Jun 12, 2007 8:42 am

what is new in DataStage 7.5.3

Post by shin0066 »

Hello All,

Can any one provide the changes from 7.5.2 version to 7.5.3 datastage version, what is new in 7.5.3, if any upgraded from 7.5.2 to 7.5.3, any issues?

Appreciate your input

Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

About a month ago, an IBM engineer told me that 7.5.3 was going to come out pretty soon, so I guess it is out. "They" were not ready to provide me with the "Whats new in 7.5.3" document at that time. See if you can get that from IBM.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

I think the 7.5.3 release will have a collection of defect fixes and patches consolidated and will probably be the last 7.5.x software release. You can get most if not all of the 7.5.3 changes in the current 8.0.1 release.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

vmcburney wrote:I think the 7.5.3 release will have a collection of defect fixes and patches consolidated and will probably be the last 7.5.x software release.
That's what I recall hearing as well, just thought it was supposed to be out by now.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

chulett wrote: That's what I recall hearing as well, just thought it was supposed to be out by now.
I remember a press release at AscentialWorld 2003 announcing that DataStage Hawk would be available in 2004.
* "Hawk" - Expected delivery late 2004.
Hawk highlights include:
o User interface innovations for enhanced productivity
o RFID infrastructure support
o "Next generation" meta data services infrastructure
Missed it by two years.
nick.bond
Charter Member
Charter Member
Posts: 230
Joined: Thu Jan 15, 2004 12:00 pm
Location: London

Post by nick.bond »

Here are the fixes for 7.5.3 from 7.5.2
Problems fixed at this release
==============================

Password properties appear unencrypted in Echo & Explain reports (ecase 20959)
----------------------------------------------------------------
For example, use a PX Plugin property with a database password property.
Turn on OSH_ECHO in Admin for the Project. When the job is run, the Directory
log entries for Echo will show the plain text value of the password.

Problem with IQBULK12 error reporting (ecase 29779)
-------------------------------------
When inserting data into a table sybase IQ 12.4.0 with sybase IQ bulk loader
using method 'autoload via OCOS', there is no information in the
log concerning the error.

Problem with Merge plugin quote property (ecase 34826)
----------------------------------------
Merge plugin quote property cannot accept 3 digit numeric ascii character
values.

orawrite changes parallelism in the oracle system table (ecase 51637)
-------------------------------------------------------
After successful data load and index rebuild, orawrite changes the
original degree of parallelism in the oracle system table.

APT_ORACLE_LOAD_DELIMITED causing incorrect warnings (ecase 61156)
----------------------------------------------------
Warnings incorrectly generated for nullable integer fields when
APT_ORACLE_LOAD_DELIMITED environment variable set.

Lookup problem with null fields (ecase 61672)
-------------------------------
When two fields passed into Lookup are NULL, the returned data is corrupted.

Job sequencer loop problem (ecase 62595)
--------------------------
Job sequencer loop fails at the 258th iteration if the loop includes a Sequencer
stage.

sparse lookup to Oracle problem (ecase 63415)
-------------------------------
When performing sparse lookup to Oracle, Lookup stage pads spaces to the end of
varchar fields returned from lookup.

DSDRun process disappears while job is still running (ecase 63861)
----------------------------------------------------
DSDRun process disappears while job is still running. StageRun process is
orphaned with a parent PID of 1.

Cannot process VarChars longer than 255 characters (ecase 64647)
--------------------------------------------------
SybaseOC plug-in stage cannot process VarChars longer than 255 characters.

CurrentTimestamp function enhanced (ecase 66572)
----------------------------------
CurrentTimestamp function enhanced to return milleseconds with a precision of 6

Oracle index rebuild returing errors, job finishes with success (ecase 70584)
---------------------------------------------------------------
If duplicate key data is loaded via the Oracle Enterprise stage, with
Disable constraints= True,and Index Mode=Rebuild, the Director log will
show fatal errors and finish with a job status of success.

DRS stage problem (ecase 74157)
-----------------
DRS stage truncates the last character in parallel Jobs.

Support for microseconds added (ecase 75320)
------------------------------
Currently the Oracle stage in PX and the UOW stage will not upsert a timestamp
field with extended microseconds (it silently drops this data). Additionally,
the load method aborts with the following error: Oracle_Enterprise_0: Column
COL2 has unsupported type.

Kanji characters in US help files (ecase 75942)
---------------------------------
SQL Builder online help appears in Japanese.

Issue with IPC inter process row buffer on Ds 7.5.1a Linux (ecase 76112)
----------------------------------------------------------
Job aborts unless IPC inter process row buffer is selected on Ds 7.5.1a Linux

Oracle Enterprise stage deleting index (ecase 76520)
--------------------------------------
Oracle Enterprise stage load deletes index and rebuilds it in default
tablespace.

Lookup fileset problem (ecase 76833)
----------------------
Failure to match node error when using lookup fileset.

Option added to DSJOB to retrieve log information for job's most recent run
(ecase 77716)
---------------------------------------------------------------------------
ECASE 77716 modifies the syntax of the command line tool dsjob so that it is
so that it is possible to get log detail reports for completejob runs.

The new syntax is as follows:

dsjob
-logdetail [-useid] <project> <job | jobid> <first event id> [<last event id>]
-logdetail [-useid] <project> <job | jobid> [-wave <wave no>]

ECASE 77716 adds the -wave option to fetch all log records for a
specific job run

dsjob -logdetail project job -wave w

w can be

the explicit run wave number (positive number)
zero, meaning the most recent job run
-1, meaning the penultimate job run
-2, the run before that
etc.

As a shortcut, to fetch the most recent job run report, the
additional arguments can be omitted

dsjob -logdetail project job


Hashed file headers being written into the wrong file (ecase 78708)
------------------------------------------------------
When a file is opened in the rotating file pool and then rotated out so another
can be rotated in, at some point in time, the header from the file that was
rotated out gets written into the header of the file that was rotated in and
therefore corrupts the file header.

Cannot insert BigInt to DB2/AS400 (ecase 79349)
---------------------------------
Attempt in insert data of type BigInt to DB2 on AS400 causes an error.

Error when not including all fields in the Oracle Enterprise stage Load method
(ecase 80018)
------------------------------------------------------------------------------
While Inserting using Load method there is the error for the columns not
specified in the Stage, even if columns have default value.

ORACLE OCI stage problem (ecase 80361)
------------------------
ORACLE OCI stage - jobs abort with error "Oracle Error - OCI_INVALID_HANDLE'
when using LONGVARCHAR type.

Problem with precision of decimal value in hash file key field when field
retrieved from Teradata (ecase 81429)
-------------------------------------------------------------------------
A new environment variable has been introduced to enable this
fix. When DS_USECOLPREC_FOR_DECIMAL_KEY is set to 1, key columns
of datatype DECIMAL will use the precision specified in the
column metadata. When this environment variable is not set or is
set to a value other than 1, functionality remains the same as
in previous releases. That is, the default system precision
specified in the DSEngine uvconfig file is used when writing
data to DECIMAL key columns.

Oracle OCI stage enhanced (ecase 81439)
-------------------------
Oracle OCI stage enhanced to support Timestamp data.

sqlMessage does not work in DS 7.5 (ecase 81635)
----------------------------------
Earlier enhancement to retrieve additional messages for rejected rows when using
orasupsert no longer worked at 7.5.

Oracle OCI stage problem with clob data (ecase 82895)
---------------------------------------
Reading clob value from oracle using Oracle OCI stage results in OCI_NEED_DATA
error.

Oracle Enterprise stage problem with bigint value (ecase 83370)
-------------------------------------------------
Oracle Enterprise stage, issues loading a bigint value of (999999999999999)
(16 9's) to an oracle table.

Informix Enterprise stage enhanced (ecase 84807)
----------------------------------
Informix Enterprise stage enhanced to allow delete rows with with XPS.

Problem importing table definitions using Orchestrate Schema definitions
(ecase 84857)
------------------------------------------------------------------------
Problem importing table defintions using the Orchestrate Schema definitions
with password containing pound(#) symbols.

Oracle Enterprise stage returning SQL*Loader error (ecase 84946)
----------------------------------------------------
Oracle Enterprise stage returns error "SQL*Loader -937 parallel load requested
and TEST_ONSITE has enabled triggers or constraints"

Informix Enterprise stage problem (ecase 84959)
---------------------------------
Informix Enterprise stage Could not manage data type "datetime year to minute".

Oracle Enterprise stage as lookup problem (ecase 85412)
-----------------------------------------
When Oracle Enterprise stage is used as a lookup, a field of type ROW_ID will
create a bind 104 error.

Fatal messages MUST be handled in final status of parallel job (ecase 85431)
--------------------------------------------------------------
Fatal messages are not always aborting the job,this occurs when executing
parallel jobs.

DRS extract truncates data (ecase 85518)
--------------------------
DRS extract against Oracle for Long Raw data type truncates data.

Parallel CFF stage problem (ecase 85641)
--------------------------
Parallel CFF stage does not read COMP-2 field.

upsert on Oracle Enterprise stage problem (ecase 85840)
-----------------------------------------
When using upsert on Oracle Enterprise stage, certain column data goes missing
with array size set to 500.

DB2 Enterprise stage problem (ecase 86799)
----------------------------
When array/transaction size is big in DB2 Enterprise stage, stage puts a strange
warning message. EA07033P1..otdb2_a_SOBPAC_1: Unmappable characters found
mapping text string (ORBRCD = SONO = BPMNNO = TA\dWC1100B? PGNO = ) with map
(SHIFT-JIS).

DB2 API Stage timestamp issue (ecase 86977)
-----------------------------
DB2 API Stage does not write complete Timestamps.

Job Sequencer problem restarting jobs (ecase 87267)
-------------------------------------
Job Sequencer unable to restart jobs in status Stopped/Restartable

Parallel Transformer problem with CHAR to BIGINT conversion (ecase 87339)
-----------------------------------------------------------
Using a parallel Transformer to convert a 18 character length CHAR to BIGINT
causes rounding up.

Stored Procedure Stage problem (ecase 87376)
------------------------------
Stored Procedure Stage (STP Stage) does not support LONGVARCHAR data types.

Server FTP stage problem (ecase 87392)
------------------------
FTP stage on server canvas cannot handle korean character.

IQ Bulk12 problem (ecase 87404)
-----------------
IQ Bulk12 jobs produce Phantom errors when Load method is set to Auto Load
via ODBC.

Oracle OCI 9 stage metadata mismatch (ecase 87421)
-------------------------------------------
The OCI 9 stage does not detect metadata mismatch when reading an Oracle table.

XML file import error (ecase 87516)
---------------------
Received, 'error converting hex character' message while importing the XML file
to a project.

Link partitioner stage problem (ecase 87571)
-------------------------------
Link partitioner stage: insufficient time allowed for the mutex to release on NT.

DB2 API stage problem (ecase 87623)
---------------------
When DB2 API stage is set to delete existing rows from target table, sometimes
it reports warnings about the row not existing.

terawrite operator checks permissions only on dbc.userrights (ecase 87666)
------------------------------------------------------------
Teradata Enterprise stage not correctly checking permissions before writing
to table.

Problem with parallel jobs on Linux containing plug-in stages (ecase 87812)
-------------------------------------------------------------
Parallel jobs with plug-in stages abnormally terminating randomly on Linux
with sigsegv in DSD.OShrun.

Sybase EE ASE write operator problem (ecase 87813)
------------------------------------
If an identity column exists and has values, the Sybase EE ASE write operator
does not allow specific values to be loaded, it automatically creates the
next values in the sequence.

Issues with upsert in Oracle Enterprise stage (ecase 87818)
---------------------------------------------
Issues with upsert in Oracle Enterprise stage when APT_STRING_PADCHAR is set
to space.

Fieldtransform operator problem (ecase 88103)
--------------------------------
Issue with the fieldtransform operator -nominal and -ordinal options.

Teradata job incorrectly reporting failure (ecase 88172)
------------------------------------------
Rerun of failed job finishes OK in teradata but reports failed in DataStage.

Crontab entry is not removed when overwriting scheduled job (ecase 88228)
-----------------------------------------------------------
When you import a job the schedule entry is removed but the crontab
entry for it is not. When you reschedule the job another crontab entry
is added to the system. Both are then executed by crontab.

TeraData Enterprise stage problem (ecase 88236)
--------------------------------
TeraData Enterprise stage Fastexport demimal/numeric precision 18.

Informix Enterprise Stage problem (ecase 88237)
---------------------------------
Informix Enterprise Stage Cannot handle decimal(X) Type totally.

Configuration file issue (ecase 88291)
------------------------
After upgrading to DS 7.5.1A the configuration file is ignorning the schema
information.

File Set stage problem (ecase 88486)
----------------------
File Set stage: file name column populated incorrectly.

dsjob problem (ecase 88510)
-------------
dsjob does not provide access to DSJ.JOBRESTARTABLE key. dsjob jobinfo
now writes a restartable flag to the report.

Parallel transformer stage problem (ecase 88658)
----------------------------------
Parallel transformer stage: Decimal assignments from Stage Variables incorrect.

Teradata Enterprise stage problem (ecase 88679)
---------------------------------
Getting TeraSync: waitOnState(1) timed out with Teradata Enterprise stage.

Informix Enterprise Stage problem (ecase 88791)
---------------------------------
Missing table creation options in Informix Enterprise Stage.

DSRunjob.b issue (ecase 88832)
----------------
Need to increase the default timeout on DSRunjob.b.

DRS stage issue connecting to DB2 via ODBC (ecase 88855)
------------------------------------------
When using ODBC connection in DRS, DB2 incorrectly issues failed INSERT
message on a constraint violation.

Parallel transformer compile issue (ecase 89006)
----------------------------------
Parallel transformer compile error when there is an implicit conversion char
to int.

Oracle Enterprise stage Upsert issue (ecase 89416)
------------------------------------
Oracle Enterprise stage Upsert fails on table with 'Date and Timestamp' data
types.

Sybase IQ Load Stage issue (ecase 89448)
--------------------------
Sybase IQ Load Stage: not finding dat file.

Importing metadata using SYBASEOC issue (ecase 89520)
---------------------------------------
Importing metadata using SYBASEOC with long table names or column names fails.

Problem with APT_TERA_DO_PERM_CHECKS (ecase 89533)
------------------------------------
When APT_TERA_DO_PERM_CHECKS=True, NLS error messages appear in log and job
aborts, NLS is not enabled.

DRS Stage for Sybase problem (ecase 90186)
-----------------------------
DRS Stage for Sybase does not use column derivations by default.

Problem with Netezza stage using Oracle stage as input (ecase 90276)
------------------------------------------------------
Getting Segmentation Fault error while running netezza Enterprise stage
(WRITE) with Oracle Enterprise stage (as input).

Parallel transformer issue (ecase 90721)
--------------------------
Issue with the Num() function in the parallel transformer.

MS OLEDB stage problem (ecase 90898)
----------------------
MS OLEDB stage: reject record does not go to reject link.

DRS stage issue (ecase 91171)
---------------
"MetaData mismatch" errors are not raised correctly by the DRS stage in the
Server job's log.

Oracle Enterprise Stage issue with reject rows (ecase 91288)
----------------------------------------------
Oracle Enterprise Stage is not saving reject rows for constraint violation
errors.

Sybase Enterprise stage issue when reading Sybase IQ (ecase 91324)
----------------------------------------------------
Warning of type "null-field" generated when reading Syabse IQ with Sybase
Enterprise stage.

Teradata MultiLoad stage issue (ecase 91447)
------------------------------
When inserting dates into Teradata MultiLoad stage, it drops the millisecond.

After application of Patch 76834 columns on reject link are not found
(ecase 91468)
---------------------------------------------------------------------
After application of Patch 76834 at runtime input columns that have been
renamed on the output link are not seen at runtime on the reject link. The
job aborts with following message. Could not find input field "newsisyacd".
Could not find input field,this is a column from the primary input.

DRS Stage NLS mapping problem (ecase 91633)
-----------------------------
DRS Stage doesn't perform NLS mapping from Simplified Chinese to Unicode
(MS936 to UTF-8).

tsort issue (ecase 91688)
-----------
tsort aborts when it maps data to disk.

DB2 UDB load Stage issue (ecase 91847)
------------------------
DB2 UDB load Stage ignores options set in File Type modifier.

Parallel transformer issue (ecase 92067)
---------------------------------------------------------------
Nested if in parallel transformer doesn't generate correct code.

Sybase Enterprise stage issue (ecase 92254)
------------------------------------------------------------------------
Parallel job with Sybase Enterprise stage and APT_PM_SHOW_PIDS set fails.

Oracle OCI stage issue (ecase 92264)
----------------------
Transaction Isolation property on Oracle OCI Output does not export correctly.

Mapping of corrupt data external to Ustring gives null result (ecase 92389)
-------------------------------------------------------------
If a partial mutibyte character is at end of string, U_TRUNCATED_CHAR_FOUND
error and string is nulled. Customer requires replacement character and
a warning.

Parallel transformer derivation gives unexpected result (ecase 92496)
-------------------------------------------------------
Inputs and outputs are strings derivation is Left(AsInteger(InLink.col),6)
gives zero and a warning when input is numeric string eg "20010606" warning
in log is Numeric string expected. Use default value.

Link collector stage issue (ecase 92568)
--------------------------
Link collector stage with sort/merge hangs.

IDOC stage export issue (ecase 92570)
-----------------------
It takes long time to export a job which has IDOC stage.

Teradata Enterprise Stage issue (ecase 92763)
---------------------------------------------------------------------
Property "Select List" in the Teradata Enterprise Stage does not work.

Oracle Enterprise stage: Oracle 10g issue (ecase 92806)
-----------------------------------------
If Oracle Enterprise Stage is loaded to Oracle 10, an error will occur.

Server CFF stage issue (ecase 93016)
----------------------
Server CFF stage is not transforming EBCDIC pipe character (|) (hex 4F)
properly.

Oraupsert and timestamp issue (ecase 93332)
-----------------------------
Oraupsert crashes with a SIGSEGV when trying to insert timestamp data.

Informix CLI Stage issue (ecase 93639)
------------------------
Informix CLI Stage has issue dealing with "old" dates (prior to October 1582).

MS OLEDB stage issue (ecase 93679)
---------------------
A new row isn't inserted with "Update existing rows or insert new rows"
in MS OLEDB stage.

User-defined sql in ODBC for SQL Server issue (ecase 94037)
---------------------------------------------
In DS 7.5.2, when user-defined sql contains -- comments in ODBC for SQL
Server, the job aborts with incorrect syntax error.

Request to enable $OPTION STRING.MATH for Basic Complier on Server side
(ecase 94490)
-----------------------------------------------------------------------
There are problems with maths involving numeric data over 15 digits in
that it alway rounds to 15 decimal places.

Teradata can cause job abort (ecase 94953)
----------------------------
Parallel jobs abort when Teradata issues "To many load/unload tasks
running" message.

Fatal error in transformer not causing job to abort (ecase 95008)
---------------------------------------------------
Parallel transformer has fatal error because of invalid
input value of DateFromDaysSince function, but job completed
with status of "Finished (See log)".

Problem with Data viewer on MPP system (ecase 95198)
--------------------------------------
Data viewer does not show entire record on MPP system.

Issue with unsigned binary values (ecase 95306)
---------------------------------
Unsigned binary values larger then 2GIG are not being converted correctly.

Quote column names in create ddl and generated sql (ecase 95406)
--------------------------------------------------
APT_ORACLE_QUOTE_COLUMN_NAMES environment variable added.

NullToZero functions issues (ecase 95747)
---------------------------
NullToZero functions can cause loss of precision of decimals.

ODBC stage warnings issue (ecase 95867)
-------------------------
ODBC stage does not report warnings on "incomplete" arrays.

FTP plugin stage issue (ecase 96320)
----------------------
FTP plugin stage in parallel job not working with the following
data types integer, smallint and decimal.

Netezza Enterprise Stage issue (ecase 96397)
------------------------------
Cannot set a tab as delimiter in Netezza Enterprise Stage.

Teradata API plugin stage issue (ecase 96592)
-------------------------------
Receiving syntax error using the {FILE} option in user-defined
SQL in the Teradata API plugin.

Administrator client issue (ecase 96714)
--------------------------
When opening project properties in DataStage Administrator, get error
"SR.ADMIN: Failed to enumerate local group -".

ODBC Stage issue (ecase 97024)
-----------------
ODBC Stage fails using the NCR Teradata Driver when a ";" or
additional spaces are found at the end of the sql.

Problem with project names containing TAB characters (ecase 97340)
----------------------------------------------------
The Projects directory is deleted if a project name that includes TAB characters
is added via Administrator client.

Teradata Multiload stage: TPUMP issue (ecase 97476 and 97473)
-------------------------------------
Teradata Multiload stage: The TPUMP plug-in needs to implement the flush()
method.

When adding a derivation in a parallel transformer job fails (ecase 97826)
------------------------------------------------------------
Running a transformer stage with a derivation causes the Netezza stage to
crash with an error: Netezza_Enterprise_1,1: ERROR: External Table :
count of bad input rows reached maxerrors limit.

ODBC stage user-defined query issue (ecase 97886)
-----------------------------------
ODBC stage in 7.5.2 is failing to parse a user-defined query.

ODBC Enterprise stage used with DB2 Enterprise stage issue (ecase 98413)
----------------------------------------------------------
ODBC Enterprise stage errors when used in job with DB2 Enterprise stage.

Long import and compile times (ecase 98718)
-----------------------------
Long import and compile times on newly created projects using the DS751A and
DS752 clients.

resource ORACLE statement issue (ecase 98723)
-------------------------------
resource ORACLE statement in a parallel configuration file is not recognized
automatically for Oracle Enterprise Stage to select data.

Issue with dsjob -logdetails (ecase 99073)
----------------------------
dsjob -logdetails is not showing complete information from an event.

Issue with $PROJDEF (ecase 99919)
-------------------
Using $PROJDEF causes message to be logged in &PH&

Oracle Enterprise Stage sparse lookup issue (ecase 100269)
-------------------------------------------
Sparse Lookup in an Oracle Enterprise Stage always returns a Null-Value
for a field with data calculation.

FTP Plug-in ASCII Delimiters issue (ecases 100591 and 100644)
----------------------------------
FTP Plug-in does not recognise Column Delimiters when Ascii values specified.

Teradata Multiload stage on Parallel canvas issue (ecase 100771)
-------------------------------------------------
Write to Teradata Multiload stage on Parallel canvas causes job to hang
after message about MultiLoad.

Oracle Enterprise stage Update then insert issue (ecase 101105)
-------------------------------------------------
Running Oracle Enterprise stage in upsert mode with Update then insert,
some records are not getting updated correctly.

Teradata Multiload stage on Parallel canvas issue (ecase 101242)
-------------------------------------------------
Teradata multiload stage in parallel job cannot load columns with values
longer than 26082 characters.

Aix fix for renaming columns in lookup (ecase 101361)
--------------------------------------
Implementation on Aix of fix to allow automatic updating of derivations
in lookup stages when columns are renamed.

Create table issue (ecase 101582)
------------------
Order of columns is being changed when creating tables.

DB2 API stage - issues with low-values being seen as NULLs (ecase 101629)
----------------------------------------------------------
Parallel job using DB2 API stage - issues with low-values being seen as NULLs.

Parallel transformer upcase issue (ecase 101682)
---------------------------------
Upcase function with contraints dropping characters in parallel transformer.

Sometimes Ftp plug-in stage hangs (ecase 101690)
---------------------------------
Sometimes ftp stage hungs without any response. Ftp stage issue the ftp command
in defined order such as USER, PASS, CWD,TYPE A,PASV, RETR and QUIT. However in
certain circumstances, after issuing RETR,
FTP stage does not respond any more so that does not issue QUIT.

Datatype S9(16)V99 issue (ecase 102159)
------------------------
Datatype S9(16)V99 imported as integer instead of decimal.

Problem when importing Oracle NUMBER column as decimal (ecase 102236)
------------------------------------------------------
When Oracle Enterprise stage reads in a column with datatype of NUMBER
(no length specified) in Oracle and imports the column in as decimal with
length of 38 and scale of 20, it outputs the data with maximum scale of
10 and pads the rest with 0s.

Problem writing to Oracle with ODBC Enterprise stage (ecase 102360)
----------------------------------------------------
Problem writing to Oracle with ODBC Enterprise stage using ODBC 5.0 and
DS 7.5.2.

Sybase Enterprise stage issue with User defined SQL (ecase 102453)
---------------------------------------------------
Sybase Enterprise stage on 7.5.2 converts decimal(18.2) to decimal(35,2) when
SQL is of type User defined SQL.

XML stage issue (ecase 102611)
---------------
Issues validating the output of the XML stage against the xsd.

Oracle Insert issue with timestamps (ecase 102644)
-----------------------------------
Oracle Insert than Update fails when timestamp contains null and non-null
values.

Oracle Enterprise stage RCP issue (ecase 102794)
---------------------------------
Oracle Enterprise stage does not appear to support RCP.

QualityStage and DB2 9 issue (ecase 102853)
----------------------------
Problems with QualityStage when upgrading to DB2 9.

Unit of Works stage issue (ecase 102924)
-------------------------
HP UOW stage error on HP when mutiple links into UOW stage have different rows
per wave.

Server jop issue FTPing to MVS system (ecase 103171)
-------------------------------------
Multiple server jobs all running ftp to an mvs mainframe are getting numerous
errors and failures.

Parallel aggregator issue (ecase 103174)
-------------------------
Parallel aggregator outputs previous value instead of 0 for NULL output.

Teradata multiload stage issue (ecase 103178)
------------------------------
Jobs with teradata multiload stage intermittently hang.

FTP Stage issue (ecase 103203)
---------------
FTP Stage issues FTP Command out of sequence.

Mainframe Relational stage issue (ecase 103419)
--------------------------------
Complex functions are lost on mainframe Relational stage.

Newlines affecting "view data" results (ecase 103435)
--------------------------------------
Problem when using the Oracle enterprise stage and doing a view data on a
table containing a varchar column that has data with newlines in it.

Writing to Teradata issue (ecase 103562)
-------------------------
Problem with DataStage 7.5.2 job writing to Teradata.

Lookup sending output based on column names, not on derivation (ecase 103588)
-------------------------------------------------------------
DS seems to ignore the source/target mapping when the output column name
matches the input column name.

DB2 Load stage aborts if COPY is set to yes (ecase 103737)
-------------------------------------------
The DB2 load stage aborts if COPY is set to yes. The job aborts with the error:
Abnormal termination of stage pphi_012_ld_itmhist_bulkld_x_mine..assgn_fd_ts detected.

Parallel CFF stage issue (ecase 103763)
------------------------
Parallel CFF stage does not proceed correctly with GRAPHIC datatypes.

Code generation hangs with 13 lookups using 'cursor' type (ecase 103901)
---------------------------------------------------------
The code generation fails when there are 13 lookups within the job that
all use the 'CURSOR' lookup type. Fixed.

Parallel shared container issue (ecase 104775)
-------------------------------
Parameters not being passed into Parallel shared container correctly .

Oracle Enterprise Stage issue (ecase 104805)
-----------------------------107791
Oracle Enterprise Stage aborts the job when trying to insert null into Oracle.

COlumn Import issue (ecase 104905)
-------------------
COlumn Import imports a NULL in a decimal field where it should have a value.

Oracle Enterprise stage password issue (ecase 105068)
--------------------------------------
Oracle Enterprise stage cannot handle passwords that contain numbers.

Parallel environment variables issue (ecase 105514)
------------------------------------
When a parallel environment variable is set in administrator and then unset,
it causes an error in &PH&.

Teradata operator issue (ecase 105529)
-----------------------
Failure in Teradata operator fails to abort the job.

Issue with two DB2 Enterprise stages in USS Parallel job (ecase 105720)
---------------------------------------------------------
Job fails when using two DB2 Enterprise stages in a DataStage USS Parallel job.

FR-FRENCH locale issue (ecase 105811)
----------------------
DataStage 7.5.2 NLS enabled, local set to FR-FRENCH, could not send email.

Extended type column issue (ecase 106036)
--------------------------
Memory leak with Unicode extended type column.

Parallel Sequential File stage issue (ecase 106040)
------------------------------------
Parallel Sequential File stage: Problems with File Pattern in recent patches.

StringToDecimal function issue (ecase 106066)
------------------------------
StringToDecimal returns previous row's value when passed a non-numeric.

Batch job issue (ecase 106260)
---------------
Batch job hangs, appears to be problem with SIGCHLD handler.

Parallel transform compile issue (ecase 106321)
--------------------------------
Parallel transforms are compiled/generated even if no modification.

MS OLEDB stage issue (ecase 106402)
--------------------
OLEDB stage aborts when update/insert a lot of rows using OLEDB stage.

FTP Enterprise stage issue (ecase 106606)
--------------------------
FTP Enterprise is adding Char(10) - line feed on Fixed length record.

Require a kill force when 50 warnings hit (ecase 106703)
-----------------------------------------
The issue here is that if we have a abort at 50 warnings, it should abort.
We should do a kill force which removes processes no matter what.

Metadata import from DB2 issue (ecase 716719)
------------------------------
Import using ds db2 can see all tables except summary tables.

IMS copybooks issue (ecase 106797)
------------------------------------
IMS copybooks are incorrectly placed.

SCD Stage issue (ecase 107213)
---------------
SCD Stage not compiling derivation properly.

Issue with DB2 API stage in parallel job (ecase 107284)
----------------------------------------
Problem using DB2 API stage using date field in parallel job.

Issue with filter command (ecase 107302)
-------------------------
zcat in filter command sometimes not working.

Issue with disable local run option (ecase 107678)
-----------------------------------
As a Grid Enablement option, a patch disables the user from running
the job locally from the GUI or command line and instead aborts the job.

Import operator issue (ecase 108151)
----------------------
Import operator is not parsing a file correctly.

Parallel transformer issues (ecase 108216)
---------------------------
French characters are not supported in parallel transformer.

Insert of null to float data type invalid (ecase 108261)
-----------------------------------------
Parallel jobs - reading from SQL server loading Oracle 9i using Oracle
Enterprise stage write method=load, float datatypes - null getting
loaded as -0.15429, update float datatypes - get null value.

Hashed file issue (ecase 108565)
-----------------
Jobs are making hashed files into type 19 files

Encypted password for DB displayed (ecase 108635)
----------------------------------
When there is a runtime failure for a job in the job log the password is
displayed for the database user.

Teradata Enterprise stage issue (ecase 108688)
-------------------------------
Teradata Enterprise stage may crash with large data volume.

Table property fails with 2 tables, regression from v6 (ecase 108714)
------------------------------------------------------
Execution issue on an Oracle Enterprise stage with a two table join. Fixed.

TX MapStage issue (ecase 108755)
-----------------
Customer would like to like to be able to use DS 7.5.x MapStage with WTX 8.x.

Netezza Enterprise stage issue (ecase 109094)
------------------------------
The Netezza stage does not handle NULL dates.

ODBC Enterprise issue with SQLServer (ecase 109927)
------------------------------------
ODBC Enterprise adds garbage to end of Nvarchar columns when reading SQLServer.

APT_TERA_SYNC_PASSWORD issue (ecase 110401)
----------------------------
APT_TERA_SYNC_PASSWORD does not work when encrypted.

DB2 array size 1 issue (ecase 110486)
----------------------
Job is not aborting when an error occurs during a write on DB2 when array
size is set to 1

ODBC Enterprise stage problems with Netezza (ecase 110691)
-------------------------------------------
ODBC Enterprise problems with Netezza 3.1.0 driver and nvarchar columns.

Problem with Wrapped stage (ecase 110769)
--------------------------
Wrapped stage not receiving SIGINT when job aborts.

Intermittent error in ftp -> ftp (ecase 111028)
--------------------------------
Error with FTP Stage to FTP stage in job.

CEE3703I In HPCB Control Block, the Eye Catcher is damaged (ecase 111053)
----------------------------------------------------------
Intermittent issue, DS Job running on USS, issue occurs when performing
an upsert from the DB2 UDB Enterprise stage, the error is:

CEE3703I In HPCB Control Block, the Eye Catcher is
damaged. CEE3704I Expected data at 000130E5 :
HPCB.

DSCMapString(Ex) cuts last char of the target string (ecase 111365)
----------------------------------------------------
The last character gets cut when running parallel job across platforms.

Oracle Enterprise Load issue (ecase 111395)
----------------------------
Oracle Enterprise Load for varchar should not append spaces.

Issue with ODBC Enterprise stage and DataDirect driver (ecase 111527)
------------------------------------------------------
When running parallel job with ODBC Enterprise stage, the job throws warning
about unauthorised use of DataDirect driver.

Teradata API stage is rounding float data types (ecase 111961)
-----------------------------------------------
Using the Teradata API float data types are getting rounded to 9 decimals.

Orawrite operator issue (ecasec 112090)
-----------------------
Orawrite operator causes warning message after upgrading from 7.5.1A to 7.5.2.

Parallel job not aborting after fatal error (ecase 112375)
-------------------------------------------
Problem with Parallel job showing fatal Error, but job continues and
does not abort.

Issue with DataDirect DB2 wire protocol (ecase 112595)
---------------------------------------
Server job getting error when using DataDirect DB2 wire protocol.

DS_NO_PROCESS_METADATA environment variable issue (ecase 112623)
-------------------------------------------------
DS_NO_PROCESS_METADATA environment variable not working for ODBC Enterprise
stage or server job ODBC stage.

ustring issue (ecase 112631)
-------------
Error with ustrings and APT_MultiFieldAccessor.

Oracle Enterprise stage issue with row ids (ecase 112687)
------------------------------------------
Oracle Enterprise in "table" method has bad rowids.

Netezza stage timestamp issue (ecase 112779)
-----------------------------
Unable to select timestamp with microseconds from netezza.

orchadmin issue (ecase 112783)
---------------
orchadmin utility fails with connection timeout errors.

Lookup stage and RCP problem (ecase 113187)
----------------------------
Lookup stage with input field not propagated, also does not pass
field on with RCP.

Lookup stage issue (ecase 113241)
----------------------------------------------------
Lookup stage drops a row which should not be dropped.

Mainframe job compile error (ecase 113343)
---------------------------
Mainframe job compile error : Business rule must have output.

DRS stage issue with LONG data type (ecase 113350)
-----------------------------------
DRS fails with ORA-01331 when Inserting a LONG data type.

Job fails with the tcp protocol error (ecase 113397)
-------------------------------------
Where a DS job uses multiple invocations ids, invocations are generating
wave sequencing warnings consistent with some functionality in
the job not working properly with multi-instance invocation ids.

Changing table to OS390 platform type removes metadata (ecase 113446)
------------------------------------------------------
Changing table to OS390 platform type removes metadata.

DSCGetStrStageProp issue (ecase 113544)
------------------------
DSCGetStrStageProp returns during job runtime invalid value for encrypted
password property, invalid value is always a character on position 33 of
the encrypted property.

ODBC Enterprise stage and Netezza issue (ecase 113582)
----------------------------------------
When using the Enterprise ODBC stage to read from Netezza non-nullable colums
are read as nullable .

job aborted unexpected rounding (ecase 113614)
-------------------------------
Job aborted with the message below.

APT_Decimal::assignFrom: the source (10,000,000) is out of range for a
decimal with precision 18 and scale 11.

Parallel CFF stage issue (ecase 113622)
------------------------
Issue viewing and reading data in the parallel CFF stage.

Mainframe job issue (ecase 113751)
-------------------
Mainframe jobs: use of concatenation symbol in derivation causes
compile error.

Mainframe job issue (ecase 113762)
-------------------
Mainframe jobs: Cobol code being generated incorrectly.

DB2 plugin issue (ecase 113995)
----------------
Error message "No row was found" when deleting rows using DB2 plugin.

Customer requires per column mapping in parallel CFF stage (ecase 114003)
----------------------------------------------------------
Sequential file stage has per column mapping capability, CFF stage GUI
does not give access to this. Customer data contains DBCS and MBCS,
needs two maps to read this.

Oracle Enterprise stage and Teradata enterprise stage problem (ecase 114115)
-------------------------------------------------------------
Oracle Enterprise stage is core dumping, reportedly only when Teradata
Enterprise operator is also in the job.

View data issue (ecase 114428)
---------------
View data alters Designer's environment variables when they are overidden
as job properties.

Generate code error 100036 (ecase 114457)
--------------------------
Generate code error 100036 The number of item in values list must be the same.

Sybase Enterprise stage requires configurable delimiter (ecase 114554)
-------------------------------------------------------
Sybase Enterprise stage uses "|" as default delimiter and is not configurable.
Customer requests to use string rather than a single charactor as delimiter,
and the delimiter option should be configurable.

Oracle Enterprise stage problem (ecase 114653)
------------------------------
Oracle Enterprise creates par file for load where instance shares port
with other instances.

Problem on parallel job using Oracle (ecase 114739)
------------------------------------
Problem on parallel job using Oracle and oracle password with symbol (!).

Spurious phantom warnings in job log (ecase 114743)
------------------------------------
Phantom warnings appear in job log for no reason.

Issue with Basic transformer in parallel job (ecase 114845)
--------------------------------------------
Problem with resetting Parallel job using Basic Transfomer that calls basic
routine using DS 7.5.2/Solaris 10.

Issue with importing via dsjob (ecase 115083)
------------------------------
dsjob '-import' option incorrectly reports import failed.

FTP Enterprise stage problem (ecase 115150)
----------------------------
Getting a 426 Connect error when using FTP Enterprise stage.

FTP Enterprise stage problem (ecase 115158)
----------------------------
FTP Enterprise stage is adding one new line char for each record.

Issue with DB2 Enterprise stage and DB2 9.1 (ecase 115190)
-------------------------------------------
DB2 Enterprise stage does not support DB2 9.1 range partitioned tables.

Issue with lookup in Oracle (ecase 115450)
---------------------------
Failed lookup to Oracle does not populate NULL to timestamp.

Problem using view data on Informix via ODBC stage (ecase 115461)
--------------------------------------------------
View data fails from a Informix database using the ODBC stage.

Issue receiving sparse file via FTP (ecase 115757)
-----------------------------------
User wants to receive file which contains 0x00 value in fields via
ftp stage.

Generated COBOL issue (ecase 115766)
---------------------
Generated COBOL does not handle negative sql codes as errror for INSERT,
UPDATE and DELETE.

Issue with Oracle Enterprise stage connecting to Oracle 8 database
(ecase 115978)
------------------------------------------------------------------
Parallel job aborts when Oracle Enterprise stage is connecting to Oracle 8
database.

Issue with Netezza bulk loading (ecase 116470)
---------------------------------------------------
Netezza bulk load fails using external table method.

DB2 API Stage in Parallel job issue (ecase 116482)
-----------------------------------
DB2 API Stage in Parallel job - hangs the client and disrupts the DS engine.

MS OLEDB stage issue (ecase 116961)
--------------------
Null value record is not rejected in MS OLEDB stage.

Oracle password problem (ecase 117059)
-----------------------
DataStage exposes Oracle password in DataStage log.

Oracle Enterprise stage enhanced to access-ora8partition option
(ecase 117387)
---------------------------------------------------------------
The -ora8partition option (which allows users to directly name a partition
in Oracle to read from) exists in the operator code but is not available
in the stage options.

Administrator client issue (ecase 117610)
--------------------------
Adding or modifying user defined environment variable with encrypted value
causes Administrator clientv to hang.


Wrong calculation of length of field in Oracle loader (ecase 117889)
-----------------------------------------------------
SQL*Loader is failing with Multibyte character error.

Issues running MQ plugin (ecase 117971)
------------------------
Issues running MQ plugin

Issue with ODBC, Netezza and RCP (ecase 118069)
--------------------------------
ODBC Stage does not get Database schema from Netezza correctly when RCP is
used.

Oracle Enterprise stage issue (ecase 118081)
-----------------------------
Issue loading nulls into oracle timestamp datatype.

Issue with nested condition (ecase 118178)
---------------------------
Use of UtilityHashLookup in nested condition causes compile error.

DataStage Clients dump core when user name > 8 characters (ecase 119456)
---------------------------------------------------------
DS Clients dump core when trying to log in with user name longer than 8
characters.

Enhance z/OS remote job support to use sftp (ecase 119474)
-------------------------------------------
Enhance z/OS UNIX System Services support to be capable of using sftp as a
replacement for ftp.

NLS (Japanese) errors on Oracle Enterprise stage (ecase 119720)
------------------------------------------------
In oreread stage getting junk characters while reading Japanese characters.
In orawrite stage, if table name or column names are in Japanese character
then error was coming as
Oracle_Enterprise_0: Oracle call failed; sqlcode = -911;
message: ORA-00911: invalid character


Issue pasting local container into new parallel job (ecase 119615)
---------------------------------------------------
Cannot paste local container into a new parallel job.

ODBC stage update statement issue (ecase 120044)
---------------------------------
If the odbc stage updates more than 1 row in a single update statement,
you get a warning and an incorrect error message

Upgrade problem with lookup (ecase 120237)
---------------------------
Lookup failing to compile on DS752.

Problem with encrypted data in Director (ecase 120354)
---------------------------------------
Double-clicking from Director to get a job status causes encrypted value to be
displayed in plain text.

dscmdimport gives no message if a job cannot be imported (ecase 121772)
--------------------------------------------------------
dscmdimport does not give a message is a job cannot be imported, it only
tells you which jobs were successfully inported.

C/C++ Compiler support on AIX systems (ecase 122662)
-------------------------------------
DataStage Enterprise Edition now supports compilation of transformer stages
using the IBM XL C/C++ compiler for AIX, V9.0.

Problems fixed Release 7.5.2
==============================
Regards,

Nick.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Wasn't Windows 95 supposed to ship in 1995 and Windows 98 in 1998?

Wasn't the next version of the SQL CAE Access Group standard for SQL supposed to come out in 1998?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

Finally got around to pushing out a blog post about it. It doesn't replace 7.5x2 so you cannot use it for parallel jobs on Windows. It bundles almost 600 bug fixes since the 7.5 release. It's a good option for sites that are not ready for version 8.
nick.bond
Charter Member
Charter Member
Posts: 230
Joined: Thu Jan 15, 2004 12:00 pm
Location: London

Post by nick.bond »

On AIX 5.3 and 6.1 DataStage 7.5.3 has a bug which means you can't import metadata using Orchestrate. I raised this with support and they confirmed they had recreated the problem and were raising an ecase for it but couldn't say when a patch would be available.

So if you're using EE then you might be better with 7.5.2 unless you find you have no issue on your platform.
Regards,

Nick.
manuel.gomez
Premium Member
Premium Member
Posts: 291
Joined: Wed Sep 26, 2007 11:23 am
Location: Madrid, Spain

Post by manuel.gomez »

DSguru2B wrote:About a month ago, an IBM engineer told me that 7.5.3 was going to come out pretty soon, so I guess it is out. "They" were not ready to provide me with the "Whats new in 7.5.3" document at that time. See if you can get that from IBM.
sorry if I sound too stupid but....arent we supposed to be already with version 8.0.1 of Information Server?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Not if you don't want to be. Older versions (up to three back, if I recall correctly) are also supported. So 7.5, 7.1 and 7.0 should still be supported.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chucksmith
Premium Member
Premium Member
Posts: 385
Joined: Wed Jun 16, 2004 12:43 pm
Location: Virginia, USA
Contact:

Post by chucksmith »

I am chasing one problem. It appears that rescheduling a job may be corrupting encrypted parameters. If we rekey the encrypted parameter values, the rescheduled jobs work.
chucksmith
Premium Member
Premium Member
Posts: 385
Joined: Wed Jun 16, 2004 12:43 pm
Location: Virginia, USA
Contact:

Post by chucksmith »

I am chasing one problem. It appears that rescheduling a job may be corrupting encrypted parameters. If we rekey the encrypted parameter values, the rescheduled jobs work.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That sounds... familiar, as in been a problem for a long time. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply