在RH EL 4 上尝试新建数据库失败
在RH EL 4 上尝试新建数据库失败刚在Linux上安装了DB2 Express C
创建数据库不成功
1. 在命令行下创建
su - db2inst1
db2start
db2 create db test
然后我就一直处于等待状态,没有任何错误消息返回,等了半个多小时吧,放弃了
2. 然后尝试用Control Center
按着向导创建,最后点finish, 然后一个齿轮的对话框,也是一直等了一个多消失,然后放弃
下图是30分钟的解图,随后我还等了半个多小时
https://dl-web.dropbox.com/get/tmp/db2cc.png?w=0e4adf1d
请问这种情况会是什么原因呢?
请高手指教 把日志发出来吧 日志是这样的
(/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 .... Here it is, please help , thanks
db2inst1@localhost etc$ db2set -all
DB2PROCESSORS=0
DB2COMM=tcpip
DB2SYSTEM=localhost.localdomain
DB2INSTDEF=db2inst1
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 /etc/hosts 中加入本地 IP , 你的系统必须有自己的主机名。 因为我在VMWARE虚拟机里装,现在没设ip
请问有127.0.0.1的不行吗?
谢谢 现在在虚拟机里加了网卡,ip 172.16.110.130
所以host文件更新如下:
127.0.0.1 localhost.localdomain localhost
172.16.110.130 RHEL4
reboot 之后尝试创建数据库还是不行阿~ .bashrc 文件和 .profile 文件改了吗? 另:创建实例以后,首先得启动 db2 ,然后才可以建立数据库。 回复 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吗?
页:
[1]
2