RE: Informix and Datastage

I'm not sure if this can be tuned, but the term to look for, is "parallelism" in Datastage Parallelism The DataStage engine exploits multiple CPU environments by automatically distributing independent job flows across multiple processes. This feature ensures the best use of available resources and speeds up overall processing time for the application. The DataStage server analyzes jobs at the start of execution, highlighting dependent operations and separately flagging independent flows of data. For a given job, the DataStage engine will potentially spawn many parallel processes at run-time. These processes will run concurrently and have their labor divided among multiple processors on a machine with multiple CPU's. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Alinda Watson Sent: Thursday, November 04, 2004 4:25 PM To: informix-list@iiug.org Subject: Informix and Datastage Hi, This might not be the correct user group to help but any documentation or advice will be appreciated: Datastage is running on a 8 CPU server but only utilizing 1 CPU, 1.''''' Is Datastage multi-threaded? 2.''''' Can Datastage be 'tuned' for better performance? (where) 3.''''' Enable or disable multi-threading? Enviroment: AIX 5.2 ML3 Informix 9.40FC4W2 Datastage 7.1 Arnou Kunz Specialist Informix DBA IT and Billing Group Vodacom Service Provider Company Cell : +27 82 997 0631 Tel : +27 11 546 1406 Fax : +27 11 546 8366 E-mail : arnouk@vodacom.co.za _________________________________________ "This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link'http://www.vodacom.net/legal/email.asp " sending to informix-list