RHEL AS4 + DB2_V81 安装成功但经常shutdown 附安装配置和日志

gyljfang

问题描述：
    在linux下安装db2数据库后，通过编排节点，在win系统中也可客户端连接查看， 程序访问时，能访问页面，但经常shutdown，shutdown频率很高。 是配置原因还是其它原因？

安装工具：
系统：RHEL AS4
数据库： DB2_V81_PE_LNX_32_NLV.tar

安装过程：
1.解压tar xvf DB2_V81_PE_LNX_32_NLV.tar
2.安装 ./db2_install
3.安装授权文件/opt/IBM/db2/V8.1/adm/db2licm -a /data/software/pe/db2/license/db2pe.lic
4.配置用户
5.创建实例 /opt/IBM/db2/V8.1/instance/db2icrt -u aduser aduser  
6.配置参数
#db2set DB2_EXTENDED_OPTIMIZATION=ON
#db2set DB2_DISABLE_FLUSH_LOG=ON
#db2set AUTOSTART=YES(设置db2自动随linux启动)
#db2set DB2_STRIPED_CONTAINERS=ON
#db2set DB2_HASH_JOIN=Y
#db2set DB2COMM=tcpip(设置db2支持tcpip协议以便客户端访问)
#db2set DB2_PARALLEL_IO=*
#db2set DB2CODEPAGE=819
#db2  terminate
7.编目节点db2 catalog tcpip node cnten remote 192.0.0.4 server 60000
8.设置DB2的端口vi /etc/services
9.把dbm的VCENAME 的值和/etc/services中的端口号对应
  [mydb@localhost ~]# db2 update dbm cfg using SVCENAME 60000
  [mydb@localhost ~]# db2 update dbm cfg using INDEXREC ACCESS
10.建库
  db2 create database mydb alias mydb using codeset utf-8 territory cn
  db2 =>create bufferpool mydb_pool immediate size 5000 pagesize 16 k
  db2 =>create regular tablespace bjgas pagesize 16 k managed by system using('mydb') bufferpool mydb_pool
  db2 =>comment on tablespace mydb is 'mydb'
  db2 =>create system temporary tablespace mydb_tempspace pagesize 16 k managed by system using ('mydb_tempspace') bufferpool mydb_pool
  db2 =>comment on tablespace mydb_tempspace is 'tempspace'
11.建表 导数据

附数据库日志：

2008-06-27-10.40.45.459984   Instance:aduser   Node:000
PID:3991(db2wdog)   TID:3033676672   Appid:none
oper system services  sqloRunInstance Probe:490

ADM0503C  An unexpected internal processing error has occurred.  ALL DB2
PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.  Diagnostic
information has been recorded.  Contact IBM Support for further assistance.

2008-06-27-10.40.45.466156   Instance:aduser   Node:000
PID:3991(db2wdog)   TID:3033676672   Appid:none
oper system services  sqloRunInstance Probe:500

DiagData
0xBFFFDAE0 : 0x0000000900000102                         ........

2008-06-27-10.40.45.470515   Instance:aduser   Node:000
PID:3991(db2wdog)   TID:3033676672   Appid:none
base sys utilities  sqleCleanupResources Probe:5

DiagData
0xBFFFD8EC : 0x00000102                                 ....

diablo2

db2diag.log太少

gyljfang

