DSXchange

Geez Ken,

I think you are losing it.

I'm a little teapot short and stout, here is my handle, here is my spout.

Too many babies hath made thee mad.

I do not see that it is a big deal on DataStage's encryption. If you have Director access then you pretty much need to know the passwords. How many people are giving out DataStage clients to users which do not know these passwords? This is not an issue. For national security reasons the USA algorith...

Craig How many files match *. There is a limit in the kernel of how big argv and argc. These correspond to $# in a shell script. Therefore you can blow out these arrays. If you patched your UNIX lately then these can get reset. I would wrap the shell script into one without arguments and try executi...

Craig

Good idea. Try running a normal execute.

When you attach to a job then DataStage makes your current directory the project's directory. Ray was saying that this command will only work in the project directory. I have never used this command in this way so I would trust Ray.

Leroy

Some of the articles I think considered property of Ascential and therefore not to be published except by Ascential.

Are you in the project directory?

The problem is somewhere in your network.

Not that I know of, maybe Ray knows.

Some how it is doing something that it cannot recover from so you are not getting good error messages. Do the same command at the UNIX prompt but be in the project directory. See what happens.

If the last 2 lines are not in the log then you are failing hard meaning you are probably core dumping. Your hash file may be corrupt or your filepath is bad or you need to quote it properly. If there is a space in this filepath then you could be clearing a directory or something other than what you...

I would not change your DSN. Just update the local one and archive onto a shared drive. I have macros which will truncate all the tables and then I compact and repair it. Next I populate it with a new project or the same project with new data. If you keep these access files small they performa bette...

DataStage does require a lot of disk space and it does need to be managed. Staging should be done within DataStage itself in hash files or sequential files. If you do not do that then your ETL will not perform as well as possible. I think whoever made this decision does not understand how DataStage ...

An FTP stage is kind of like reading from a sequential file. I does require a user and password. It starts processing the data before the whole file is read. It is hard to debug connection issues. I prefer ftping in a shell script and then processing the sequential file. Easier to debug. We have had...

By the way the encryption algorithms are supposed to be one way meaning they excrypt what you type in and compare it to what is stored in /etc/passwd or your shadow file. The algorithms are supposed to be different outside of the USA. So your problem should not be valid inside of the USA.