Posted: Mon Apr 02, 2001 8:33 am
There is a limit (undocumented, but mentioned in the past on this list) of 8K bytes for any expression in DataStage. If its getting near this limit (say over 6K bytes, since column names are re-mapped when the expression is compiled), consider replacing the expression with a call to a Routine (transform function).
In the "Advanced DataStage" class offered in Asia-Pacific region there is a module on the topic "Designing for Performance". This is the only resource of which I am aware.
The main performance issues typically are external factors, such as available (rather than theoretical) network bandwidth, database server performance and hardware performance. Of course, inefficient coding practices in DataStage will never help!
-----Original Message-----
From: Alexandre Stoulov [mailto:alexs@tern.ru]
Sent: Monday, 02 April 2001 18:24
To: informix-datastage@oliver.com
Subject: Some questions
Hi, all!
First of all I need your advise about any resources concerning DS perfomance tuning (books, url, etc)
The second question is more technical: Is there any limitations on the output constraints in transform stage. We find unpredictable behaviour of the job if the length of constraint is large enough.
Thanks in advance, Alexandre Stoulov
------------------------------
TERN Technical Support
mailto:alexs@tern.ru
In the "Advanced DataStage" class offered in Asia-Pacific region there is a module on the topic "Designing for Performance". This is the only resource of which I am aware.
The main performance issues typically are external factors, such as available (rather than theoretical) network bandwidth, database server performance and hardware performance. Of course, inefficient coding practices in DataStage will never help!
-----Original Message-----
From: Alexandre Stoulov [mailto:alexs@tern.ru]
Sent: Monday, 02 April 2001 18:24
To: informix-datastage@oliver.com
Subject: Some questions
Hi, all!
First of all I need your advise about any resources concerning DS perfomance tuning (books, url, etc)
The second question is more technical: Is there any limitations on the output constraints in transform stage. We find unpredictable behaviour of the job if the length of constraint is large enough.
Thanks in advance, Alexandre Stoulov
------------------------------
TERN Technical Support
mailto:alexs@tern.ru