AIX+GPFS+DB2 DPF数据仓库架构性能难题（技术交流）
环境描述：1，AIX:7.1 GPFS:3.5.0.11 DB2：9.7.0.62，两套AIX，每套AIX上 2*db2 partitions;3，某表空间跨了这4个分区；2个分区分布在一个物理设备上，另2个分区分布在另一个物理设备上。4，测试时候发现delete/insert数据特别慢（删除1000万条数据需要2小时），传统架...显示全部
查看其它 10 个回答mycortex的回答
Configuration data for cluster p740a5_a6_cluster.p740a5_boot:
-------------------------------------------------------------
myNodeConfigNumber 2
clusterName p740a5_a6_cluster.p740a5_boot
clusterId 4184504402172605735
autoload yes
dmapiFileHandleSize 32
minReleaseLevel 3.5.0.11
tiebreakerDisks edwnsd;edwinstnsd;edwviewnsd
pagepool 4G
worker1Threads 1024
usePersistentReserve yes
maxblocksize 2048K
prefetchThreads 256
adminMode central
File systems in cluster p740a5_a6_cluster.p740a5_boot:
------------------------------------------------------
/dev/TBS_CFG_DATA
/dev/TBS_CFG_INDEX
/dev/TBS_EAST_DATA
/dev/TBS_EAST_INDEX
/dev/TBS_IPD_DATA
/dev/TBS_IPD_INDEX
/dev/TBS_PISA_DATA
/dev/TBS_PISA_INDEX
/dev/TBS_SUM_DATA
/dev/TBS_SUM_INDEX
/dev/TBS_SYS_TEMP
/dev/TBS_TRANS_DATA
/dev/TBS_TRANS_INDEX
/dev/backup
/dev/edw
/dev/edwdblog
/dev/edwfenc
/dev/edwinst
/dev/edwview
/dev/test
-------------------------------------------------------------
myNodeConfigNumber 2
clusterName p740a5_a6_cluster.p740a5_boot
clusterId 4184504402172605735
autoload yes
dmapiFileHandleSize 32
minReleaseLevel 3.5.0.11
tiebreakerDisks edwnsd;edwinstnsd;edwviewnsd
pagepool 4G
worker1Threads 1024
usePersistentReserve yes
maxblocksize 2048K
prefetchThreads 256
adminMode central
File systems in cluster p740a5_a6_cluster.p740a5_boot:
------------------------------------------------------
/dev/TBS_CFG_DATA
/dev/TBS_CFG_INDEX
/dev/TBS_EAST_DATA
/dev/TBS_EAST_INDEX
/dev/TBS_IPD_DATA
/dev/TBS_IPD_INDEX
/dev/TBS_PISA_DATA
/dev/TBS_PISA_INDEX
/dev/TBS_SUM_DATA
/dev/TBS_SUM_INDEX
/dev/TBS_SYS_TEMP
/dev/TBS_TRANS_DATA
/dev/TBS_TRANS_INDEX
/dev/backup
/dev/edw
/dev/edwdblog
/dev/edwfenc
/dev/edwinst
/dev/edwview
/dev/test
浏览3846