2008-06-27-10.08.47.518518   Instance:aduser   Node:000
PID:5147(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqlesysc_main Probe:9

ADM0506I  DB2 has automatically updated the "semmni" kernel parameter from
"128" to the recommended value "1024".

2008-06-27-10.08.47.531344   Instance:aduser   Node:000
PID:5147(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqlesysc_main Probe:9

ADM0506I  DB2 has automatically updated the "msgmni" kernel parameter from "16"
to the recommended value "1024".

2008-06-27-10.08.47.533015   Instance:aduser   Node:000
PID:5147(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqlesysc_main Probe:9

ADM0506I  DB2 has automatically updated the "shmmax" kernel parameter from
"33554432" to the recommended value "268435456".

2008-06-27-10.08.48.767666   Instance:aduser   Node:000
PID:5145(db2star2)   TID:3033676480   Appid:none
base sys utilities  startdbm Probe:911

ADM7513W  Database manager has started.

2008-06-27-10.17.13.583129   Instance:aduser   Node:000
PID:5201(db2agent (aduser))   TID:3033676672   Appid:*LOCAL.aduser.06D1F7021707
buffer pool services  sqlbCreateBufferPool Probe:130   Database:aduser

ADM6053W  The CREATE BUFFERPOOL statement for buffer pool "aduser_POOL" (ID "2")
could not be performed immediately because not enough free memory existed in
the database shared memory.  The bufferpool will be created on the next
database restart.  Refer to the documentation for SQLCODE 20189.

2008-06-27-10.17.13.587049   Instance:aduser   Node:000
PID:5201(db2agent (aduser))   TID:3033676672   Appid:*LOCAL.aduser.06D1F7021707
buffer pool services  sqlbCreateBufferPool Probe:180   Database:aduser

(Informational) Warning, create was deferred
0xBFFF5FF4 : 0x0002015E                                 ^...

2008-06-27-10.17.35.484985   Instance:aduser   Node:000
PID:5201(db2agent (aduser))   TID:3033676672   Appid:*LOCAL.aduser.06D1F7021707
buffer pool services  sqlbStartPools Probe:2   Database:aduser

ADM6073W  The table space "aduser" (ID "3") is configured to use buffer pool ID
"2", but this buffer pool is not active at this time. In the interim the table
space will use buffer pool ID "4098".  The inactive buffer pool should become
available at next database startup provided that the required memory is
available.

2008-06-27-10.18.22.500861   Instance:aduser   Node:000
PID:5201(db2agent (aduser))   TID:3033676672   Appid:*LOCAL.aduser.06D1F7021707
buffer pool services  sqlbStartPools Probe:2   Database:aduser

ADM6073W  The table space "aduser_TEMPSPACE" (ID "4") is configured to use
buffer pool ID "2", but this buffer pool is not active at this time. In the
interim the table space will use buffer pool ID "4098".  The inactive buffer
pool should become available at next database startup provided that the
required memory is available.

2008-06-27-10.22.09.539270   Instance:aduser   Node:000
PID:5147(db2wdog)   TID:3033676672   Appid:none
oper system services  sqloRunInstance Probe:490

ADM0503C  An unexpected internal processing error has occurred.  ALL DB2
PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.  Diagnostic
information has been recorded.  Contact IBM Support for further assistance.

2008-06-27-10.22.09.546149   Instance:aduser   Node:000
PID:5147(db2wdog)   TID:3033676672   Appid:none
oper system services  sqloRunInstance Probe:500

DiagData
0xBFFFDAE0 : 0xFFFFFFFF00000102                         ........

2008-06-27-10.22.09.552273   Instance:aduser   Node:000
PID:5147(db2wdog)   TID:3033676672   Appid:none
base sys utilities  sqleCleanupResources Probe:5

DiagData
0xBFFFD8EC : 0x00000102                                 ....

2008-06-27-10.24.33.907895   Instance:aduser   Node:000
PID:3991(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqlesysc_main Probe:9

ADM0506I  DB2 has automatically updated the "semmni" kernel parameter from
"128" to the recommended value "1024".

2008-06-27-10.24.33.935928   Instance:aduser   Node:000
PID:3991(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqlesysc_main Probe:9

ADM0506I  DB2 has automatically updated the "msgmni" kernel parameter from "16"
to the recommended value "1024".

2008-06-27-10.24.33.938408   Instance:aduser   Node:000
PID:3991(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqlesysc_main Probe:9

ADM0506I  DB2 has automatically updated the "shmmax" kernel parameter from
"33554432" to the recommended value "268435456".

2008-06-27-10.24.35.316522   Instance:aduser   Node:000
PID:3989(db2star2)   TID:3033676480   Appid:none
base sys utilities  startdbm Probe:911

ADM7513W  Database manager has started.

2008-06-27-10.40.44.929021   Instance:aduser   Node:000
PID:3996(db2gds)   TID:3033676672   Appid:none
oper system services  sqloEDUSIGCHLDHandler Probe:50

Detected the death of an EDU with process id 4077
The signal number that terminated this process was 11
Look for trap files (t4077.*) in the dump directory


2008-06-27-10.40.44.937985   Instance:aduser   Node:000
PID:3996(db2gds)   TID:3033676672   Appid:none
oper system services  sqloEDUCodeTrapHandler Probe:10

ADM0503C  An unexpected internal processing error has occurred.  ALL DB2
PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.  Diagnostic
information has been recorded.  Contact IBM Support for further assistance.

2008-06-27-10.40.44.942227   Instance:aduser   Node:000
PID:3996(db2gds)   TID:3033676672   Appid:none
oper system services  sqloEDUCodeTrapHandler Probe:20

Signal number received

0xBFFFCE3C : 0x00000006                                 ....

PID:3996 TID:3033676672 Node:000 Title: siginfo_t...

0xBFFFCE48 : 0600 0000 0000 0000 FAFF FFFF 9C0F 0000    ................
0xBFFFCE58 : F501 0000 0055 43CB 9C0F 0000 F038 73C7    .....UC......8s.
0xBFFFCE68 : 67E8 11C0 585F 70C7 585F 70C7 0000 0000    g...X_p.X_p.....
0xBFFFCE78 : 0000 0000 0000 0000 0000 0000 801B E7CD    ................
0xBFFFCE88 : A85F 70C7 0100 0000 0000 0100 E1FA 12C0    ._p.............
0xBFFFCE98 : 0000 0000 A05F 70C7 A85F 70C7 0000 0000    ....._p.._p.....
0xBFFFCEA8 : DCD1 FFBF F2FF FFFF 2DFC 12C0 0000 0100    ........-.......
0xBFFFCEB8 : 0000 0000 2000 0000 0000 0000 0100 0000    .... ...........

2008-06-27-10.40.45.378661   Instance:aduser   Node:000
PID:3992(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqleChildCrashHandler Probe:15

DiagData
0x0805236C : 416E 2045 4455 2063 7261 7368 6564 2E      An EDU crashed.

2008-06-27-10.40.45.386174   Instance:aduser   Node:000
PID:3992(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqleChildCrashHandler Probe:16

DiagData
0xBFFFD644 : 0x00000F9C                                 ....

2008-06-27-10.40.45.390228   Instance:aduser   Node:000
PID:3992(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqleChildCrashHandler Probe:17

DiagData
0xBFFFD63C : 0x00000101                                 ....

2008-06-27-10.40.45.394197   Instance:aduser   Node:000
PID:3992(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqleChildCrashHandler Probe:18

DiagData
0xBFFFD640 : 0xFFFFFFFF                                 ....

2008-06-27-10.40.45.398174   Instance:aduser   Node:000
PID:3992(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqleChildCrashHandler Probe:19

DiagData
0xBFFFD638 : 0xFFFFFC88                                 ....

2008-06-27-10.40.45.403187   Instance:aduser   Node:000
PID:3992(db2sysc)   TID:3033676672   Appid:none
base sys utilities  sqle_sys_ctlr Probe:10

DiagData
0xBFFFD8E0 : 0x00000001                                 ....

2008-06-27-10.40.45.459984   Instance:aduser   Node:000
PID:3991(db2wdog)   TID:3033676672   Appid:none
oper system services  sqloRunInstance Probe:490

ADM0503C  An unexpected internal processing error has occurred.  ALL DB2
PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.  Diagnostic
information has been recorded.  Contact IBM Support for further assistance.

2008-06-27-10.40.45.466156   Instance:aduser   Node:000
PID:3991(db2wdog)   TID:3033676672   Appid:none
oper system services  sqloRunInstance Probe:500

DiagData
0xBFFFDAE0 : 0x0000000900000102                         ........

2008-06-27-10.40.45.470515   Instance:aduser   Node:000
PID:3991(db2wdog)   TID:3033676672   Appid:none
base sys utilities  sqleCleanupResources Probe:5

DiagData
0xBFFFD8EC : 0x00000102                                 ....

gyljfang

这是从启动到报错的完整日志，我看不懂

gyljfang

问题解决了，设置db2set DB2_OVERRIDE_BPF=-1 ，原因还理解的不太清楚，可以参考

http://www.itpub.net/thread-917777-1-1.html

http://publib.boulder.ibm.com/in ... /admin/r0005665.htm

lovelyman_gold

db2set DB2_OVERRIDE_BPF=-1   干嘛的啊？