-- create the database:
create database bpmdb automatic storage yeson /opt/db2data/BPMDB using codeset UTF-8 territory CN pagesize 32768;
-- connect to the created database:
connect to BPMDB;
--The following grant is used for databaseswithout enhanced security.
--For more information, review the InfoCenter for Enhancing Security for DB2.
grant dbadm on database to user BPMDB;
UPDATE DB CFG FOR BPMDB USING LOGFILSIZ4096 DEFERRED;
UPDATE DB CFG FOR BPMDB USING LOGSECOND 64DEFERRED;
connectreset;
2015-03-09-09.26.26.064244+480I2346275A505 LEVEL: Event
PID : 8847508 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-11542 APPID:*LOCAL.db2inst1.150309011410
AUTHID : DB2INST1
EDUID : 3343 EDUNAME:db2agent (instance) 0
FUNCTION: DB2 UDB, config/install,sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB BPMDB :"Database_memory" From: "20"
2015-03-09-09.26.26.183418+480E2346781A471 LEVEL: Event
PID : 8847508 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-11542 APPID:*LOCAL.db2inst1.150309011410
AUTHID : DB2INST1
EDUID : 3343 EDUNAME:db2agent (instance) 0
FUNCTION: DB2 UDB, base sys utilities,sqeLocalDatabase::FirstConnect, probe:1000
START : DATABASE: BPMDB : ACTIVATED:NO
2015-03-09-09.27.28.066672+480E2347253A470 LEVEL: Event
PID : 8847508 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-11542 APPID:*LOCAL.db2inst1.150309011410
AUTHID : DB2INST1
EDUID : 3343 EDUNAME:db2agent (idle) 0
FUNCTION: DB2 UDB, base sys utilities,sqeLocalDatabase::TermDbConnect, probe:2000
STOP : DATABASE: BPMDB :DEACTIVATED: NO
==========================================
执行 db2pd-latch :
bash-4.2$ db2pd -latch
Database Partition 0 -- Active -- Up 2 days 19:26:14 -- Date 2015-03-09-10.45.32.893475
Latches:
Address Holder Waiter Filename LOC LatchType HoldCount
0x07800000002A1650 27636 3343 sqledcle.C 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1
0x07800000002A1650 27636 26864 sqledcle.C 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1
0x07800000002A1650 27636 27379 sqledcle.C 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1
0x07800000002A1650 27636 14771 sqledcle.C 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1
0x07800000002A1650 27636 15797 sqledcle.C 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1
0x07800000002A1650 27636 16055 sqledcle.C 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1
这种情况是不是整个数据库被锁住了。不明白
SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 是什么意思?
---------------------------------------
之后尝试执行db2_kill和ipclean后启动数据库,然后执行创建数据库脚本,可以正常创建。但再创建下一个数据库库是,又被挂住。db2_kill和ipclean启动后又可以创建数据库。
不明白为什么在创建数据库时会被挂住。请大神帮忙看看!!!