DSXchange

Andrw...here is the o/p

The output doesn't make sense. What were the 2 other commands you ran? The output of the "ps -ef | grep osh" should give pids as well as text references to jobs. How did you get from there to job numbers? Yeah it did give me pid and some text along with RT_SC 3122 . I got the job number a...

There is a job which is running since last month. I came to know when I executed this command. ps -ef|grep -i osh But When I look for this job it is not in DataStage. cannot find job jobname Did a grep on the jobnumber The file *3122 does not exist do I have to run a DS.CHECKER now? it seems the job...

got this when trying to view uvconfig, it did open after i got this message 5 times.

any ideas what's causing this?

Thanks [/code]

yeah it is working, it was a dba issue.

yes i can connect to the database from ds server

Hi, Any insights on this error message? DB2 Driver Embedded SQL message: SQL29007N Unable to communicate with the Query Controller. ; sqlcode = -29007; sqlstate = Failed to connect to database. Error Idx = 9; DB2 Driver Embedded SQL message: SQL29007N Unable to communicate with the Query Controller....

ray.wurlod wrote:In an SMP environment the fastname is the same for every node.
In an MPP environment more than one fastname is used. ...

Ray, how would we know if our environment is MPP or SMP?

I guess Ray meant that do a select on the RT_CONFIGxxx and see if it returns any records?

Thanks Ray...The network team and DBA's will be involved. I am happy it is not a DataStage issue

What is this related to, is it a locking issue?

chulett wrote:After some inactivity time? That would be normal unless you've set your installation to 'Do Not Timeout'. ...

yeah it is do not timeout....

is that a good practice?

ray.wurlod wrote:One from localhost, one from the real dsrpcd. Don't know why. Does it affect client connectivity? ...

yup client session gets disconnected after some time

When doing a netstat on 31538

I am getting two LISTENING outputs

tcp 127.0.0.1.31538 LISTEN
tcp 31538 LISTEN




Any thoughts?
Thanks

229 ERROR = Pin%%V0S1P1.REJECTEDCODE 230 WHILE NOT(ERROR) 231 * Stage variable evaluation 232 IF STAGECOM.TRACE.STATS THEN CALL $PERF.BEGIN(-2) 233 V0S1.Stagevar%%1 = Pin%%V0S1P1.Column%%12 234 V0S1.Stagevar%%2 = Pin%%V0S1P1.Column%%12 235 V0S1.Stagevar%%3 = if len(trim(computeTCV(Pin%%V0S1P1.Colum...