DSXchange

First off, are you sure your sequence generator query is the source of your slowdown? There are *so* many things that can affect performance... and I would suspect something else if performance is deteriorating drastically. Oracle sequences are great for situations where you need concurrency, but if...

This is a topic for an orphaned message.

KeyMgtGetNextValue requires a hash file and that is not possible in the case that I have. With regards, Wilcy On Wed, 23 Jul 2003 Tony Stark wrote : >Depending on your needs, DataStage has its own >Sequences that you can use. See the KeyMgtGetNextValue >transform under Transforms->sdk->KeyMgt > >Hop...

1. What is the network speed between the DataStage server and the Oracle server? I have found that increasing the network speed from 100Mb to 1Gb has a more dramatic impact on lookups than on straight data transfers (I think it is more about the round trip time for the lookup than bandwidth). 2. Loo...

Depending on your needs, DataStage has its own Sequences that you can use. See the KeyMgtGetNextValue transform under Transforms->sdk->KeyMgt Hope this helps, Tony --- Wilcy William wrote: > Hi, > I am using a ORAOCI8 stage with the > following query > SELECT SEQ_ERROR_TABLE.NEXTVAL DUMMY FROM DUAL ...

Hi, I am using a ORAOCI8 stage with the following query SELECT SEQ_ERROR_TABLE.NEXTVAL DUMMY FROM DUAL as a sequence generator. The performance of the job has deteriorated drastically from 3000 rows/sec to 300 rows/sec. Any suggestions to improve the performance? I am using DataStage 6.0 on UNIX ser...

does anyone knows what this error is? I can figure it out. its a PX error. mzrt_inv_xref_insert.DSLink34: Error when checking composite operator: Describe failed because of missing column for FIN_INV_I_SEQ The column is not missing. its just not part of the column to be moved to the next stage. it w...

Hi Tunde, Could you create an argument called something like "VariableArgument" and then pass it a delimited string of values, such as SomeArg1=Value,SomeArg2=Value, ? Then in your custom routine use a loop with the Field method to parse out the variables with their values until no more fields exist...

Hi Kasia, Ill try this when it happens again, I compiled the job and I am running the jobs again. Thanks. Wim. -----Oorspronkelijk bericht----- Van: Kasia Lewicka [mailto:katarzyna.lewicka@cgey.com] Verzonden: dinsdag 22 juli 2003 11:22 Aan: datastage-users@oliver.com Onderwerp: Re: Job wont stop ru...

The process is also still running? (check it with the command "ps -ef | grep DSD" if you are on Unix) If not (process finished), try to execute "Clear Status File" in the DSDirector for TranslationJob) Kasia At 22/07/2003 10:57, you wrote: >Hi, > >Several times weve faced the problem that a job wont...

Hi, Several times weve faced the problem that a job wont stop running. Weve got a construction like this: Mainjob FileJob Validatejob TranslationJob The translationjob keeps on running while the other jobs are finished. I cant look into the joblog because the error cant attacht to job log occurs. It...

Its been brought to my attention off line that there are some functions that have a variable number of arguments (for example TRIM, EREPLACE). Let me modify my previous assertion. DataStage BASIC (as currently shipped) does not allow one to write routines with a variable number of arguments. -- ____...

The DataStage BASIC language does not provide for variable number of arguments. ----- Original Message ----- From: "Babatunde.Ebohon" Date: Mon, 21 Jul 2003 07:40:40 -0500 To: Subject: HashLookupRoutine with Variable Arguments > > Hi all, > Has any produced a routine with variable number of argument...

Of course you could send in a delimited string, count the number of arguments and then process accordingly, but why would you, as you would have to have an exact order etc to args... Kenneth Bland wrote: >You cannot do this on Server Edition routines. > >--- "Babatunde.Ebohon" >wrote: > > >>Hi all, ...

The import is done through the manager? You have to log on with UserB before importing! Check what are the job owners in project A and project B - should be different (userA and userB) Kasia At 21/07/2003 11:37, you wrote: >Hi, > >Weve got the following problem: we have defined two datastage project...