DSXchange

Job design?

Rite? No. Right? Yes.

'ipcrm' is used to clear shared memory segments, not sockets. What does "netstat -a |grep 13401" show when DataStage is running and when shutdown? How long did you wait after stopping before starting?

And?

As long as you specify DIRECT=FALSE you are doing a 'conventional' load, which means transactional SQL inserts. To 'reduce the run timings' you'd need to get the direct load working and that means handling indexes.

No idea, but have you tried to determine what the jobs that fail have in common? Perhaps looks at the datatypes being selected or the nature of the sql being run and see if there's any common element, when it has this kind of field it doesn't work and when there is no field of this type it works?

Which problem, exactly? Block write failure? At the same moment in 3 differents servers not in the same place?

I've been trying to make this work. Got the credentials part down as the errors have stopped and if I leave off /R /RP it opens the Designer for the job I've specified. HOWEVER, adding the /R and /RP gets me... nothing. I suspect a patch may be required.

ps. This is 8.1 on Linux.

You have to say his name three times to make him appear.

You generally use ODBC on a UNIX server, however the OP allegedly is on a Windows server - hence the mention of MSOLEDB stage. Unfortunately, never having dealt with DataStage on Windows I have no idea what's involved in setting that connectivity up.

While you could do that with 7.x and you can have 7 and 8 co-resident, from what I've read you cannot have multiple versions of 8 installed at the same time.

My understanding is that your source table must be partitioned in order to take advantage of that option but the documentation isn't exactly clear on that point, so I could very well be wrong. Why not just try it? The read operates sequentially on a single node unless you specify a Partition Table p...

I would suggest an exact search for "APT_LINKER" and then check any resolved posts that mention both Windows and Parallel.

This really isn't a sqlplus support forum but perhaps if you expand a little on what exactly 'not connecting' means, someone may be able to help.

First thing I'd advice you is to read the documentation.