DSXchange

Did this happen only once or is it reliably repeatable?

The result of division by zero is, by definition, undefined.

Server job (as marked) or parallel job (as posted) or sequence?

Control files for Data Sets are stored at whatever pathname is given in the Data Set stage. The default location is the project directory, NOT the resource disk directories. Craig made the point that the file name of the data file CONTAINS ".ds", rather than ENDS IN ".ds". Only a...

Look at your configuration file, particularly the "resource disk" sections. One of these will refer to that particular node1 folder. Resource disk is storage for data files of Data Sets, File Sets and Lookup File Sets. Do not delete these data files directly; do so via the control file (th...

That's in the Import menu.

Don't use @DATE and @TIME, because these are set when the job starts and are not updated while the job runs. Prefer Date() and Time().

Through DB2 plug-in stage that connects via DB2Connect.

there is one column by 13 (char) byte length in all files, the other columns are between 1 byte to 5 bytes in all hashed files. the maximum concatinated lenght for the key columns about 18 - 22 bytes (char) Plug those numbers into Hashed File Calculator and see the recommended size. Choose file typ...

... and now every user is a DataStage Administrator. Did you really want that?

What other load is on the machine? What CPU resource consumption is indicated by the Monitor? Are you monitoring the operating system separately? If so, what results obtain?

Logs ARE stored on the server machine, in tables in the DataStage repository (I note that you are on version 7).

Job logs are NOT files. They are database tables.

Search for "RT_LOG" to get way too much information.

Hard to say with no information about how you specified things in the SCD stage. How about you provide more detail?

Its very obvious that Datastage server located in windows can read excel seamlessly. Nothing is obvious to beginners. And accessing Excel worksheet "table definitions" (metadata) through ODBC is non-intuitive; the driver reports each worksheet as a system table, so you have to check "...

my datastage server located on windows. Then why did you mark it as UNIX? Arnd's answer about ODBC driver for Excel still applies, but you get one with Microsoft Office - if you have Excel then you have the ODBC driver for Excel. Just don't create a user DSN - DataStage requires either a system DSN...