DSXchange

That's nearly impossible to read. Can you please copy the formatted job control code and paste it between Code tags? Edit your original post and replace the single-margin code with formatted code.

There is not enough information. Earlier you showed us the configuration file, which indicates two processing nodes using the same directories as each other. This may or may not be related to the problem you are having. Can you please post the generated OSH code?

The load rate for hashed files depends on a number of things. For example, if you are using the write cache, then it will run fast as rows are written into memory, but at the end there will be a period where no more rows are being written but the timer keeps going, so rows/sec appears to diminish. D...

There is no DataStage limit on processes. The operating system and hardware must be able to manage the number of processes you seek to run on it, and know that they are resource-hungry processes.

Looks to me like The primary document entity could not be opened. Id=WcsToHost.xsd

Is this XSD file accessible? Did you specify its pathname correctly?

Hi, From the command window in Datastage Administrator execute the following query. SELECT DTM, MODFIFIER FROM DS_AUDITS WHERE INSTANCE='Job_Name' It will give you the creation as well as the modified time of the job. HTH --Rich No it won't. Date/time created and creator are separate columns. LIST....

We are not mind readers. What was the message?

Switch is based on a value only. Transformer (and Filter) are based on expressions. It's not comparing apples with apples. Actual results will depend on how complex the expression is. It would be interesting to include Filter stage in the comparison, as one uses an Orchestrate operator while the oth...

Thread hijack! This thread began talking about shared containers. A new thread should have been started for the thread on combinability, which is totally unrelated to shared containers. Use of shared containers has no effect on "performance" - whatever that means. Internally, the components need lo...

You are trying to force Oracle to "remember" too many before-images by creating such a large transaction. Your Oracle DBA will explain what caused this error. As Arnd posted, either use smaller transactions or larger/more rollback segments. Search the forum; this has happened to others in the past.

You were just lucky. This is not guaranteed to work. For example, had you had UV tables, it would not have worked, as their SQL Catalog entries would have been wrong. There is no mechanism for re-building DS_JOBOBJECTS. A dedicated hacker may be able to rebuild some of it out of RT_CONFIG... files, ...

Tell us a bit more about the environments. For example is one using Intel chips and the other not, meaning that the byte order would need to be altered? Did you use a binary mode FTP? A hashed file (note, "hashed", not "hash") consists of two file system objects that you have to move - a directory c...

is slightly more efficient.

Not this little black duck! Always been very risk-averse. Always take an end-of-day export of project.

Hi all I have created a routines which return me a string based upon the system time for exmaple if iam entering the value 04/02/2006 it gives me A0406YTD. IAm calling this routine in a sequence then iam getting the follwoing error 1.(warning)Unhandled failure (A0206YTD) encountered...