作者: IBM, 出处:Developerworks中国, 责任编辑: ttdb,
2005-12-18 15:55
问题:在 Unix 操作系统下，有时会发生当 DB2 用户使用如:
db2 -td@ -vf <存储过程创建脚本文件>
创建存储过程失败的情况，而查看 db2diag.log 文件则发现有类似如下报错信息:
|
--------------------------------------------------------------
2002-10-05-13.47.40.075759 Instance:db2inst1 Node:000
PID:1355876(db2agent (ABC) 0) TID:1 Appid:OC10103F.OD12.017302185202
oper system services sqloChangeFileOwnership Probe:100 Database:ABC
errno:
0x0FFFFFFFFFFF7AF0 : 0x00000001 ....
PID:1355876 TID:1 Node:000 Title: Path/Filename
/home/db2inst1/sqllib/function/routine/sqlproc/ABC/DB2INST1/tmp/
2002-10-05-13.47.40.166289 Instance:db2inst1 Node:000
PID:1355876(db2agent (ABC) 0) TID:1 Appid:OC10103F.OD12.017302185202
PSM - SQL Procedure psm_ctrl::psm_init_backend Probe:230 Database:ABC
DIA8402C A disk error has occurred.
ZRC=0x860F0004
PID:1355876 TID:1 Node:000 Title: SQL procedure initialization:
0x09000000031213BC : 696E 7374 616E 6365 206F 776E 6572 2064 instance owner d
0x09000000031213CC : 6F65 7320 6E6F 7420 6265 6C6F 6E67 2074 oes not belong t
0x09000000031213DC : 6F20 6665 6E63 6564 2075 7365 7227 7320 o fenced user's
0x09000000031213EC : 7072 696D 6172 7920 6772 6F75 70 primary group
-------------------------------------------------------------- |
