DSXchange

hallo all It's either a bug in the Folder stage, or that one of the ulimit settings is too small. Will investigate further Monday and post results. I just ran into an error on the folder stage as well. The job is: FOLDER -> TFM -> SEQ The error i get is: DataStage Job 355 Phantom 17015 Program "...

rasi wrote: Create the multi-instance job which will read from sequential file and write into 8 sequential files based on the constraint.

Siva, Vincent. I am going to give this a shot and will post the results. This is much better than creating 8 individual jobs!

Hi guys If I have a CFF source file as stream input to a Transformer (TFM) and have 8 destination SEQ files based on a contsraint in the TFM, how would performance differ should I rewrite the job to have the source file stream into a TFM1, and from there have two 3 outputs, 2 constrained (to SEQ fil...

kcbland wrote: Sorry You Bought A Slow Engine

:D
that has to be the first time I saw that! But luckily we have the stats to prove this is not the case.

ogmios wrote: Anyway 40 million rows in 5 hours is about 2222 rows per second, which is pretty good for DataStage

But if they were using a real data warehouse database, this value would be much higher. Sybase IQ. "and he will persist until all are converted"

Ken

We are back up again. It was, as suggested, the dsenv file.

Is there any reason though that will not show any uv processes running? I am sure this used to be the case with DS6.0 - i.e. uv??? would be shown to run.

thanks

Hi Ken while waiting for response, i did somem checking and founf the following in the $DSHOME: dsenv.errs.041028.124048 inside is the following: /udd001/app/dsadm/Ascential/DataStage/DSEngine/sample/ds.rc: etlprd01:#=etlprd01:#: not found /udd001/app/dsadm/Ascential/DataStage/DSEngine/sample/ds.rc:...

Hallo all Perhaps you guys can offer advice before I go the re-install route (well, thats after Ascential contacts me!) This morning we edited the dsenv file to add parameters for the oracle 9 plug in. To enable the plug in, we need to restart the services. Because of previous experiences I neglecte...

Hallo all If we have a MASTERCONTROL (Sequencer) controlling a series of JOBSEQUENCERS which in turn control individual jobs, we sit with the following problem: If an individual job fails, the JOBSEQUENCER finishes OK and the MASTERCONTROL that sms's us says that all the jobs are finished OK. which ...

Hi Tom

I will take your suggestion and play with the concept. Is there a major decrease in performance when using 64 bit HASH files?

Hi guys I went through the following 2 processes: for SOLARIS (64bit OS): change uvconfig file parameter from 64BIT_FILES 0 to 64BIT_FILES 1 stopped DS services started DS services Is DS going to automatically create 64 bit HASH files from now on? I did exactly the same for my windows 2000 professio...

kduke wrote: Another solution is to create a table of days or use a day dimension table. Join this input table to the new day table and count how many records you get by month.

thats a good idea. i just looked at the output again - its not that simple for a server job design! phew!

Why do you want to use basic to do this? Design a server job and use a SEQuential stage to read your INPUT and pass the data through a transformer to the OUTPUT SEQ stage. Within the transformer you can do whatever you want with the data. You would probably end up using Iconv/Oconv and Trimb. but, i...

it seems the project has been protected by someone other than you. How are you connecting to the project? Are you an administrator on the server? If so, log onto DS Administrator and unprotect the project. You might want to reconsider the access to the project. Have a look at the security options av...

how about adding @INROWNUM as part of the key to the void hash file and thereby you will keep the duplicate record, plus where it lies in the sequential file: key1 | key2 (rownum) | rest | of | the | record ------------------------------------------------- -1 | 10234 | 111 | 22 | 33 | 44444 -1 | 103...