您的位置:程序门 -> db2 -> 基础类



救命。db2 v9,aix系统配完双机,原先装的db2启不来,删掉实例后不能重新建


[收藏此页] [打印本页]选择字色:背景色:字体:[][][]


救命。db2 v9,aix系统配完双机,原先装的db2启不来,删掉实例后不能重新建
发表于:2007-12-14 12:44:10 楼主
这台机器作双机之前db2是正常的。
用root用户执行./db2icrt   -u   db2fenc1   db2inst1报错


2007-12-14-00.40.27.204485+480   i1a1093                         level:   event
pid           :   225360                               tid     :   1                       proc   :   db2bp
instance:   db2inst1                           node   :   000
function:   db2   udb,   ras/pd   component,   pdloginternal,   probe:120
start       :   new   diagnostic   log   file
data   #1   :   build   level,   152   bytes
instance   "db2inst1"   uses   "64"   bits   and   db2   code   release   "sql09010"
with   level   identifier   "02010107".
informational   tokens   are   "db2   v9.1.0.0",   "s060629",   "aix64",   fix   pack   "0".
data   #2   :   system   info,   224   bytes
system:   aix   jh_570   3   5   00c5f5704c00
cpu:   total:8   online:8   threading   degree   per   core:2
physical   memory(mb):   total:7744   free:5981
virtual     memory(mb):   total:8256   free:6488
swap           memory(mb):   total:512   free:507
kernel       params:   msgmaxmessagesize:4194304   msgmaxqueuesize:4194304
                                  shmmax:68719476736   shmmin:1   shmids:131072
                                  shmsegments:68719476736   semids:131072   semnumperid:65535
                                  semops:1024   semmaxval:32767   semadjustonexit:16384
information   in   this   record   is   only   valid   at   the   time   when   this   file   was
created   (see   this   record's   time   stamp)

2007-12-14-00.40.27.203459+480   i1095a345                     level:   severe
pid           :   225360                               tid     :   1                       proc   :   db2bp
instance:   db2inst1                           node   :   000
function:   db2   udb,   base   sys   utilities,   sqleinitapplicationenvironment,   probe:32
data   #1   :   hexdump,   4   bytes
0x0ffffffffffff634   :   ffff   e860                                                                     ...`

2007-12-14-00.40.27.276018+480   i1441a327                     level:   severe
pid           :   225360                               tid     :   1                       proc   :   db2bp
instance:   db2inst1                           node   :   000
function:   db2   udb,   command   line   process,   clp_bp_main,   probe:2
data   #1   :   hexdump,   4   bytes
0x0ffffffffffff900   :   ffff   e860                                                                     ...`

2007-12-14-00.41.27.178356+480   i1769a383                     level:   error
pid           :   249978                               tid     :   1                       proc   :   db2
instance:   db2inst1                           node   :   000
function:   db2   udb,   command   line   process,   clp_start_bp,   probe:3
message   :   clp   frontend   unable   to   get   request   queue   handle
data   #1   :   hexdump,   4   bytes
0x0fffffffffffd778   :   870f   0042                                                                     ...b
dbi1281e   the   database   manager   configuration   file   could   not   be
                    initialized.

explanation:

an   error   occurred   when   attempting   to   initialize   the   database
manager   configuration   file.   a   db2   instance   could   not   be   created
or   migrated.

user   response:

refer   to   the   log   file   for   problem   determination.   resolve   the
problem   and   try   the   command   again.   if   the   problem   persists,
please   contact   ibm   support.

dbi1079i   output   is   saved   in   the   log   file   /tmp/db2icrt.log.233678.

explanation:

all   processed   and   failed   operations   have   been   saved   into   this   log
file.

user   response:

do   not   modify   this   file   in   any   way.   this   file   is   for   ibm
technical   support   reference.

发表于:2007-12-14 14:14:271楼 得分:0
我把db2inst1和db2fenc1用户删掉,rm   -r目录。重新建,依然不能建实例
bash-3.00#   ./db2icrt   -u   db2fenc1   db2inst1

2007-12-14-02.09.34.180962+480   i1a1093                         level:   event
pid           :   221372                               tid     :   1                       proc   :   db2bp
instance:   db2inst1                           node   :   000
function:   db2   udb,   ras/pd   component,   pdloginternal,   probe:120
start       :   new   diagnostic   log   file
data   #1   :   build   level,   152   bytes
instance   "db2inst1"   uses   "64"   bits   and   db2   code   release   "sql09010"
with   level   identifier   "02010107".
informational   tokens   are   "db2   v9.1.0.0",   "s060629",   "aix64",   fix   pack   "0".
data   #2   :   system   info,   224   bytes
system:   aix   jh_570   3   5   00c5f5704c00
cpu:   total:8   online:8   threading   degree   per   core:2
physical   memory(mb):   total:7744   free:4591
virtual     memory(mb):   total:8256   free:5098
swap           memory(mb):   total:512   free:507
kernel       params:   msgmaxmessagesize:4194304   msgmaxqueuesize:4194304
                                  shmmax:68719476736   shmmin:1   shmids:131072
                                  shmsegments:68719476736   semids:131072   semnumperid:65535
                                  semops:1024   semmaxval:32767   semadjustonexit:16384
information   in   this   record   is   only   valid   at   the   time   when   this   file   was
created   (see   this   record's   time   stamp)

2007-12-14-02.09.34.179667+480   i1095a345                     level:   severe
pid           :   221372                               tid     :   1                       proc   :   db2bp
instance:   db2inst1                           node   :   000
function:   db2   udb,   base   sys   utilities,   sqleinitapplicationenvironment,   probe:32
data   #1   :   hexdump,   4   bytes
0x0ffffffffffff634   :   ffff   e860                                                                     ...`

2007-12-14-02.09.34.252584+480   i1441a327                     level:   severe
pid           :   221372                               tid     :   1                       proc   :   db2bp
instance:   db2inst1                           node   :   000
function:   db2   udb,   command   line   process,   clp_bp_main,   probe:2
data   #1   :   hexdump,   4   bytes
0x0ffffffffffff900   :   ffff   e860                                                                     ...`

2007-12-14-02.10.34.154951+480   i1769a383                     level:   error
pid           :   250048                               tid     :   1                       proc   :   db2
instance:   db2inst1                           node   :   000
function:   db2   udb,   command   line   process,   clp_start_bp,   probe:3
message   :   clp   frontend   unable   to   get   request   queue   handle
data   #1   :   hexdump,   4   bytes
0x0fffffffffffd778   :   870f   0042                                                                     ...b
dbi1281e   the   database   manager   configuration   file   could   not   be
                    initialized.

explanation:

an   error   occurred   when   attempting   to   initialize   the   database
manager   configuration   file.   a   db2   instance   could   not   be   created
or   migrated.

user   response:

refer   to   the   log   file   for   problem   determination.   resolve   the
problem   and   try   the   command   again.   if   the   problem   persists,
please   contact   ibm   support.

dbi1079i   output   is   saved   in   the   log   file   /tmp/db2icrt.log.262250.

explanation:

all   processed   and   failed   operations   have   been   saved   into   this   log
file.

user   response:

do   not   modify   this   file   in   any   way.   this   file   is   for   ibm
technical   support   reference.



快速检索

最新资讯
热门点击