DSXchange

Peter - but that means you can save the project to a .dsx file, delete it, re-create it and reload your .dsx file and you'll get the correct server name. I'm not at a DataStage machine right now, but if you to to the TCL prompt and "LIST UV.ACCOUNT" you'll see the hostname in there as part of the re...

The server name is in fact stored at the time the project is created, and that entry cannot be manually changed to reflect a new name.

Sounds like a system change is causing this. Do Server jobs run? If you reset an aborted job, do you get any additional information in the "from previous run" entry?

You can only write to a sequential file from one process at a time. You might change your job around so the multiple instances write to the hashed files simultaneously, and then one more job to run single-instance to write from the hashed files to the sequential one.

Pradeep,

The ICONV/OCONV formats in DataStage are separate for Date and Time components, but it is quite easy to use the MT conversion to get the appropriate time format using "MTH". What is your input format?

How large is the file /the path name /lookuptable.20070214.o2ylidd? Close to 2Gb? What are your ulimit settings?

Parvathi, that overall response is a premium one, since I felt it contained something somewhat more complex than just reading in a manual. As mentioned elsewhere, the premium membership makes that post and many more (and more informative) posts visible and accessible to you. But the important part w...

Are the database and ETL machines on the same frame? If not, the network bandwidth might be the limiting factor in the load. DataStage will probably be able to "feed" the database faster then Oracle can "digest" it. So Oracle configuration might also limit the speed. Certainly partitioning will make...

The DataStage read of sequential files is pretty efficient; and DSParams is small file (if the file had millions of records I might reconsider, but this is going to take milliseconds to process).

chulett wrote:Nah... it's the standard 'problem'...

I should have read the whole post.

Since the DataStage TELNET service listens on port 23 on Windows, you need to specify a different TELNET client port for this to work. Or you can modify the FTP stage login lines / responses. You would have to manually do a TELNET to get the exact texts / prompts, but in addition to the USERID and P...

If you are 100% certain that you are calling the original "uv" command in the $DSHOME/bin path when starting DataStage then you probably have a serious problem; since the SQL server connectivity isn't part of the startup procedure! Can you enter into TCL by calling up "uv" or "uvsh" and get the ">" ...

What is your default language when installing? And at which point of the install do you get the abort?

I would use a variable to store the current section, or "state" while reading the file. Line = TRIM(Line) IF Line[1,1]='[' THEN Section = Line[2,LEN(Line)-2] Then you can put an IF-THEN construct in to check the lines if you are in the section "EnvVarValues"

Sathish321, fortunately all of Appendix A in the Parallel Job Developer's Guide explains this in detail. If you have any questions remaining after looking at that chapter I'm sure that someone here can help.