thank you.   it looks like ibm i is listed on that one link's product supported list i showed.   i'm not sure but i dont think that is free.

since it looks...

the site our network guy was referring to is https://www.ibm.com/support/pages/db2-odbc-cli-driver-download-and-installation-information#%5B%3Ch2%3E%5DLicense%5B%3C%2Fh2%3E%5D , which he got initially from me.

thx kaj, we are querying it in sql off a linked server.  i'm no expert but i believe we still have/want to go thru a driver (installed on our sql...

thx kaj, we are querying it in sql off a linked server.  i'm no expert but i believe we still have/want to go thru a driver (installed on our sql...

thx Ken.  Still trying to get our staff to tell me what the db2 erp they use is called.   ARGHH.  From what I've seen that might restrict our choices of...

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 11 months, 1 week ago by stan.
• This reply was modified 11 months, 1 week ago by stan.
• This reply was modified 11 months, 1 week 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 11 months, 2 weeks ago by stan.
• This reply was modified 11 months, 2 weeks 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 11 months, 2 weeks 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 11 months, 2 weeks 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 11 months, 2 weeks 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 11 months, 2 weeks ago by stan.
• This reply was modified 11 months, 2 weeks ago by stan.