各位好:
DB2 建400G表空间用2小时?相关语句如下,请大家分析可能的原因?
环境:
[root@~]# lsb_release -a
LSB Version: 3.1
Distributor ID: AsianuxServer
Description: Asianux Server 3 (Quartet SP3)
Release: 3
Codename: QuartetSP3
[db2inst1@~]$ db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09075"
with level identifier "08060107".
Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23292", and Fix Pack
"5".
Product is installed at "/opt/ibm/db2/V9.7".
数据库创建
db2 create database xxxdb automatic storage yes on /db2/xxx/autots dbpath on /db2/xxx using codeset GBK TERRITORY CN COLLATE USING SYSTEM
表空间的创建语句:
db2 "Create tablespace DDS_DTS_32K PAGESIZE 32K MANAGED BY DATABASE USING
(file '/db2/xxx/xxxts1/DDS_DTS_32K_1' 100G,
file '/db2/xxx/xxxts2/DDS_DTS_32K_2' 100G,
file '/db2/xxx/xxxts3/DDS_DTS_32K_3' 100G,
file '/db2/xxx/xxxts4/DDS_DTS_32K_4' 100G )
EXTENTSIZE 32 PREFETCHSIZE 32 BUFFERPOOL BP32K_D1 DROPPED TABLE RECOVERY OFF"
Asianux 安装虚拟机上面(wmware vSphere Server 3),外挂存储,现还不清楚存储采取的是SAN还是NAS。
收起