互联网服务

DB2 建400G表空间用2小时?

各位好:

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。
参与19

提问者

yangyong
项目经理 pharmacodia
评论181

问题状态

  • 发布时间:2013-07-02
  • 关注会员:1 人
  • 问题浏览:14485
  • 最近回答:2013-07-05
  • X社区推广