DSXchange

You posted this question 4 times in as many minutes. Since many of the people who frequently respond will browse all the forums for new messages, this type of approach works really well in getting no answer . Since you posted in both Server and Px nobody will know what you are actually using and the...

Do you have RCP turned on?

When you open a file for writing it positions itself to the beginning of the file. If you wish to append to the file on a subsequent run you need to issue a "SEEK FILE,0,2" to position to offset 0 relative to the end of the file.

If your first line is column names then you can import that metadata. Other than that you will have to manually type in the remaining information, as DataStage has no way of knowing that metadata. You confused me originally with (Say a Data set file having 100 columns). since I thought you meant a P...

Where did you change this environment variable? You will need to set it in the dsenv file in the DataStage home directory in order for it to take effect.

Yes, you can automatically import many types of metadata. What kind of metadata do you have for these columns (i.e. a COBOL copybook or access to your Oracle tables or an ODBC connection)?

Recall also that hyperthreading relates to "threads" as opposed to actual Windows or UNIX processes. Since the product is not multithreading there performance gains with hyperthreading are minimal in DataStage. Turning on the hyperthreading on IBM's P-Series brings no performance gain for PX or Serv...

There is no finished utility that will do this for you, particularly since your format in Oracle or the log information is your own. You can design your own queries for historical run information, but I don't think there is anything out there that will do this for you.

UniVerse is one of those older products that was initially designed with uppercase only. You can switch around the case changing using the command "PTERM CASE NOINVERT" and turn it back on with "PTERM CASE INVERT". I use this for cut-and-pasting as well. Remember that the command line is case sensit...

You can use either interchangeably, so it is just a matter of personal preference. You can also use the backslash as a quote character if you really want to, so a string of the form \He's a real "DataStager"\ is valid as well.

check UNIX access rights on the RT_STATUS4 and RT_LOG4 files as I mentioned earlier. Does your user have write permission?

Can you create a new dummy job and compile it? If not, then you have an error in the RT_nnn files. If it is only for the old 4.x jobs that have been imported then it might be some other issue. Can you do a "save as" another name and compile the job? If yes, you have a UNIX permissions issue on the f...

Atul, without detailing exactly what happens there is little anyone can do. It is like asking a doctor for a diagnosis after saying "Sometimes I don't feel so good". What sort of jobs are they (do they connect to a database?). When they run continuously are the number of records processed stuck at s...