DSXchange

DSguru2B wrote:This smells like an interview question.

I didn't notice that until I looked at all of his posts. Certainly taken together nothing but fishing for interview answers.

Is this Servre or Parallel Extender?

In Server the limit to a variable is however much virtual memory the process has (basically a very, very long string).

PX uses explicitly declared variable types and lengths.

You will need to issue a command line:

db2 connect {options}
db2 set schema {options}
db2 SELECT {blah blah, options}

Ravindrag, Are you sure you want to do this? The DataStage Sequential file stage does this in a quick, simple and understandable manner. If you really wish to write a script you will find many examples in this forum using search . The main components will be: - OPENSEQ to open the sequential file - ...

Do you have MKS toolkit installed? If yes, do a "fuser -fux {filename}" when the problem happens again. I don't know what normal Windoze commands will get the same information about who has a file open but it ought to be possible. I think you'll have to wait until the problem happens again before tr...

Ahh, that is different and explains the questions. As you already have thought, both products will use CPU and I/O and might compete for the same resources at the same. Each installation is different so it is tough to generalize. Usually DataStage is installed on a dedicated server. If you don't hav...

Latha, if you are in the designer can you do a "view data" on your source .csv file? I don't understand your last post, several people have mentioned that your file might be open via another process and that this is could be causing your abort; but you haven't seemed to respond to that. Did you rena...

You cannot "call" HTTPS in DataStage jobs. The "s" on the end of the protocol name stands for "secure" for the encryption between the server and the client. How do you imagine that this secure communication will affect your Server jobs?

You can't overcome the problem. As others have already pointed out, if the file is open for writing by another process then DataStage can't open it. Perhaps the user who created the .csv (perhaps from Excel) still has it open or some other program has it open. If you have the mk toolkit installed yo...

There is no reason to change your original post, I just meant that if you had put that information into the first entry we would have known the cause of the problem right away. It "hangs" for 30 minutes while it waits to get permission to open the file - and then times out.

I suppose that this job hangs for 30 minutes and then give the error message. Adding that to the original post would have helped immensely

kcbland wrote:The best conference EVER was in Orlando in 2000

. I think the best KICKOFF ever was in Texas - when they gave us a whole video arcade with unlimited use of all the games and rides and free alcoholic drinks all night. Now that was a childhood fantasy come true...

Ken - Does IBM use "Booth Ladies"?

Ken - are you taking pictures for the web site?

embedded space in the filename (put quotes around the name)? access right?