DSXchange

We got the same message on one of the version 4 releases when ORACLE_HOME was not defined correctly in the dsenv file. You might want to make sure your dsenv file is correct. Also, in 5.1 at least, dsenv had to have the execute permission bit set. Good luck Larry -----Original Message----- From: Cri...

Hi! This is the ezmlm program. Im managing the datastage-users@oliver.com mailing list. Im working for Clif Oliver, the list host, who can be reached by email at moderator@oliver.com. Acknowledgment: I have added the address datastageUser@performart.com to the datastage-users mailing list. Welcome t...

weve processed up to 1.5GB on some files and it does not seem to be a problem for us. at least for us, processing time depends also on the number of routines being used inside the transform and on how many fields these routines are used on. -----Original Message----- From: Kancharla,Radha,GLENDALE,I...

Hi Ive a problem with Data Stage. I think that the installation is completed with successfull, I open Administrator, Designer, Director, Manager correctly but when I import matadatas plug-in ORA OCI 8 (Manager/Import/Table Definition/Plug-in Metadata Definition/ORA - OCI I have follow error: "Unable...

I would like to thank all for giving me the support and guidance to the "Global Variables World". Now I think that the best way to create global persistant variables is to use hash file. Then I can use I/O statement like OPEN, READ, WRITE, CLOSE to allow rapid and efficient access to DataStage hash ...

Radha the answer to the maximum size of a file DataStage PX can process is "the biggest you can create" on your hardware. As part of the fully documented Benchmark we recently performed at a IBM lab using DataStage PX we processed a full terabyte of data. Check out www.etlbenchmark.com for the in de...

All,

Can some one give an idea, what is maximum size of a sequential or complex sequential file, the datastage job can successfully process at a time.
Can it process 60GB file ? Please share your ideas on this.


Thanks,
-Radha

A trivial example first. Consider the following job design. S0 ----> T1 ----> S2 S3 ----> T4 -----> S5 There are two clearly independent streams in this job. Transformer stage T1 will execute in one process, running an instance of uvsh (dssh) to do so, while Transformer stage T4 will execute in a se...

Dear Pavan, Can you please e-mail me the documents and routines that you have regarding the above subject. Thanks, Shrikanth --- Pavan Marpaka wrote: > yes there is. I have a document and couple of > routines that do it for you. > Ill email them once I get to my hotel room tonight. > > PKM > > > ---...

Hi all, I want to ask if I want to trace the processes that a job runs on the database and the utilization within each query in the job either select, or insert.

how can I do this on the already created jobs?


Sameh Bishara

Hi, Presently ,moving from NT to Unix version of DataStage. Just need to know how to put in place a correct setup so that user groups dont temper with one anothers data files etc. Basically setup is like this. ds_uvtemp for temp ds_project for DS projects ds_appls for application source ds_data for ...

While Im on this thread, I would like to warn everyone who has great hopes of variables defined to be COMMON that such variables are only common in one process. If your job design is such that its innate parallelism causes more than one process to be started by active stages (probably Transformer st...

Hi, We have got a product from one of our clients and it has the conventional Datastage components with the mainframe tool. Now I want to know if we have to do any extra setup when we install this tool at our end? Apart from of course the NT installations. Please help. Regards, Viswanath ___________...

Check out the TRANS function as an even easier one to understand and use than OCONV for this kind of purpose. For even greater efficiency, learn about raw I/O statements in BASIC (OPEN, READ, WRITE, CLOSE, etc.) for even more efficient access. Yet another topic in "Programming with DataStage BASIC" ...

Hi Stacy, Ive been using Datastage in Australia for a few years. One of the nice features of using Datastage 390 is that ruleset for filtering the data BEFORE it is sent on to the UNIX or NT server resides on the Mainframe. There are at least 2 advantages to this. 1) Yes, the data must travel from t...