服务热线:13616026886

技术文档 欢迎使用技术文档,我们为你提供从新手到专业开发者的所有资源,你也可以通过它日益精进

位置:首页 > 技术文档 > 数据库技术 > Oracle技术 > oracle错误库 > 查看文档

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

  

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

扫描关注微信公众号