DSXchange

Ray, before seing your note I have done a few tests. 1. I have tried running it with ~100 rows, performance went up to 1500 rps. 2. Running original job with 200 columns from ORA to dos NUL file - performance was still slow - ~300rps! 3. Moving the same 200 columns from HASH to HASH - ~300 rps. It s...

Hi, We've got a table with ~200 columns that is read to a hash file and we have not seen it working better than ~300 rows per second. What performance should I expect reading ~200 columns? We have tried different array sizes. I cannot think anything else, thers is not much else I can play with, is i...

Hi All,

Is there any practical way to purge all logs for all jobs in the project?

Thanks,
Robert

Here's an update on that for all interested. Above has been recognized as a bug in version 5.2. It is reported to be fixed in version 6.0r1. For those using NLS, version 6.0 is not yet NLS enabled. DataStage 6.0.1 is scheduled for release mid-February. This release will be NLS enabled, it will inclu...

It looks like it is not possible to attach MULTI INSTANCE job using its base name only. I use Job Sequencer, it generates as below, jb$4 = "JobA":'.':(DSJobInvocationId) h$4 = DSAttachJob(jb$4, DSJ.ERRNONE) which makes sense, but does not work if non-released version is not there. I had it...

Hi All, I have not seen any posts on below. I wonder how you guys do it. Here's an issue: I've got job A, which is run by job sequence (job B). Both are multi instance. Job A is called from job B, with job B invocationid (using DSJobInvocationId macro). If I run non-released versions, it works fine....

You've got the good solution above. Let me add that if you're using job sequence, you can use macro DSJobInvocationId in the invocation id field of the main job properties. However, I am having problems running released versions of these jobs. See other thread I created. Edited by - rwolancz on 12/2...

Done as you suggested. All works fine.
Many thanks Ray

Hi, I would like to use UniVerse DB as a storage for temporary data in my job. My job runs in a multi instance mode, therefore each instance should deal with its own "temp" table. The job should: - establish temp table name (constructed eg based on InvocationId ... ?). How can I use it lat...

kww, In our app the batch script reads the password from a file and passes it to dsjob (using -param ...). But looks like you solved your problem anyway. While on that, may I ask you if you used API from DS 5.2? It looks like object model has changed there. If so, do you have any docs on that? Thank...