DSXchange

Since the test and production jobs are set as protected in administrator, i am not able to make those jobs as NRO. Something you should have mentioned in your first post and since you didn't that's why I assumed it wasn't the issue. And as you've found and done, you certainly can make the jobs &quo...

There isn't one. 'Node' in a config file is a logical concept and has no direct correlation to any physical nodes your servers may or may not have.

I honestly don't know the difference between whatever function records 15 & 17 provide as that's secret repository, inner circle stuff. :wink: I would suggest your best method to make a mass change like that is to export the multi-instance jobs and make the change to the dsx using your editor of...

Didn't ask you to search for anything... just to have some patience. This is an all volunteer site and people help when and where they can, you should have no assumptions on what kind of help you get here, if any.

Me, it's well past time to get my ass out the door to my paying job.

Well then, hang tight and I guess we'll find out.

You seem to be missing a vital point on how things work here, many many people can see the entirety of Ernie's always very helpful posts.

Float is float so you'll have issues like this. Can you post the "note" from the reference guide you referred to?

behrouz wrote:but i expected some help from experts here which was not the case

How was that "not the case"? You got help from the expert here.

Why not simply check the posts where you asked the same question? :? Never mind, they didn't belong in that two year old thread so I've removed them. And I'll transport Ernie's answer over here so it is in the right thread, the one you actually started. This is simply two "rows" that will ...

How does your routine execute the scripts? You could build your own version of DSExecute taking a cue from ExecSHSilent which removes the step that logs that information.

MT wrote:@Chulett: In DB2 your Oracle explain plan is called explain plan

Good to know! :D

Another option - take the advice in the previous post and write your own version in C++. There's nothing out of the box to do this.

Heve you tried the corrected update that was posted?

You could always promote it again and not check that option.

Have your DBA trace the sessions and see what is going on and if the indexes are being utilized. If this was Oracle I'd tell you to check the "explain plan" but I have no idea what the equivalent is for DB2. Also, I'm guessing each input row deletes a single record from each target? If so,...

Sorry, it just irks me when people post a question and it seems like there's been no thought put into getting the answer themselves, where they just post a problem and then sit back and wait for the answer to fall into their laps. Not saying that is what is going on here, just wanted to get that off...