topic Bad Performance QV11 SR2 via ODBC from iSeries in QlikView

Bad Performance QV11 SR2 via ODBC from iSeries

marco_81 — Tue, 23 Oct 2012 16:58:59 GMT

I have installed QV11 SR2 on our Test Server .

The Dataload via ODBC from our iSeries takes ~ 3 Times longer than with SR1 ...

from 50 Minutes to over 3 Hours !

... does anyone make the same experiences?!

Re: Bad Performance QV11 SR2 via ODBC from iSeries

Thu, 25 Oct 2012 07:25:05 GMT

We have exactly the same experience. Unfortunately we have worse performance, 6 times longer.

We upgraded two days ago from 10 to 11R2.

Re: Bad Performance QV11 SR2 via ODBC from iSeries

marco_81 — Thu, 25 Oct 2012 08:22:47 GMT

... Do you also have Problems with the iseries odbc or do you use a other odbc Connection (MySQL ...)

Re: Bad Performance QV11 SR2 via ODBC from iSeries

Thu, 25 Oct 2012 08:52:23 GMT

yes, iseries odbc.

Re: Bad Performance QV11 SR2 via ODBC from iSeries

ggerber — Thu, 25 Oct 2012 15:10:18 GMT

I have experience the same issue when upgraded from IR to SR2.

I use System i Access for Windows ODBC data source.

Result was that I revert back to IR

Re: Bad Performance QV11 SR2 via ODBC from iSeries

Mon, 29 Oct 2012 13:01:52 GMT

We also have "similar problem", but after diagnostics. the problem on our end is the distribution engine.

We use the standard server license and we limit to the distribution engine to 4 concurrent reloads. After a period of time (# of hours) that we see normal behavior we get into a situation that we see more than 4 qvb.exe processes and pending tasks are stuck.

It looks like the tasks have finished their run, the process is not closed and the distribution engine still counts the task are running, so new tasks cannot be run.

we reverted to qv11 sr1

Re: Bad Performance QV11 SR2 via ODBC from iSeries

dirk_konings — Mon, 05 Nov 2012 08:24:22 GMT

We have the same problem. Has anybody a ticket-id @ support ?

Re: Bad Performance QV11 SR2 via ODBC from iSeries

wunderch — Tue, 27 Nov 2012 07:01:30 GMT

We have the problem too.

Is there any answer from qliktech?

Re: Bad Performance QV11 SR2 via ODBC from iSeries

marco_81 — Wed, 19 Dec 2012 08:56:37 GMT

Our Service Partner opened a Ticket, but they don't receive an usefull answer from QlikTech... they will confirm the bug but don't have a solution yet.

Maybe all of us have to report the Problem to QlikTech to increase the presure ...

Re: Bad Performance QV11 SR2 via ODBC from iSeries

Wed, 19 Dec 2012 10:12:23 GMT

Hi all,

Here is the answer I received from QT:

"It is a conflict between the new features and how QlikView works against this database. It will be fixed Q1 next year, but we can not establish an absolute date. The bug has top priority. We highly recommend users to use the previous version.”

Re: Bad Performance QV11 SR2 via ODBC from iSeries

rbecher — Wed, 19 Dec 2012 10:34:31 GMT

Hi all,

in the meantime you could try out the JDBC Connector if you don't want to step back with the SR: http://bit.ly/Kzj7YB

http://bit.ly/Kzj7YB

- Ralf

Re: Bad Performance QV11 SR2 via ODBC from iSeries

marco_81 — Tue, 19 Mar 2013 08:19:58 GMT

Has anyone heard some news about a fix ?

I have tried QV11.20 SR1 (from 15.03.) and the Problem is still the same...

Re: Bad Performance QV11 SR2 via ODBC from iSeries

ggerber — Thu, 21 Mar 2013 18:33:10 GMT

This is the reply I got from Qlikview. Havent test it yet

This email contains download links for the installation files for your customer patch which fixes defect from case 00132430. Bug 53037: Upgrading from v11 SR1 to v11 SR2 slows down reloading, is now therefor considered solved.

Please make sure that all sensitive data is backed up before deploying this patch. By accepting the patch terms and conditions, the end user agrees to install and provide QlikTech with confirmation by email that the patch fixes the associated defect.

QlikTech support always recommends customers running a customer patch to update to the next service release when available.

Links:

64 bit Server MSP

http://d1cf4w4kkla6tb.cloudfront.net/Customer%20Builds/11.00/11480/_MSI/_MSP/QlikView%20Server%20Patch%20X64/Patch/QlikView%20Server%20Patch%20X64.11480.exe

64 bit Desktop MSP

http://d1cf4w4kkla6tb.cloudfront.net/Customer%20Builds/11.00/11480/_MSI/_MSP/QlikView%20Patch%20X64/Patch/QlikView%20Patch%20X64.11480.exe

Kind regards,

Erik Gustafsson
QlikView Support

Re: Bad Performance QV11 SR2 via ODBC from iSeries

marco_81 — Fri, 22 Mar 2013 13:49:55 GMT

Okay the Patch works... i have installed QV11 SR2 on our Test Server and after i applied the Patch.

... i hope QlikTech will also apply the patch to the next release ?!

Re: Bad Performance QV11 SR2 via ODBC from iSeries

wunderch — Mon, 15 Apr 2013 05:00:34 GMT

Is there a bugfix for the Version QV 11.20 SR1 too?

Re: Bad Performance QV11 SR2 via ODBC from iSeries

Sat, 01 Mar 2014 14:55:18 GMT

Erki,

Do u have a patch for SR5?

Best regards