DSXchange

[quote="ravireddy25"]What are the data integration tools? and will data stage comes under data integration tools?[/quote] Data Integration tools are ones that - 1. Allow you to read / extract data from various systems 2. Allow you to modify data as per the business rules 3. Allow you to lo...

Thanks a lot..This will solve my problem :D

Hi, How can we split input flat file, into multiple output flat files of 1 Lakh records each? For Example, If I am reading 1 million records, I should create 10 output files of 1Lakh records each. Or If I am reading 2 million records I should create 20 output files of 1 Lakh records each. Creation o...

Hi,
Can you please explain a bit on socket?
Can I ask him to kill dsrpc process?

Hi, I am not able to restart the server. Even after uv -admin -stop, I am seeing the dsrpc process. If I give netstat -a | grep dsrpc cmd, I am getting few entires with CLOSE_WAIT status, but currently no one is connected to DS. These entries are there from past 48 hours. Can these be cleared? How c...

Thanks ArndW for all your support and valuable time. I will try to get hold of SA and kill these processes.

Thanks Again
Shesha

I am getting below error - ipcrm: 0515-021 shmid(3145730): The user does not have the appropriate privileges to perform this operation. After stop command, the netstat|grep dsrpc is giving below results tcp4 0 0 172.22.162.228.dsrpc 172.24.130.60.4393 ESTABLISHED tcp4 37 0 172.22.162.228.dsrpc 147.1...

[quote="ArndW"]No, you won't directly be able to kill this process without root access. After stopping DataStage what does the "ipcs -a | grep 0xade" command show? ...[/quote] Below are the results. [/DataStage/product/Ascential/DataStage/DSEngine]$ [b]./bin/uv -admin -stop[/b] U...

[quote="ArndW"]stop it again. Is the dsrpcd still running? (If yes, you can't start again anyway). Use "kill {pid}" to stop it. Enter the command "ipcs -a | grep 0xade" and there should no longer be any segments sho ...[/quote] I dont have root priv. I only have ds admi...

[quote="ArndW"]Perhaps someone used "kill -9"? Are the any DataStage processes left? If you start datastage you should see a "dsrpcd" started as well. ...[/quote] I think it did not stop the server properly. Even after giving stop cmd, I could able to see the dsrpcd. ps...

[quote="ArndW"]Yes, but you need to wait a bit of time between the stop and start and make sure that all processes have terminated. ...[/quote] I am getting the below error while stopping the server - ./bin/uv -admin -stop Unable to remove the following shared memory segment(s) during shut...

[quote="ArndW"]It looks like process 1695892 might be hung. Do a "kill 1695892" and see if the defunct processes go away and if you can login to the client tools. ...[/quote] I killed the process, but still getting same connection timeout error. Can I restart the server by using ...

[quote="ArndW"]Those "defunct" processes shouldn't be there anymore. What does "ps -ef | grep 1695892" show? The PX jobs aren't using any system time, either. The processes show that you still have a couple of client tool sessions open on the system, though. If you stil...

[quote="ArndW"]What is the output of "ps -ef | grep ds"? ...[/quote] There are around 195 entries some of them look like dsadm 495660 253966 0 Mar 20 - 0:00 dscs 4 0 0 dsadm 634960 733188 0 Mar 20 - 0:01 dsapi_slave 7 6 0 dsadm 733188 253966 0 Mar 20 - 0:00 dscs 4 0 0 dsadm 11470...

[quote="ArndW"]It sounds like you have two problems - one is a long run for a job, and the other is no longer being able to login to DataStage from any client. Is there still a process called "dsrpcd" running? If ...[/quote] Thanks ArndW, I am not able to view your entire msg, bu...