Skip to Content
0
Former Member
Dec 23, 2013 at 04:38 PM

Truncate and load slow in IQ 16

23 Views

Hi all,

While testing loading in SAP IQ 16 I encountered the
following 2 issues:

  1. When I truncate a table containing 30 columns
    and 250M rows, it take around 20 minutes (the same take lest that a second on
    IQ 15.2), no one is using the table, no versioning. In the iqmsg file I note several line than contains
    “Modnum conversion skipped during destroy. ui=…”
  2. Loading the 250m rows tale twice the time on IQ
    16 (1.25 hrs) that it take in IQ 15.2 ESD#2 (0.6 hrs).

Configuration file for IQ 16

-n MyIq16Srvr

-x tcpip{port=4600}

#-m

#-c 80m

-cl 256m

-ch 512m

-gc 20

-gd all

-gl all

-gm 100

-gn 150

-iqgovern 100

-gp 4096

-ti 4400

-iqlm 6144

-iqmc 6144

-iqtc 6144

-iqmsgsz 2047

-iqmsgnum 2

Configuration file for IQ 15.2 ESD#2

-n MyIq15Srvr

-x tcpip{port=4611}

#-c 80m

-cl 256m

-ch 512m

-gc 20

-gd all

-gl all

-gm 100

-iqgovern 100

-gp 4096

-ti 4400

-iqmc 5120

-iqtc 4096

-iqmsgsz 2047

-iqmsgnum 2

-xs http{port=8080}

Any ideas about why this difference?

Thanks a lot,

Uvernes