DSXchange

My point is that if compression is necessary, then use sequential files instead of data sets to keep your data.

Please do not ask the same question repeatedly, it has alread been answered in your other thread.

Indirectly you can do this. You would need to add a UNIX command such as "dsjob -run -mode RESET {proj} {job}" to your crontabs. It cannot be done directly from the director. Alternatively, you can schedule a job sequence which calls your job using "reset if required, then run".

after restaring do you have an dsrpcd?

In theory all you need to do is export your projects at 7 and import them into 8. In practice things tend not to run that smoothly. A lot depends on the size and complexity of your applications. If you have a relatively new implementation and are limited to PX only then chances are pretty good that ...

Mea culpa - I was doubly wrong. (wish I could get away with editing the wrong answers).

after shutdown, get the segment number from the "ipcs -a | grep 0xace" command, then remove them using "ipcrm -m {memsegnumber}". What about "netstat -a | grep ds"?

The shared memory errors can sometimes occur. After you try shutting down DataStage again, are there any datastage processes still running?

The Compress stage uses a UNIX command to compress data in the stream. Normally you would output to a sequential file, but I think you can pass data downstream as well. The compress stage as a "pass-through" would only help if you had few but very wide columns. You can use sequential files with comp...

ag_ram - please read and try what Ray said. It is the opposite of what I said, he corrected my error in stating that the parameter prompt could not be avoided.

It is possible. There are a couple of ways you can do this, but the optimal solution depends upon the number of columns and the type of data file (is it a table or a sequential file?) as well as the file size and what database you are using.

DataStage 8 has sparse lookups. The volume of data in the table isn't as relevant as the number of data rows processed through the main link.

In your case you cannot use a text file as described in one PX job. Split the run into two jobs if you wish to re-use a text file.

thanks for confirming what I stated, ag_ram.

For both Windows and UNIX the administrator can choose a different path for each project. The files listed above will be in the project directory.

Then put it into a string of length 40 so the conversion cannot cause an error, and use strnig truncation to copy that into a length 2 column.