ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DB2数据库创建存储过程时遇到的错误

DB2数据库创建存储过程时遇到的错误

原创 Linux操作系统 作者:ArtCode 时间:2010-06-07 15:53:00 0 删除 编辑

转自 http://database.ctocio.com.cn/dbzjdysummary/228/6699228.shtml

问:在 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

问:在 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

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15082138/viewspace-664587/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: DB2错误0509-136
请登录后发表评论 登录
全部评论

注册时间:2008-08-05

  • 博文量
    269
  • 访问量
    609668