Search found 52 matches

by Etler21
Wed Jun 29, 2011 7:01 pm
Forum: General
Topic: DS Server is running but showing Not Running.
Replies: 31
Views: 13512

Once you clean these processrun the othercommand which i gave.. netstat -aA|grep dsrpc and these command will give you addresses which are ocuuoied by the ports and then u can clean those address useing rmsock.. U is in Singapore, rohitaagarqwal15 is not, as far as I am aware. I don't think it will...
by Etler21
Wed Jun 29, 2011 10:38 am
Forum: General
Topic: DS Server is running but showing Not Running.
Replies: 31
Views: 13512

This is the output when i run the command bash-2.04$ ps -eaf|egrep "dscs|dsapi|phantom|osh|orch" a1204111 667684 225502 0 Jun 27 - 0:00 dscs 4 0 0 a1204111 1060970 225502 0 10:35:58 - 0:00 dscs 4 0 0 a1204111 1232974 1377064 0 Jun 27 - 0:17 dsapi_slave 7 6 0 a1204111 1319092 225502 0 18:0...
by Etler21
Tue Jun 28, 2011 2:23 pm
Forum: General
Topic: DS Server is running but showing Not Running.
Replies: 31
Views: 13512

yes..use this command and paste the output. netstat -a |grep dsrpc bash-2.04$ ipcs -m|grep ade ipcs: 0515-001 No valid name list found in /unix. bash-2.04$ netstat -a|grep dsrpc tcp4 0 0 CNDAMBCSDBDT04.dsrpc 10.24.63.108.1138 ESTABLISHED tcp4 0 0 CNDAMBCSDBDT04.dsrpc 10.24.63.235.neod2 ESTABLISHED ...
by Etler21
Tue Jun 28, 2011 2:17 pm
Forum: General
Topic: DS Server is running but showing Not Running.
Replies: 31
Views: 13512

can you please run following tow commands -

ps -eaf|egrep "dscs|dsapi|phantom|osh|orch"Ideally this commands should not return anything if your engine is down and there are no open connection

netstat -aA | grep dsrpc
It should only return "Listening" Ports.
by Etler21
Mon Jun 27, 2011 9:03 pm
Forum: General
Topic: DS Server is running but showing Not Running.
Replies: 31
Views: 13512

yes..use this command and paste the output.
netstat -a |grep dsrpc
by Etler21
Mon Jun 27, 2011 8:47 pm
Forum: General
Topic: DS Server is running but showing Not Running.
Replies: 31
Views: 13512

Also check what is the status of your port..i think you will also require port cleanup and then recycle the engine.
by Etler21
Wed Jun 22, 2011 12:37 pm
Forum: General
Topic: Audit requirement
Replies: 4
Views: 1134

any thoughts...anyone ???
by Etler21
Mon Jun 20, 2011 7:49 pm
Forum: General
Topic: Audit requirement
Replies: 4
Views: 1134

Thanks duke,I understand we can't track password which are behind **** but I am more concern about those which shows up in director e.g. if some has used a truncate script in pre/post job execute command and if this script contains a password then it will show up in director logs.I want to catch the...
by Etler21
Mon Jun 20, 2011 1:39 pm
Forum: General
Topic: Audit requirement
Replies: 4
Views: 1134

Audit requirement

we have an audit requirement to find all those jobs which have hardcoded passwords for Database connection.I know I can open each job and check all the stages but this is an enormous task to carry out.. Is there any other way like a universe query to find this??? Any input will be a great help for m...
by Etler21
Thu May 19, 2011 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Date fatal error
Replies: 12
Views: 5611

Something like this should work fine

StringToTimestamp((lk_read.sheet[1,4]:'-':lk_read.sheet[5,2]:'-':lk_read.sheet[7,2]) : "-" : "00" :"." : "00" :"." : "00" )
by Etler21
Wed May 18, 2011 2:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Slow performance
Replies: 3
Views: 2228

Slow performance

Many of us might have heard complains from users that Their jobs are running extremely slow in production and how do we make it finish,Since this is production so we can't make any changes to the job but Yes we start looking around other things like CPU,Memory,Network,Job design,DB locks etc... I do...
by Etler21
Mon Mar 28, 2011 2:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: A simple query
Replies: 1
Views: 1073

A simple query

I have a DS job having only 2 stages,One Oracle stage to invoke select query which fetch data from a table and then a target oracle stage which update few records. There are no direct insert and no internediate stage. Should I add an intermediate stage like copy or Xformer beween source and target o...
by Etler21
Sun Dec 12, 2010 5:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: failover design
Replies: 2
Views: 1278

Ray,We have just migrated our 7.5.1 environments to 8.1,Its not so soon when we are going for 8.5. Right now I want to design my failover in such a way that Server A can be faiolver to the Server B when something goes wrong with ServerA. A and B will be running in parallel,we have Veritas clustering...
by Etler21
Sat Dec 11, 2010 8:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: failover design
Replies: 2
Views: 1278

failover design

Hello everyone, We are planning to design Failover system for our 8.1 environment which is installed on single server.I am sure people might have done it long before so I need help from experts on "How to design failover system".Please share your experience,best practices,guidelines or any...
by Etler21
Mon Nov 15, 2010 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Server 8.1 with parallel processing
Replies: 5
Views: 3008

Run this -

*****This comment information has been removed by the Editor*****


Change the crediential as per your environment..