DSXchange

Suggest you open a case with your official Support provider at this point if you truly can't find any differences between the two servers.

And no, that kind of reference lookup without a key field is not a problem.

Simply put, it rebuilds the index data in the Project. Search the forums for DS.REINDEX for the instructions.

First or last depends on the DB stage, from what I recall. And 'multi row result sets' in Server only applies to the ODBC and UV stages. Failing that, you'd need to handle this yourself in the reference query. You'd need some way to recognize the situation, by grouping perhaps, so that only a single...

First off, you can't just declare your file to be 'fixed width' if it isn't, that will never work - so let's undo that change. You don't need to be any kind of pro to make the change I suggested. Just go to the Columns tab in the Sequential File stage and notice there is a slider at the bottom of th...

That would turn everything off, not just the DataStage jobs in it - but if that is a viable answer one could do that.

Nope. Well, only if you break the job up into two discrete jobs, landing the data in between. That or just bump up the number of connections allowed.

So I'm wondering if there is a way to disable jobs from running, preferably a universal setting that would prevent all our jobs from running for a few days. Nope, no such thing. At least not out of the box. The only other option I can think of is to re-schedule the jobs and leave Friday, Saturday, ...

karry450 wrote:I know how to create a server job but I am not getting an option to create a parallel job.

Then you aren't licensed for the EE / 'Enterprise Edition' of DataStage and are thus not allowed to create PX jobs. Talk to your DS Admin.

First thought would be to join the input with a small set with static location values - 3 XYZ records, 2 MNO records, etc. Then just let the join generate the correct number of records. Don't know if that means a stage or a database solution, but that's the first thing that popped into my head.

I'm guessing you are having resource issues but can't know for sure. Next time one of the jobs abort, try Resetting the job and let us know the contents of the 'From previous run...' log message it (hopefully) generates.

Oh, and reindexing will fix your export error.

The biggest caveat for reindexing is to make sure no other sessions are active. Failure to do so makes all jobs 'disappear'. You need to try again, this time ensuring nothing else is going on in the project.

I seem to remember a command more like DSPROJUPGRADE or at least with UPGRADE in it somewhere.

Why not just rerun the installation script? That will 'upgrade' everything.

First post in the right forum and mark the Job Type correctly, this isn't a Server job question.

I am following installatioguide.pdf, apart from this suggest me where I can get installation help Well... 1) From your official Support provider 2) Here I can't help other than to ask you give more details about your problem. Saying that you are "unable to logon" doesn't help much, what happens whe...