在RH EL 4 上尝试新建数据库失败

melstar

在RH EL 4 上尝试新建数据库失败

刚在Linux上安装了DB2 Express C
创建数据库不成功
1. 在命令行下创建
su - db2inst1
db2start
db2 create db test
然后我就一直处于等待状态，没有任何错误消息返回，等了半个多小时吧，放弃了

2. 然后尝试用Control Center
按着向导创建，最后点finish， 然后一个齿轮的对话框，也是一直等了一个多消失，然后放弃

下图是30分钟的解图，随后我还等了半个多小时


请问这种情况会是什么原因呢？
请高手指教

star120120

把日志发出来吧

melstar

日志是这样的
(/home/db2inst1/sqllib/db2dump/db2diag.log)
2010-03-30-20.48.18.097872-300 I1G1420 LEVEL: Event
PID : 5387 TID : 3079662496 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.db2inst1.100331014817
AUTHID : DB2INST1
EDUID : 17 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09052"
with level identifier "03030107".
Informational tokens are "DB2 v9.5.0.2", "s080811", "MI00238", Fix Pack "2".
DATA #2 : System Info, 436 bytes
System: Linux localhost.localdomain 6 2 i686
CPU: total:1 online:1 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:504 free:59
Virtual Memory(MB): total:1528 free:1083
Swap Memory(MB): total:1024 free:1024
Kernel Params: msgMaxMessageSize:65535 msgMsgMap:65536 msgMaxQueueIDs:1024
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:268435456 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Information in this record is only valid at the time when this file was
created (see this record's time stamp)

2010-03-30-20.48.18.097728-300 I1422G475 LEVEL: Event
PID : 5387 TID : 3079662496 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.db2inst1.100331014817
AUTHID : DB2INST1
EDUID : 17 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TEST : "Database_memory" From: "20" <computed> To: "22896" <computed>

2010-03-30-20.48.21.829254-300 I1898G441 LEVEL: Warning
PID : 5385 TID : 3054496672 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0xB60FC57C : 0000 0000 ....

melstar

Here it is, please help , thanks
db2inst1@localhost etc$ db2set -all
[i] DB2PROCESSORS=0
[i] DB2COMM=tcpip
[g] DB2SYSTEM=localhost.localdomain
[g] DB2INSTDEF=db2inst1
[g] DB2ADMINSERVER=dasusr1

vi /etc/hosts

   1. Do not remove the following line, or various programs
   2. that require network functionality will fail.

   127.0.0.1 localhost.localdomain localhost

snow888

/etc/hosts 中加入本地 IP ， 你的系统必须有自己的主机名。

melstar

因为我在VMWARE虚拟机里装，现在没设ip
请问有127.0.0.1的不行吗？
谢谢

melstar

现在在虚拟机里加了网卡，ip 172.16.110.130

所以host文件更新如下：
127.0.0.1 localhost.localdomain localhost
172.16.110.130     RHEL4

reboot 之后尝试创建数据库还是不行阿～

snow888

.bashrc 文件和 .profile 文件改了吗？

snow888

另：创建实例以后，首先得启动 db2 ，然后才可以建立数据库。

melstar

回复 8# snow888
.bashrc如下，需要怎么该：
# .bashrc

# User specific aliases and functions

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

# The following three lines have been added by UDB DB2.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
    . /home/db2inst1/sqllib/db2profile
fi

profile是指db2profile吗？