DSXchange

In your example, you would have Partitioned Parallelism in the PX job because you would have 3 XFM stages active but in the Server job you would have 1. The PX job also would have the chance to have 3 readers accessing Oracle using some partitioning means, whereas the Server job would have 1. There'...

I'm right because you stated you can't modify a.ksh, and that's where you'd have to insert the "tee" without using my suggestion.

My brain is not working right now. Kim, Ray, you out there? Lend some help please.

Have your associate login to the UV shell, logto the appropriate project, then issue the appropriate GRANT statements for select, insert, update, delete, drop, etc.

Weird problems occur when you overload any system with too much activities. Windoze seems to be especially problematic, haven't you noticed?

When I've seen this on Windoze servers it's been because too many jobs to simultaneously executing.

Partitioned Parallelism simply means that a set of data (rows) have more than one identical processes simultaneously working on different groups of the rows. If you have 10 rows of data and 1 process, then you don't have partitioned parallelism. If you have 10 rows of data and 2 processes each handl...

Search the forum, typical problems are the services aren't running, you're not connecting as Administrator or aren't valid on the domain, etc.

try 127.0.0.1 or "localhost"

Not really, since a.ksh completely controls the stderr and stdout of b.sh. The only suggestion I have is to rename b.sh to c.sh. Then, write a new b.sh that does whatever you desire with the stdout of c.sh as well as send it to stdout for a.ksh to handle. Consider looking at the "tee" command.

Server jobs can use multiple job instances to multi-process (partitioned parallelism). They have row buffering (quasi-pipeline parallelism) and inter-process buffering (active stages are independent processes communication thru fifo thus pipeline parallelism). IPC stages are just a user-placed fifo,...

Depends on how you want to "search" it. If you know the primary key, you can get it quite quickly from a command line query. You'll need to use SETFILE to get a project pointer to the file if it was created using explicit directory path. Otherwise, if you're searching on an attribute, it can take aw...

There's range checks like 1 to 10, which is really 1.00000000000000 to 10.000000000000, with an infinite number of values between because of decimals. For this < and > are the best. There's domain checks like 1 to 10, which is really 1,2,3,4,5,6,7,8,9,10. For this, enforce no decimal and then the < ...

You folks are arguing speeds and no one has mentioned looking at the speedometer. You can't talk about "fast" or "slow" unless you look at the Performance Monitor in Windoze to see what your Server is doing. If you are running 1 job that is using your entire 1-cpu machine, then 19 more jobs have to ...