DSXchange

No.

How much disk space do you really have? Solaris is notorious for having a small /tmp file system and for mounting swap there. Choose a non-default temp area, with at least the recommended amount of free space there in addition to the disk space needed to install the actual product. (I don't know wha...

The advice about DSDetachJob is correct.

Do you really want to run this other job for every row you process in your main job? Is there a more efficient way that you could design this? (I suspect the answer to that is yes.)

What you see in the Director is not the actual status of the job. Rather, it's the most recent entry that the job has been able to write to its status file, which is what Director reads. If the job has aborted suddenly (or been killed), then it never gets the opportunity to update its status records...

Show us what's in the Oracle log (ora.61034.798698.0.log). It looks like Oracle has had a problem with what you've asked sqlldr to do. That is, DataStage has successfully generated the data file(s) and control file, but Oracle has not liked some or all of the rows in the data file. These rows will b...

Please post the exact error messages.
Are your JCL templates all intact?
4.x was the first release containing 390 capability; is there any scope to upgrade to a supported release?

You might have more luck posting this in the Consulting (Talent) forum. It might also help if you indicated whether you are eligible to work in the USA.

CPU speed doesn't really matter, though faster processors will get through the same number of cycles in a shorter period. Your question is currently in the "how long is a piece of string?" category. More, slightly slower CPUs can be better than fewer, slightly faster CPUs in a parallel processing en...

Well, why not try it and let us know?

Definitely not if you're expecting to run parallel jobs.
Almost certainly not otherwise; DataStage server requires that at least the file system on which it is installed is NTFS; I believe the Tablet PC does not support NTFS file systems.

The UniVerse query language RetrieVe has a method of performing this kind of recursive query, by using a keyword called WITHIN. I am fairly sure that it is not possible (except to a finite number of levels) using SQL. Essentially you need a tree-traversing routine which continues arbitrarily until t...

The first, and obvious, question is "what's changed?" (apart from the apparent change in behaviour of QS plug-in, of course).
Has anything changed:

at the operating system level?
in the version of software?
in the configuration/location of software?

There is no relationship between LARGE.RECORD and GROUP.SIZE. It looks like you've encountered a bug in CREATE.FILE. Here are some alternatives. Having created the file, change LARGE.RECORD with RESIZE. RESIZE filename * * * LARGE.RECORD 10000 (a multiple of 8 bytes is preferred) Having created the ...

Prefer SQL to RetrieVe. By default, SQL doesn't generate headers, initial form feeds, and the like. SELECT UNIQUE.PATH FMT '256L' FROM UV.ACCOUNT WHERE @ID = 'DGI'; To execute this from a UNIX shell you must be in a directory in which a pointer to UV.ACCOUNT exists. This happens when DS.TOOLS is use...

Ask yourself this question. "Could I automate the generation of 200 sqlldr control scripts?" If the answer is yes, then the DataStage answer is also yes. If the answer is no, then the DataStage answer could still be yes, but not without adding some specialist knowledge about how table and column def...