DSXchange

Got it. I did ps and I did not find it in prod, development and test environments. I am in process of trying to convince people to do this as I cannot directly implement this change in Prod. The thing is, I am not sure if there will be any repercussions elsewhere in the processing if I enable this d...

Thank you very much, Ray and Craig, for your responses. Incidentally, it's dsdlockd (not dslockd) so you might want to try your ps command again. My understanding from Craig's post is that if the "start" value is '0', then it means that the "dsdlockd" process is not ON. Am I righ...

Well, it seems you know enough about the deadlock daemon to know that the actual process name is 'dslockd'. :wink: :lol: I did a quick little search before I posted and so it appears that I know the name of it, but in reality that was the first time I saw this name. :) I opened up the file "ds...

Forgot to mention one more thing, I did:
and it returned nothing. But, I ran this when there were no jobs running.

...do you have the DataStage deadlock daemon running? Thanks Ray, for the response. I do not know anything about the "dslockd" process. I am unsure if I could check whether it should run continously or it should/will run only during job execution. Can you provide some more info about this...

Ray - You are right on. That is what has happened for this particular process. However, it took 15 minutes for it to return anything, so he killed/terminated it. :?: But, my confusion/question is, why did it keep running even after he terminated that connection from Web console? Also, this is happen...

Gurus, Off late, we are having all these processes which got created during the job runs getting stuck/hung up. The problem is, they are chewing up a lot of CPU. There are also a lot of locks being created which are not getting released. I have an earlier post about this problem. Just today, we had ...

Hey,

Please try doing the following within the Uservariable activity:
We execute a shell script to get the loop values and we use this command at the end. Please try this and see if it helps

Craig, I did search here and found some interesting topics, but I couldn't resolve with that knowledge. The issue was, one person at a time is able to log-in and others were not able to. Right now, it is not a problem (we are able to log-in to the Director), but it got me very curious as to the rela...

Hello all, Today, we had a problem with logging into Production environment to check on some processes that we are running. The issue was that, when we try to log-in, it says that the Project is locked . Not just this project, we were not able to log-in to any project on Prod . The irony is, one - a...

I had a similar experience with the ODBC stage. I created the table and then ran the job, which I am sure you are also doing now. I really wonder what's the problem!

As Craig is suggesting, look into commiting more frequently. For now, check the log file space and see if it getting full.

If the data volume is what you mentioned here, then I would do an "all or nothing" commit in the database.

When you say you want a config file to connect, are you thinking of fetching the files directly from your local workstation using DataStage? If so, I am afraid that is not possible. As Craig suggested, you could FTP/SCP the files over there (to Unix) or vice versa and run your DataStage jobs.

Check with your Unix/Linux admin to see if anything unusual is getting logged on the OS side.