DSXchange

You might be able to use the external target stage like the example I gave in the wrapped stage thread. You can use the following code fragment to split the file into as many files as you specify up to 99. The default record seperator for awk is a line feed. If you need to modify this you can specif...

Will your records be fixed width? If not, do you require that each file contain a full record?

Make sure that you mark the script as executable and readable. I setup the stage as follows. Input -> Properties -> Target -> Destination Program /Work/Ascential/script/example_awk.ksh -D"?" -F"/Work/Ascential/tmp/mystuff.txt" Input -> Properties -> Target -> Target Method Specif...

It is blowing up memory!!! IT IS NOT USING THE SCRACTH DISK AT ALL!!! That is problem. It is buffering the entire result set in memory and not using disk at all.

Hi, We are using Ascential DS 7.5.1A with the following patches applied: 75003, 80895, 80559, 80036, 76017, 20959 The Stored Procedure Stage caches all rows before it starts to write its output. This causes many gigabytes of memory to be used and the job to be aborted. I have tried to use no buffer ...

We had wrote up two cases for Teradata. This was the second case. But, they found this same issue while they were testing for the first case: if the sessions and players are not equal n = n, which forces only one player :(, the job will just hang. We encounter these issues with parallel jobs. I don'...

Ooops,

The difference is 1 hour vs ~60 hours.

Hi, We are using Ascential DS 7.5.1A with the following patches applied: 75003, 80895, 80559, 80036, 76017, 20959 Occassionally the teradata enterprise stage (about 20% of the time), will have a major performance issue. The stage will suddenly process at 4000 rows/second for a job instead of 250,000...

After slightly over two weeks Ascential finally said that it cannot be done. That is, a single SMP server with just one OS and multiple network interfaces cannot be load balanced for network traffic.

Usually bad code that caused a segmentation fault. It could also be failing hardware. Did anything get logged by the error daemon?

Thanks Ray. I found it. I had to search on copy-orchdist and not copyorchdist. I will do some reading like track_star has suggested. However, I have been working with Ascential support now for about 2 weeks on this issue as well. They have no clue how to do it. At least I am getting some suggestions...

Could you use the External Target Stage. The External Stage will call your script one time and you will need to process standard input in a loop. You can also invoke your script with command line arguments. I typically use awk to process the contents, but you could also use just korn shell and not a...

Hmmm. I cannot find any information on copyorchdist and I believe that I have searched all of the PDFs that were installed on my pc. Well, that is another issue. The lousy documentation and the lack of a good interface. I guess a nice interface like dynatext would have been too expensive. Anyways, d...

I had this same issue on AIX. I had to increase the amout of memory that the osh program could allocate. I modified it so that it could allocate 2 gb instead of the default 512 MB.

cd $APT_ORCHHOME/bin
/usr/ccs/bin/ldedit -bmaxdata:0x80000000/dsa osh

Argh, it would not be for the same job. The first job uses file 1, the second job uses file 2, the third job uses file1. Thus, Each job would use a file according to its natural number ordering for when it is deployed. You know, if x%2 = 1 then use file 1, if x % 2 = 0 then use file 2. Something sim...