Re: Slow extraction on AS400 - Qlik Community

Report Inappropriate Content · ‎2012-09-30

Hi all,

I'm using AS400 as a datasources and currently I'm facing a bad performance when qlikview extract data from AS400, one table only.

This table have 65 of column and around 8million of records, the extraction will took around 6 - 8 hours.

Questions:

1. Is the cause because of the number of columns?

2. or network? because AS400 is not in the same server.

3. The ODBC driver version? which version is the best?

4. How to optimized the extraction time?

Thank you

Anonymous · ‎2012-10-03

Hi,

Better schedule a data transfer from AS/400 to Qlikview server and then access the data locally. So do we.

Report Inappropriate Content · ‎2012-10-03

Hi Carlos,

what do you mean by data transfer from as/400, what is the type of that data?

thanks

Anonymous · ‎2012-10-03

Hola,

The data type is .dif :

QlikView:

Saludos,

Carlos

De: BayuAditya <qcwebmaster@qlik.com>

Para: carlosc <carlosc@colombit.com.co>,

Fecha: 03/10/2012 05:30 p.m.

Asunto: - Re: Slow extraction on AS400

QlikCommunity

Re: Slow extraction on AS400

created by BayuAditya in Connectivity and Data Sources - View the full

discussion

Hi Carlos,

what do you mean by data transfer from as/400, what is the type of that

data?

thanks

Reply to this message by replying to this email -or- go to the message on

QlikCommunity

Start a new discussion in Connectivity and Data Sources by email or at

QlikCommunity

| Terms of Use | Software EULA