DSXchange

Hi, we're trying to install DS8 on Solaris using Oracle for the metadata. The installation fails giving the error: (May 26, 2008 5:47:24 PM), Install_datastage, com.ascential.acs.installer.server.actions.InstallDSProjectsAction, err, ProductException: (error code = 601; message="The following p...

Hi, At this moment we have a 7.5 environment with one big production project (3000+ jobs and flows). Untill now we haven't had any issues with this size. I'm now planning a move to a datastage 8 environment (it will not be an upgrade, it's a new install on new hardware, new DB,...) and I thought thi...

I would focus more on the upsert to oracle part to find your fluctuations. Here the performance changes a lot depending on how many records are inserts and how many are updates. I once did a quick test on our environment where all inserts was 6 times faster then all updates. In most cases the job wi...

Hi, Lately we're getting a lot of errors on wCleanupCBOAggregates..JobControl (@AGR_CBO_ORIGINATING): Controller problem: Error calling DSRunJob(CleanupAgrCBO), code=-14 [Timed out while waiting for an event] . Before anyone mentions this: I have did a search and found that this is because of an ove...

don't know if it's relevant for the version of DS your using , but at one point I saw a patch about NULL values in stage variables.(some time ago, don't exactly remember the details or which version we were on at that moment)

Maybe best check if this bug is there in your version .

correct forum, incorrect indication: It's a parallel job.

update: It doesn't seem to be the numbers. The project is set to force buffer(APT_BUFFERING_POLICY) and all stages are left as buffering mode= default. I understood that changing this to buffering mode=buffer, without changing the params should actually do the same thing. However if I do this I get ...

Hi, we're sorting about 50GB of data. According to other posts unix sort should be better then datastage sort at these numbers. Now I wanted to tune further, I came along the buffering parameters, since we have a lot of IO-wait on the unix box. default these are in MB (3MB max, 1MB disk wirte increm...

Hi, from examples here and there I've created a routine to get data from a hashed file. This routine will be used in a workflow: -fillhash -startloop -read data from hash into variables -call some jobs for these variables -end loop As you will see in the code below, the routine now asks for the hash...

I was actually thinking of looping inside datastage.

so:
job to get number of audits
LOOP for 1to number
get queries
run auditjob
END loop.

Hi, I'm now working on an internal audit system, that as always should be as generic as possible. It should show differences between our systems. eg: a customer that is in the sale system but not in the billing system, or that has important differences in both systems What I was planning to do: crea...

New virtual data set: I think this means first all data has to be processed for the lookup-file, before the real lookup can start. I think I'll go back a step then . the lookupfile is created from one oracle table and then used in multiple jobs. But if it has to be processed again, maybe it's better...

When I add a copy stage, will it then create a new workfile, or will it be able to work from the file as is? (or does this depend on the flag to force the copy stage or not?).

I cannot read your full text. But I can read the part about contact support. Case was opened before I made this post. I'll update here if I hear from IBM.

yes, indeed. But I have to do an update to my post, It seems this depends on the sequence of the links. When the lookup1 is defined as the first lookup it runs ok, when lookup1 is defined as second it takes the wrong value. In the constrains it states to 'continue' when lookup not found .Does this m...