- 论坛徽章:
- 0
|
本帖最后由 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
|
|