- 论坛徽章:
- 0
|
你应该已经创建了实例,因为你用的是图形安装(我是直接./setup)
su - db2inst1
cd $HOME/sqllib/db2dump/db2diag.log
给你参考一下我自己通常安装DB2的方法,希望对你有帮助。
OS version: RHEL4 U5
DB2 version: 8.1, FixPak "9"
#Run the following command as ROOT account
./db2_install
Software is intalled in the following path
/opt/IBM/db2/V8.1
#Create user groups of database.
groupadd dasadm1
groupadd db2fenc1
groupadd db2grp1
#Create users of database
useradd -d /opt/dasusr1 -g dasadm1 dasusr1
useradd -d /opt/db2fenc1 -g db2fenc1 db2fenc1
useradd -d /opt/db2inst1 -g db2grp1 -G dasadm1 db2inst1
#Create database administration server
cd /opt/IBM/db2/V8.1/instance/
./dascrt dasusr1
#Create database instance
cd /opt/IBM/db2/V8.1/instance/
./db2icrt -s ese -u db2fenc1 db2inst1
#Enable multi-page file allocation for SMS
su - root
/opt/IBM/db2/V8.1/cfg/db2ln
#Add DB2 port
su - root
vi /etc/services (Add the following one line into it.)
db2inst1 50000/tcp
#Set DB2 software version profile registry
su – db2inst1
db2set DB2_EXTENDED_OPTIMIZATION=ON
db2set DB2_DISABLE_FLUSH_LOG=ON
db2set AUTOSTART=YES
db2set DB2_STRIPED_CONTAINERS=ON
db2set DB2_HASH_JOIN=Y
db2set DB2COMM=tcpip
db2set DB2_PARALLEL_IO=*
db2set DB2CODEPAGE=819
#Update dbm cfg
db2 update dbm cfg using SVCENAME db2inst1
db2 update dbm cfg using INDEXREC ACCESS
#Create database
db2 "CREATE DATABASE test1 ALIAS test1 USING CODESET ISO8859-1 TERRITORY CN"
[ 本帖最后由 huyuhui001 于 2007-8-8 16:17 编辑 ] |
|