the performance of SQL LOAD decrease in IDS11.50FC
Hello,
One of the customer will use IDS11.50, previously they use IDS10UC4, they
install two instance in the same machine, one is 11.50, the other is 10.0,
both of them use the logical volumn in the same volume group. when they do the
SQL load testing on those two instance, they find IDS10 is two time faster
than IDS11.50.
I paste some configration and testing scripts, please help to check.
1. some import configration in IDS10
PHYSDBS phydbs
PHYFILE 480000
NUMCPUVPS 5
AFF_SPROC 1
AFF_NPROCS 5
NUMAIOVPS 2
NETTYPE soctcp,2,200,CPU
cleaners 8
logbuff 128
physbuff 128
shmvirtsize 800000
lru_max_dirty 60
lru_min_dirty 50
ra_pages 16
ra_threshold 15
BUFFERPOO
size=4K,buffers=300000,lrus=16,lru_min_dirty=50.000000,lru_max_dirty=60.000000
2. some important configration in IDS11.5
PHYFILE 4000000
VPCLASS cpu,num=5,aff=1-5,noage
vpclass aio,num=2
NETTYPE soctcp,2,200,CPU
cleaners 8
logbuff 128
physbuff 128
shmvirtsize 1024000
ra_pages 16
ra_threshold 15
BUFFERPOO
size=4K,buffers=4000000,lrus=16,lru_min_dirty=80.000000,lru_max_dirty=90.000000
AUTO_AIOVP 1
AUTO_CKPTS 1
AUTO_LRU_TUNING 1
3. Table schema
drop table abpf20_tmp1;create table "cbsbg".abpf20_tmp1
(
ab20dpnoa char(11),
ab20acid integer,
ab20numt integer,
ab20saseq integer,
ab20cur char(2),
ab20notexc char(1),
ab20date char(8),
ab20dateit char(8),
ab20brief char(3),
ab20dc char(1),
ab20amt decimal(16,2),
ab20bal decimal(16,2),
ab20trcod char(4),
ab20acno char(32),
ab20dpno char(11),
ab20stan integer,
ab20opr1 char(10),
ab20opr2 char(10),
ab20attr char(5),
ab20amr decimal(18,2),
ab20amrfb decimal(18,2),
ab20enseq integer
) extent size 32 next size 32 lock mode page;
4. Load scripts:
load from abpf20.txt insert into abpf20_tmp1;5. The aix version is 5.3, TL 11
Any suggestion will welcome.