DSXchange

Are you running out of disk space on your resource disk (where the Data Set data files will be placed)?

Use the LIST.READU command to find out the owner of the lock. This is most easily done from a UNIX prompt $DSHOME/bin/list_readu | grep jobname Can you see that user (process) in the Cleanup Resources window in Director? If so, release the lock from there. Otherwise, use the DS.TOOLS menu in the pro...

Which of these have you declared as Key columns? That should determine what to use in UtilityHashLookup. What is the intent of SEPARATOR? Why are you trying to pass a job parameter in a Routine activity? Hashed files' names are case sensitive. Did you really create the hashed file in your account (p...

Has the file system become full? Has a disk quota been exceeded? Is the hashed file intact (what happens when you attempt to count the records in it)? Please confirm that your column definitions show two Key columns. Please execute the following command from the DataStage command prompt and post the...

Only by trial and measurement. There are no magic formulae. Array size is not really about optimizing select/load; it's about optimizing traffic between DataStage and Oracle.

The error is that you've told DataStage to look for the record delimiter and it hasn't found it, giving up after twice the described length of your field. What did you specify as the record delimiter character? Is this correct? Note that final delimiter is NOT the same thing as record delimiter; a f...

If what you want to do is identify those rows in the reference Data Set that were not touched by the Lookup stage, without using any more stages, the answer is no. With more stages, the answer is yes. You need to capture the distinct lookup keys that came from the stream input, downstream of the Loo...

Otherwise, perform your Extraction and Transformation into a staging area (Data Set). Load Oracle from that (in a separate job) when it's all ready.

Just checked the help on XCOPY. Maybe you need a /D switch? /D:m-d-y Copies files changed on or after the specified date. If no date is given, copies only those files whose source time is newer than the destination time. Yes, I'm running out of ideas, and clutching at straws.

Monitor your system, using a tool like top or sar or similar. If you have spare capacity, you're OK. If you have no spare capacity, you should reduce the number of concurrent jobs until you do have some spare capacity, or add more capacity. It's probable that some of the smaller jobs could be run on...

Can you include a test for %ERRORLEVEL% in the BAT file, and maybe pass control to some code that displays the actual command at that point.

Perhaps you could also try quoting the pathnames.
For example xcopy "%2"\*.* "%hashbackpath%" /e /y

I would have said "succinct". But what Craig says is apposite. You can't assume that your reader understands what you mean if you shorten things too much. Try for more explanation, particularly if the poster's post count is low (suggesting they're new, at least to posting here).

Re-boot Windows so that you can be certain that port #23 is cleared. Then start the DS telnet service from Control Panel if it doesn't auto-start on re-boot.

You can use the Documentation Tool (Reporting Assistant) to dump most of the design-time information from server jobs into an Oracle database. They even provide Oracle scripts for creating the said database. Look in the Documentation Tool folder where your DataStage client is installed. Why re-inven...

Reverse engineering is explicitly forbidden in your DataStage licence agreement. Given that you've admitted that this is what you/your company is doing, I feel constrained from assisiting further in this thread. IBM's copyright police are famed for their vigilance and preparedness to litigate. Knowl...