DSXchange

Hi What do you mean by getting SA for help? What is a SA?

Hi What do you mean by getting SA for help? What is a SA?

Hi, Yes, i've already requested users close their session. I even kill all user sessions by using DataStage Administrator. Then only i issues the command ./uv -admin -stop After the above command was executed i issue the below command netstat | grep ds there were 2 sessions which are close_wait Plea...

Hi, I need to shutdown my DataStage but hit the following prolem dsadm@cel059:/data1/Ascential/DataStage/DSEngine>netstat -a | grep ds cel059.dsrpc 10.10.81.154.2001 65535 0 49640 0 CLOSE_WAIT cel059.dsrpc 10.10.81.154.1191 65451 0 49640 0 CLOSE_WAIT 3000616dac8 stream-ord 30009233208 00000000 /var/...

Hi,

Referring to the above

Instruction

Step 3) Enter the DataStage environment (bin/dssh). Prompt will change.

what is the command to execute it?

is it ./dssh or ?

Please advice, my datastage has hung for 28hrs and the session with close_wait has not been release. thank you.

Hi chulett, I've changed my dsenv to the below set +u if [ -z "$DSHOME" ] && [ -f "/.dshome" ] then DSHOME=`cat /.dshome` export DSHOME fi if [ -z "$DSHOME" ] then DSHOME=/ardent/Ascential/DataStage/DSEngine; export DSHOME fi if [ -z "$APT_ORCHHOME" ] ...

Cant read solution! Premium content ! Thank you. I'm just a normal user.

thanks for the help kcbland My dsenv script looks like this : # PLATFORM SPECIFIC SECTION set +u if [ -z "$DSHOME" ] && [ -f "/.dshome" ] then DSHOME=`cat /.dshome` export DSHOME fi if [ -z "$DSHOME" ] then DSHOME=/ardent/Ascential/DataStage/DSEngine; export DSH...

hi, I've done the below Use DS Manager, go to the menu-->Import-->Table Definitions-->PlugIn Metadata-->Oracle 9. Pick the DSN from the drop-down list, enter the login credentials BUT hit the below error: Error while trying to retrieve text for error ORA-12154 There is no drop-down list for me to se...

ok, let me try 1st.

hi kcbland, thanks for the reply. Can you please show me on how to perform this? import metadata? Any reference to refer to?

CIDMDEV DB is located at the same box with the DataStage server. There is one and only job that connect to the database. the sqlplus and tnsping was executed at DataStage server. dsadmin@dwdev/ardent/Ascential/DataStage/DSEngine>. ./dsenv dsadmin@dwdev/ardent/Ascential/DataStage/DSEngine>tnsping CID...

Thanks for your reply. 1 job only fail. This particular job access the DB[CIDMDEV]. I've tried to restart the DB. Still not working. Tried to restart DataStage and still not working. I've already tried alternative way to test the DB but still unable to run my job. Tried using sqlplus to connect , su...

Nope. that didnt help. Please help. URGERNT !!!

Hi, please advice on the below error. Our server has just change its ip from xxx.xxx.xx.x to aaa.aaa.aa.a I've verified our tnsnames.ora file and it is correct but when we run our datastage job, we hit the below error. Please advice on what to do, thank you what else do i need to check? logica_onlin...