楼主先按照15楼的APAR里面提供的方法再现一下这个场景,以确定问题,或者了解一下是否那个表在加colomn之后又alter default了。另外,升级只能保证以后不出这个问题,但是已发生的问题还是不能解决,这个表需要修复,给出了两个选择:第一,重建这个表,重建时要确保把新加的列接进去并且...
显示全部楼主先按照15楼的APAR里面提供的方法再现一下这个场景,以确定问题,或者了解一下是否那个表在加colomn之后又alter default了。另外,升级只能保证以后不出这个问题,但是已发生的问题还是不能解决,这个表需要修复,给出了两个选择:
第一,重建这个表,重建时要确保把新加的列接进去并且在表定义中设定default值。
第二,用一下步骤修复之
db2start
db2 "connect to db"
db2 +c "alter table tab add column col int with default 0"
db2 "rollback"
db2 "reorg table tab"
db2 "connect reset"
db2 "connect to db"
db2 "select * from tab"
db2 "connect reset"
db2stop
日志里还有一个错误:
2012-01-16-15.35.22.455987+480 I699273467A423 LEVEL: Severe
PID : 692466 TID : 1 PROC : db2agent (QHBSEC) 0
INSTANCE: db2inst1 NODE : 000 DB : QHBSEC
APPHDL : 0-1467 APPID: C0A81439.G919.12DD06073616
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
这个可能是因为你没有用正确的方式mount文件系统,可以参考一下:
https://www-304.ibm.com/support/docview.wss?uid=swg21414868If you mount your file system with nosetuid, you will face unexpected behavior.
Symptom
Unexpected behavior due to incorrectly mounted file system.
Here are some examples of the symptoms that may be encountered:
When starting DB2 using the db2start command, the following symptom will occur.
A syslogd will record the following messages in the /var/adm/messages(or check your configration where messages located in).
Oct 27 15:52:16 hostname genunix: [ID 809163 kern.info] NOTICE:
db2start, uid 109: setuid execution not allowed, dev=6600000040
Oct 27 15:52:16 hostname genunix: [ID 809163 kern.info] NOTICE:
db2star2, uid 109: setuid execution not allowed, dev=6600000040
Oct 27 15:52:17 hostname genunix: [ID 809163 kern.info] NOTICE:
db2sysc, uid 109: setuid execution not allowed, dev=6600000040
Oct 27 15:52:19 hostname genunix: [ID 809163 kern.info] NOTICE: db2fmp,
uid 109: setuid execution not allowed, dev=6600000040
In DB2 V9.1 case.
db2start will be failed with the following error.
$ db2start
2009-12-10 11:45:49 0 0 SQL1042C An unexpected system error occurred.
SQL1032N No start database manager command was issued. SQLSTATE=57019
In DB2 9.5 case.
db2 list dcs application will hang and instance down.
From db2diag.log
2009-10-29-11.51.13.729727+540 I149027E474 LEVEL: Severe
PID : 2220 TID : 41 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.db2inst1.091029025113
AUTHID : DB2INST1
EDUID : 41 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
In DB2 V9.7 case.
db2sampl will hang.
收起