免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3085 | 回复: 1
打印 上一主题 下一主题

db2在Redhat AS4上使用裸设备建库的问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2012-02-10 11:09 |只看该作者 |倒序浏览
本帖最后由 tony21hbb 于 2012-02-10 11:20 编辑

root@as4 ~]# su - db2mdb
[db2mdb@as4 ~]$ db2start
2012-02-10 10:48:16     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
[db2mdb@as4 Tmismgdb]$ db2 -tvf Tmis1_Tmismgdb_CreateDb.sql
create db tmismgdb on /tmis/mdb using codeset gbk territory cn pagesize 8 K catalog tablespace managed by database using (device '/dev/rlv_md_clg' 4096)
SQL0970N  The system attempted to write to a read-only file.  SQLSTATE=55009

//这里建不上去,报只读    

[db2mdb@as4 Tmismgdb]$ export LANG=en_US
[db2mdb@as4 Tmismgdb]$ dd if=/dev/zero  of=/dev/rlv_md_clg
dd: writing to `/dev/rlv_md_clg': No space left on device
36865+0 records in
36864+0 records out


[db2mdb@as4 dev]$ ll |grep rlv
lrwxrwxrwx  1 root   root          13  2ÔÂ 10 11:10 rlv_md_clg -> /dev/raw/raw1

[db2mdb@as4 mapper]$ ll
×üóÃá¿ 0
crw-------  1 db2mdb db2madm  10, 63 2012-02-10  control
brw-rw----  1 db2mdb db2madm 253,  7 2012-02-10  rootvg-lv_md_clg

[db2mdb@as4 db2dump]$ cd /dev
[db2mdb@as4 dev]$ cd raw
[db2mdb@as4 raw]$ ll
×üóÃá¿ 0
crw-rw----  1 db2mdb db2madm 162,  1  2ÔÂ 10 10:45 raw1



----diag日志------
2012-02-10-10.48.46.559635+480 I38793G451         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:10
MESSAGE : directory:
DATA #1 : Hexdump, 15 bytes
0xBFF6F1E8 : 2F74 6D70 2F53 514C 4449 522E 4C4B 30      /tmp/SQLDIR.LK0

2012-02-10-10.48.46.559755+480 I39245G441         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:20
MESSAGE : permissions:
DATA #1 : Hexdump, 4 bytes
0xBFF6F0CC : FF01 0000                                  ....

2012-02-10-10.48.46.559876+480 I39687G497         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".

2012-02-10-10.48.46.560263+480 I40185G393         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
DATA #1 : String, 29 bytes
Cannot create /tmp/SQLDIR.LK0

2012-02-10-10.48.46.560534+480 I40579G499         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, buffer pool services, sqlbLockParentDir, probe:910
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".

2012-02-10-10.48.46.561133+480 I41079G508         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:810
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".

2012-02-10-10.48.46.561497+480 I41588G447         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:810
DATA #1 : String, 72 bytes
Error acquiring container 0 (/dev/rlv_md_clg) for tbsp 0.  Rc = 840F0001

2012-02-10-10.48.46.561779+480 I42036G499         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSCreatePool, probe:800
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".

2012-02-10-10.48.46.562182+480 I42536G372         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSCreatePool, probe:800
DATA #1 : String, 7 bytes
Page=0

2012-02-10-10.48.46.562507+480 I42909G496         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, buffer pool services, sqlbCreatePool, probe:950
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".

2012-02-10-10.48.46.570706+480 I43406G492         LEVEL: Severe
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, data management, sqldPoolCreate, probe:273
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".

2012-02-10-10.48.46.571299+480 I43899G490         LEVEL: Error
PID     : 7004                 TID  : 3086333632  PROC : db2agent (instance) 0
INSTANCE: db2mdb               NODE : 000
APPHDL  : 0-7                  APPID: *LOCAL.db2mdb.120210024845
AUTHID  : DB2MDB
FUNCTION: DB2 UDB, base sys utilities, sqleStartDb, probe:38
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".

------------------
裸设备建的应该没问题
[db2mdb@as4 db2dump]$ raw -qa
/dev/raw/raw1:  bound to major 253, minor 7
/dev/raw/raw2:  bound to major 253, minor 8
/dev/raw/raw3:  bound to major 253, minor 9
/dev/raw/raw4:  bound to major 253, minor 10
/dev/raw/raw5:  bound to major 253, minor 11
/dev/raw/raw6:  bound to major 253, minor 12
/dev/raw/raw7:  bound to major 253, minor 13
/dev/raw/raw8:  bound to major 253, minor 14
/dev/raw/raw9:  bound to major 253, minor 15
/dev/raw/raw10: bound to major 253, minor 16
/dev/raw/raw11: bound to major 253, minor 17
/dev/raw/raw12: bound to major 253, minor 18
/dev/raw/raw13: bound to major 253, minor 19
/dev/raw/raw14: bound to major 253, minor 20
/dev/raw/raw15: bound to major 253, minor 21
/dev/raw/raw20: bound to major 8, minor 21

[db2mdb@as4 sysconfig]$ cat rawdevices
# This file and interface are deprecated.
# Applications needing raw device access should open regular
# block devices with O_DIRECT.
# raw device bindings
# format:  <rawdev> <major> <minor>
#          <rawdev> <blockdev>
# example: /dev/raw/raw1 /dev/sda1
#          /dev/raw/raw2 8 5
/dev/raw/raw1  /dev/rootvg/lv_md_clg

[db2mdb@as4 permissions.d]$ cat 50-udev.permissions
# raw devices
#ram*:root:disk:0660
ram*:db2mdb:db2madm:0660
#raw/*:root:disk:0660
raw/*:db2mdb:db2madm:0660

论坛徽章:
0
2 [报告]
发表于 2012-02-10 11:25 |只看该作者
有没高手帮忙看看问题在哪儿啊。
LINUX的裸设备和aix hp-ux上的不一样,不是直接调rlv,
感觉我在linux上建的裸设备应该没问题,就是db2不认, db2版本如下:
[db2mdb@as4 Tmismgdb]$ db2level
DB21085I  Instance "db2mdb" uses "32" bits and DB2 code release "SQL09019" with
level identifier "020A0107".
Informational tokens are "DB2 v9.1.0.10", "s110109", "MI00380", and Fix Pack
"10".
Product is installed at "/opt/ibm/db2/V9.1".

fp10了,应该不是db2 的bug了把。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP