db2在Redhat AS4上使用裸設(shè)備建庫(kù)的問(wèn)題

tony21hbb

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

//這里建不上去，報(bào)只讀    

[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 "".

------------------
裸設(shè)備建的應(yīng)該沒問(wèn)題
[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

tony21hbb

有沒高手幫忙看看問(wèn)題在哪兒啊。
LINUX的裸設(shè)備和aix hp-ux上的不一樣，不是直接調(diào)rlv，
感覺我在linux上建的裸設(shè)備應(yīng)該沒問(wèn)題，就是db2不認(rèn)， 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了，應(yīng)該不是db2 的bug了把。