DSXchange

The scheduler in DataStage is just a front-end for the actual tool. The default scheduler on UNIX systems is cron, and that is what you are likely to be using. If you want to do things not available in the GUI you can always edit your crontab manually, but you can specify a job to run every month on...

By (5) I didn't mean a position in the columns, but just the order to test. Can you add a sort and see if you get the same keys in the same order, the 10 original keys sorted, or 10 ascending keys not in your original list.

When I try to reparition an incoming data stream that is using the default ($APT_CONFIG) number of nodes to explicitly use the DB/2 partitioning scheme in a partitioned DB/2 table the pop-up window allows 3 values to be set - the Database, the Instance and the Table. Unfortunately at runtime I get t...

1. Please check to make sure that you are not doing a SELECT in your unidata stage 2. Can you connect to unidata and do a COUNT on that file? Also list the whole file to make sure that it is not broken. 3. Can you select & view another file completely - i.e. is this limited to the one file or to...

Please, I understood your question the first 2 times. Sometimes "View Data" works differently than when you run a job. Right now you are stating that when you view data in the job designer you only get 10 rows. I am asking that you write your data to a sequential file and RUN the job to see if it st...

I you write your job to read the data and write it straight to a sequential file with no modifications or other stages, does it do more than the 10 records you see in "view data"? Are there any warnings or errors in the log file for that run?

A job does not have "output" in the sense that you would like. In your case you have 3 columns - times how many rows?

Do you wish to call a job one time for each row and pass 3 columns/values as parameters to that job?

SMP (Symmetrical Multiprocessing) machines have one operating system and components that are in parallel (notably the processors or processing blocks). MPP (Massively Parallel Processing) systems consist of one or more separate machines, which may also be SMP, linked together. They do not share the ...

Parallel Extender is product name, when you have it you can write Parallel jobs.

No, there are so many internal parts that have absolute pathnames that it would take much longer to change all paths and refrences to paths than re-installing - and you'd never be certain that some error in the future might be due to the changed path.

You will need to change the directory back to what it was when you installed, or reinstall in the new location.

I've noticed similar issues but have never been able to reproduce. A job that usually processes 15K records per second will, on one invocation, process just a couple of hundred. Nothing is obvious when looking at the system while it is running, but a stop/reset/re-run will get it back up to normal s...

Add "64Bit" to the mkdbfile command.

The installations are going to be very different. Have you read the installation guide? They detail the steps necessary during the installation, what configuration setting are required before you even start, and what database changes need to be made. Installing PX means a DS Server installation and ...

DaleK,

sorry - the previous post had an aside, I thought your nomen was referring to the villainous robots "Dalek"s in the British Dr. Who series; I didn't think that it might be "Dale K." - it's been a long day and my weak attempts at humour were bound to fail.