DSXchange

The ulimits are at unlimited on all except for Nofiles which is set to 2000. This was run as psdsadm. demo:devapl46>ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) unlimited memory(kbytes) unlimited coredump(blocks) 0 nofiles(descriptors) 2000

I'm not doing any aggregates or sorts. It died on me yesterday before processing any rows. However, some die after processing millions of rows. We've gotten this error on several different ETLs, not just on one. We do lookups against hash files and we run more than one ETL at a time. I don't know wh...

We are trying to run ETL maps that will load over 20 million rows. We are getting the following error. DataStage Job 1957 Phantom 16601 kgefec: fatal error 0 OCI-21503: program terminated by fatal error OCI-04030: out of process memory when trying to allocate 6784 bytes (Alloc statemen,pref col allo...

We are in the early stages of implementing the PeopleSoft Enterprise Warehouse. We are starting with loading financial data from PeopleSoft Financials. Many of the tables we are loading have tens of millions of rows. Performance has been horrific. We are using the PeopleSoft delivered ETL maps, but ...

There is not a Transactions Size tab so I'll test using the other.

Thanks!

Tonda

We're using the PeopleSoft recommended DRS stages. After looking again, I did find a field on the Target DRS called Input General tab called Transaction Size. Is this where I can set the commit level?

Thanks for your help!
Tonda

I'm trying to find out how to set the commit level of a job so that it commits after xxx number of rows. I've looked through the Ascentials documentation, the PeopleSoft warehouse documentation and browsed through this forum. I haven't been able to find out how to do this, although I did come across...

Is there a way in DataStage to view who last updated an ETL job and when?