DSXchange

You are unable to get exclusive excess and you know how to get rid of it. goto DS.TOOLS and clear the status file and release the LOCK if at all exists on RT_CONFIGNNN. Then after taking the export, you would be able to delete the Job. I hope this will solve your problem, if not then tommorow we wil...

No you can not just delete these files. There is no file which you should get rid of. All of these files have information abt the job and you should not delete any of these files from unix level. The size of RT_LOG1361 is very big and you have to delete the entries from this file. using uv you might...

let me know the size of RT_LOGNNN of the Job

Open the director, it would be the status window.if not then select the 3rd icon from left (next to print Option). press (alt+j+c), you will get a GUI opt for Immidiate purge and specify the dates from when you want to purge the records. This is the simple way of deleting the log entries. If you are...

MFILES = 200
NFILE = 1000

So this is not the problem i hope :D

the status files and RT_CONFIGNNN files for each of the Jobs I wrote it incorrectly, By clearing RT_CONFIGNNN, i meant unlocking RT_CONFIGNNN. It has mentioned in my first reply also to unlock the RT_CONFIGNNN by choosing option 7, and giving the pid of RT_CONFIGNNN. You should not clear any of the...

So that means we got the problem. Now the problem is the bigger log file associated with that Job. you can clear the logs without going to the LOG view. Open your director, then choose Job option from the menu bar and opt for Clear log. Once you have cleared the log, your waiting problem will also b...

Two things you should do 1. Kill all the processe of all the Jobs attached to that sequencer/Applications from unix level and then clear the status files and RT_CONFIGNNN files for each of the Jobs. 2. You should check whether the log as seen from the director log is taking long time to be reflected...

Thanx Kim,

Will try this command and will not use Input and Output togather.

It is occurring from all the client machines. Any of the machine which is logging to the server gets in to hang state.And the task manager shows that the DatastageDesigner is not responding. Where as, if we see the server side, it shows that the connection is ESTABLISHED. I gave all the details of t...

Thanx Ray, It's a good day for me, learnt something new. I always thought that executing these UV commands are possicle only when there is an entry in VOC but was wrong. Need to research the forum for getting to know how to use these commands when the hash file is created in some other directory and...

As Ray suggested, you can use "missing columns" rules for reading the file. Infact in one of our Applications, we have used this method but some how i am not very much comfortable with this approach. There is no technical reason for this but i feel more comfortable with unix level manipula...

I have also tried going into Administrator and running DS.TOOLS -> 5 - 'Administer/process locks' -> 11- 'Clear Status file for a job' but this has also not helped. When you are in DS.TOOLS and you have opted 11 option for Clearing the status file and then provided the Job Name, then once datastage...

I have used this query for getting the names of the Jobs which are referring to the Hash files SELECT NAME FMT '40L', OBJIDNO FMT '6R' COL.HDG 'Job No' FROM DS_JOBOBJECTS WHERE OBJNAME='ROOT' AND OBJIDNO IN (SELECT DISTINCT OBJIDNO FROM DS_JOBOBJECTS WHERE NAME ='HASHFILENAME') ORDER BY NAME,OBJIDNO...

We are having 24 CPU Sun Microsystems sun4u Sun Fire 6800 Server. What should be the value DCWRITEDAEMON for this kind of server. What are the dependent things which are going to be effected once we make changes in this parameter. Are there any other associated parameters also which needs to be chan...