db2在Redhat AS4上使用裸设备建库的问题
本帖最后由 tony21hbb 于 2012-02-10 11:20 编辑root@as4 ~]# su - db2mdb
$ db2start
2012-02-10 10:48:16 0 0 SQL1063NDB2START processing was successful.
SQL1063NDB2START processing was successful.
$ 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)
SQL0970NThe system attempted to write to a read-only file.SQLSTATE=55009
//这里建不上去,报只读:'(:call:
$ export LANG=en_US
$ dd if=/dev/zeroof=/dev/rlv_md_clg
dd: writing to `/dev/rlv_md_clg': No space left on device
36865+0 records in
36864+0 records out
$ ll |grep rlv
lrwxrwxrwx1 root root 132ÔÂ 10 11:10 rlv_md_clg -> /dev/raw/raw1
$ ll
×üóÃá¿ 0
crw-------1 db2mdb db2madm10, 63 2012-02-10control
brw-rw----1 db2mdb db2madm 253,7 2012-02-10rootvg-lv_md_clg
$ cd /dev
$ cd raw
$ ll
×üóÃá¿ 0
crw-rw----1 db2mdb db2madm 162,12ÔÂ 10 10:45 raw1
----diag日志------
2012-02-10-10.48.46.559635+480 I38793G451 LEVEL: Error
PID : 7004 TID: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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: 3086333632PROC : 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 "".
------------------
裸设备建的应该没问题
$ 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
$ 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
$ cat 50-udev.permissions
# raw devices
#ram*:root:disk:0660
ram*:db2mdb:db2madm:0660
#raw/*:root:disk:0660
raw/*:db2mdb:db2madm:0660
有没高手帮忙看看问题在哪儿啊。
LINUX的裸设备和aix hp-ux上的不一样,不是直接调rlv,
感觉我在linux上建的裸设备应该没问题,就是db2不认, db2版本如下:
$ db2level
DB21085IInstance "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了把。
页:
[1]