DSXchange

Hello, I have the exact same problem as this with DataStage Server 8.1 I have tried to execute the following code from the "Before" tab of the SQL statement in the Oracle Stage: exec dbms_stats.gather_table_stats(ownname => 'MA_ODS', tabname => 'ODS_ITEM', estimate_percent => DBMS_STATS.AU...

chulett wrote:

chulett wrote:Well... you can alway try stopping and restarting DataStage. Worst case reboot the server itself.

This was all about avoiding those two options.

Another solution that worked for my collegue was to simply restart the DataStage server )

You are right, sorry I missed that point! Re-tried with the bin\uvsh , logged into my project, then launched DS.TOOLS, selected 4. Administer processes/locks and then 1. List all processes, then 9. "Logout a process" and then I logged out the processes by using their pid I retrieved previo...

ray.wurlod wrote:dsdlockd -p is a "probe" and should finish fairly quickly.

Then in my case it is a bit strange, I launched the "dsdlockd -p" and it is running and running and running

Should I chose Y instead? There's no reason to ever answer 'Y'. And it wouldn't have asked the question if you were truly in the $DSEngine directory or one of the Project directories when you launched uvsh or dssh. Can you confirm exactly what steps you followed? I probably did something wrong then...

ray.wurlod wrote:In 7.5 you can run the dsdlockd program with -p option. You need to be logged in with local Administrator privilege.

I have just launched this to see what happens for the moment it is still running, I guess.

From the command line: cd $DSEngine bin/uvsh (you should have a TCL prompt ">" now) LOGTO <YourProjectName> DS.TOOLS Hello, and Happy New Year! Thank you very much for your kind replies, so back to work with the same problem, I am trying the above commands first. When lauching uvsh, I am ...

Please help me, have only 2 licenses available, and both are in use by phantom session, that have not been closed properly. I have access to the server side, the server is on Windows. How can I kick off those sessions that are still there although all the clients are closed?

thank you, sorry about not opening my own topic. I guess I have the Enterprise version, but I am not sure how to verify, I'll google it. Otherwise, could you please tell me where to type the grep command? I am typing it in the command line on the server side, and it says - the command is not recogni...

I am having the same problem as noted in this post but with the DataStage 7.5 installed on Windows server, so the grep command doesn't work. What should I do? Please, any suggestion?

Thank you, I am trying this. I was thinking - may be it is related to the execution date used somewhere in the WHERE clause during the updates.

Dear all, We are testing the jobs after their migration from DataStage 7.5 to DataStage 8.7, and we are facing the following mismatch: - there is one job that writes the records to the Hashed File - the same number of records is written by 7.5 and 8.7 versions of datastage. - now the next job reads ...

thank you very much for your help!

Finally, I don't have enough privilege to alter the NLS_LENGTH_SEMANTICS :) Otherwise, I was thinking about the explanation of what is going on: - If due to NLS each character uses 3 bytes, then a CHAR(10 bytes) will store exactly 3 characters. - So depending of the length of my string I am trying t...