DSXchange

First of all my apologies for a late reply

I have issued this command for one of the projects, but still the server version for the project is 7.5.1A ..

please advice, where I went wrong ?

Hi Everyone, I have a Sequence, which invokes many jobs. Jobs and the Sequence are with multiple Invocation ids (ofcourse all unique). There are 10 Invocations of the sequence, and each sequence invoking 10 instances of the jobs. One particular job, let me call it as Job1, is resulting in error Job ...

Hi, My client went for DataStage Server Edition upgrade from 7.5.1A to 7.5.2 on Windows. The approach followed was this: Export all production Projects "Stop Datastage agents and process Schedulers; " Archive a Copy of All Projects "Move and rename all projects directories; " Uni...

Hi Ray,

I have verified the locales for all 5 categories... all are set to US-ENGLISH.

Hi, The existing Datastage server (7.5.1A, server edition) is installed on Windows 2000. The NLS (UTF - 8 ) is enabled for it. I have now installed Datastage server (7.5.2, server edition) on another Windows 2000 machine. The NLS (UTF - 8 ) is enabled for it. I have imported a job from 7.5.1A to 7.5...

Hi, The existing Datastage server (7.5.1A, server edition) is installed on Windows 2000. The NLS (UTF - 8 ) is enabled for it. I have now installed Datastage server (7.5.2, server edition) on another Windows 2000 machine. The NLS (UTF - 8 ) is enabled for it. I have imported a job from 7.5.1A to 7.5...

Any reasons for this error message being generated by DataStage ??

The problem has been resolved... bye replacing the routine by a sequence...

Hi All, Below is the job design: Seq01----------+-------->Seq02 | | V Routine The Routine is coded for a loop where it waits for 10 files to arrive in a particular location. It issues DIR commands to check for the files. The Trigger Condition are as follows: For Seq01-Seq02: Seq01.$JobStatus=1 OR Se...

Yes, I agree... i.e some workaround approach , like the one you are suggesting , is possible... but the problem is that I would need to invoke a routine for each of the input record... I am processing close to 20 - 30 Million records and for each invoking such a routine... I dont know how DataStage ...

robvonk wrote:

asitagrawal wrote: Do you really need the SSUB for comparing? Are the numbers that large?

yes, the numbers are big enough that I need to switch to string mathematics ...

I dont know what to do now...

robvonk wrote:We have Datastage 7.5.1 (no A mentioned) running on Windows 2000.

I can't find a 'smat' executable on the client.

smat.exe is available in ..\Ascential\DataStage\Engine\Bin\

Please do post your results...

ArndW wrote: What platform are you on?

DataStage: Server Edition 7.5.1A
Operating System: Windows 2003 Server Enterprise Edition SP1

Please let me know if you are looking for any other information also..

Sorry.. I think I have found it... Below are the results: Current tunable parameter settings: MFILES = 150 T30FILE = 200 OPENCHK = 1 WIDE0 = 0x3dc00000 UVTEMP = D:\Ascential\DataStage\Engine\UVtemp SCRMIN = 3 SCRMAX = 5 SCRSIZE = 512 QDEPTH = 16 HISTSTK = 99 QSRUNSZ = 2000 QSBRNCH = 4 QSDEPTH = 8 QS...

ArndW wrote:See what configuration changes you have made, could you post the differences shown by "smat -t" ?

Hi ArndW,

I dont know how to execute "smat -t".
Please guide me. I am on Windows machine.

Thanks