DSXchange

It should be an export operator. Get a copy of the Orchestrate Operators manual.

It's the database engine that's not running. Read the message.

Then get someone to start the Sybase database.

This is not a DataStage problem.

There is no tool, like Usage Analysis, that will do that for you. If you're prepared to hack the repository, you could interrogate the tables there. SELECT DISTINCT DS_JOBS.JOBNAME FMT '32L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBOBJECTS.OBJNAME = 'ROOT' AND DS_JOBOBJECTS.OBJTYPE = 'J' AND DS_JOBS....

Since a Data Set preserves the partitioning one would ordinarily assume that it also preserves the ordering. I'm fairly certain that I've read that somewhere, but can't think of exactly where right now. So, for the moment, that advice is "in my humble, but educated, opinion".

That grid on the "constraints" page has four columns. The rightmost is for handling failed lookups. The one to its left is for handling cases where the condition (which determines whether you even attempt the lookup) is not fulfilled. It's the rightmost column that is used for setting the failed loo...

Rehash!

Please explain what you mean by "reset everything". Does this include restarting DataStage, restarting the operating system, what? Have you used a netstat command to determine whether any DataStage processes are still connected? It might be a good idea to telnet to the server and see whether you can...

This is another question that falls into the "my car won't start, what's wrong with it?" class of questions. Please describe your job design, including all the stage types used therein, and in particular whether you have inter process row buffering enabled and whether you are using IPC, Link Partiti...

It shouldn't, because the first activation should have removed it from the AT queue (or advanced the date for an "every" entry).

The root cause is that DELETE.FILE does not delete the physical objects if they are referred to by a pathname rather than a simple entryname. This behaviour is documented; either in the UniVerse manuals or by typing HELP DELETE.FILE from the TCL prompt in a telnet session (HELP is blocked from the A...

May I ask what prompted this post? The curriculum for the server to parallel transition lab has been posted in the past - a simple search will find it. The curricula that I offer are published on my web site (see signature block), with detail available by following a simple link. The same is true of...

Search the forum for exact syntax, I'm sure it's been posted before. Here for example.

Is COL1 the key that is the basis for DB2 partitioning?

(I have to ask) Are you working within a DPF environment?

Oh, yuk. No reason not simply to RESIZE the DS_JOBOBJECTS hashed file to 64-bit addressing. You don't want to make the default 64-bit for all hashed files!

No, this is just DELETE.FILE failing because of entries pre-existing in the VOC file. The only safe course is to create a list of the failures, delete the pertinent entries from the file system and from the VOC. For example, if a hashed file is called MYFILE, then you need three steps, and you can i...

You can also get at the TZ environment variable or specify "DZ" in an Oconv() to get the time zone for the DataStage server machine. How do you propose to get the remote server time and time zone? A database query perhaps?