DSXchange

As discussed in other post which I tried to post, if you update the DS_JOBS without updating the relevent DS_JOBOBJECTS, you may likely to loose the intergrity between the two hashed files. That that too is done for sure on REINDEXing ALL the hased files. Since you have reverted back and deleted tha...

Does the DS.TOOLS option give you anything at all? Here's one on a project with a Manager and Designer connected: DataStage Process and Lock Administration 1. List all processes 2. List state of a process 3. List state of all processes in a job ---------------------------------------------- 4. List...

Arnd - May I know what is the intention of RESIZE DS_JOBS * * * Will it give out the integrity of the indecies. It seems it requires an Exclusive access to DS_JOBS, so I could not test it now.

I searched. Went into the link. (Opened the post). Copied the available URL of the post directly and pasted. It still gives me those sid stuff.
Is there any otherway you provide the search results.
To topic of the post would be "RenameAllJobs - Easy ?"

Delimeted file shouldnt stop you from this aproach.
cut -d 'x' n file | sort -u | wc -l > tempfile.
Where x is the delimeter used. And n is the required nth column.

Do you mean to say, Old jobs, still exist along with new names
Can you provide the update statement used?
Have you reindexed only DS_JOBS or ALL after renaming DS_JOBS.

DS_JOBOBJECTS also need to be updated.
Have a look at this discussion regarding the renaming job.

For first time I pressed 5 then 4, it didnt gave me the list of locks. But for second in the same page I pressed 4, it gave me out the results.
I tried this form several project.
You too can try.

Have you updated DS_JOBOBJECTS accordingly?
You reduilt indices for ALL or for DS_JOBS?

Make sure you are connected in the project. Try for the same in TCL.

Good catch. But in that case Alt + F give the menu from where it is hidden. Lets see if this helps Greg's problem.

You can accomplish with single sort stage with keyValueChange option. Assigning the col1 as key. (With the same as hash partitioned)

fi is some thing like END IF or END for the IF condition.
$1 and $2 is the 2 parameters passed to the shells. And yes inturns they reflect Temp_File and Actual_Target.

Its better you can search on 'Virtual Dataset' and have a look into it, so that you can easily find the difference and understand persistent dataset.

Dont try to clear the status file before clearing the lock being held. Check in the DS server whether the process is still running.