Chinaunix

标题: db2在Redhat AS4上使用裸设备建库的问题 [打印本页]

作者: tony21hbb    时间: 2012-02-10 11:09
标题: db2在Redhat AS4上使用裸设备建库的问题
本帖最后由 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


作者: tony21hbb    时间: 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了把。




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2