DSXchange

There may not be much experience of this out there to share. Perhaps you'd be better off pinging your official support provider.

If you can shut everything DataStage down, rename the current mount point, create the new mount point with the original name and move the projects over, there would be nothing you needed to change, UV or otherwise.

1. Try it, let us know.

2. No.

3. No.

4. Identify the bottleneck. Based on such limited information I suggest the lookup.

Oritech wrote:Bit confused,you mean to say in new IS-8.x,UniVerse has become irrelevant/no more utilized?

He's not saying that at all. 8.x leverages both.

Server is way more forgiving than PX and PX can choke on things that Server can handle, like unmatched quotes or embedded delimiters. Have you checked your file for anything of that nature? Open the file in vi and type ":set list" to show control characters, anything odd show up then? Perh...

OK, that changes things slightly. Jobs in Version Control projects are not compiled. And 'no design time information' means it can't find the actual job design, which is further confirmed by the RT_CONFIG error. Have you tried what Ray suggested, see if it behaves differently? You migh also try manu...

:!: Good Lord, have some fricking patience. It's the crack of morning for some of us (and a weekend to boot) and you waited what, not even an hour before you started banging on the walls? Give me a break. :evil: You can't figure out why you get an error that specifically states No space left on devi...

Post the complete, unedited error message. You can also get that for a List parameter type when you try to pass it a value that's not in the list.

Run the following query from the Administrator for the first three jobs to get their names:
Then again for 9391 and 9190, then try recompiling them and see if that helps.

Hmmm... the Pivot stage is a much simpler solution. It exists to 'twist' columns into rows.

I suppose if you shut everything down while you did this and moved the existing Projects directory over such that the end result had the exact same name, that you'd be ok.

For 8.x I'm not entirely sure but I would think it would depend on the 'something'. And why would you just back up one table? Back up the database.

Read just the header record (I assume there's only 1) using "head -1" in the Filter option of the stage.

This script... has it successfully run the job in the past or is this your first attempt? Trying to see if the script is the problem or if the problem is the job.

You can execute it from wherever you like. If you're asking where it lives, a 'find' should turn it up easily but I imagine it's in the $DSEngine/bin directory like most things of that nature.