i got our worst offenders down from 2hrs 48 minutes total to 31 minutes total by simply using frederico's code recommendations on a sister post in this forum.

in the image...

• This reply was modified 1 year, 1 month ago by stan.
• This reply was modified 1 year, 1 month ago by stan.
• This reply was modified 1 year, 1 month ago by stan.

thx ant-green, bear with me as i check with others on our staff if that list of db2 products that can be connected to is what we use in the...

thx ant-green we are trying to get away from the MS db2 driver as its been suggested that is where our performance problem is currently.

i created an ibm id.  and im on a page where i believe i can download their console or drivers but the list of drivers doesnt seem to include a...

hello i was redirected here somehow  https://www.sqlservercentral.com/forums/topic/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help   .

this is appreciated but i feel i am pretty good at all the guidelines that are posted there.

in this case a proctor at...

• This reply was modified 1 year, 1 month ago by stan.
• This reply was modified 1 year, 1 month ago by stan.

here is what i got...my takeaways are that the blanks coming across the network are a factor (at least for our driver) and like the community suggested , waiting to...

• This reply was modified 1 year, 1 month ago by stan.

thx frederico, i might be  misunderstanding.

that view is doing the trimming over on the linked server (sql server) side, not db2.   are you saying it might help to put all...

• This reply was modified 1 year, 1 month ago by stan.

thx jeffrey.  there is no join and we want the whole table.  i was a little confused by these 2 statements   which seem to contradict each other...

or add a where...

thx ken, what are the decent odbc drivers for db2?

and at a high level will i be running wireshark while this issue is occurring and show some sort of output...

• This reply was modified 1 year, 1 month ago by stan.

thx, it is not on this site.   it is a site dedicated to netsuite.   the link i use there is https://community.oracle.com/netsuite/english/post/question/ask-a-guru    .

they have ok'd posting the same question anywhere.

• This reply was modified 1 year, 1 month ago by stan.
• This reply was modified 1 year, 1 month ago by stan.

thx kaj , he cant throw or raise what he cant intercept.  and he would try to do that or handle it in sp1 if he first gets convinced he...

• This reply was modified 1 year, 1 month ago by stan.

my peer believes this scenario has reared its ugly head again.   Something tells me we addressed this once  before by checking a 2nd sql built in count or flag along...

thx Jeff.  He doesnt do any THROWS.

In this case he doesnt have that opportunity in sp2 before control bubbles back up to sp1.

yes he uses xaxt_abort but still at least...

thx jeff.   i believe what we used to solve this went as follows.   i was talking our dba thru this because he has permissions where we wanted it done.  i...

• This reply was modified 1 year, 1 month ago by stan.
• This reply was modified 1 year, 1 month ago by stan.

thx frederico.   we understand.