数据库中有如下错误,注意红色部分:
2012-05-20-22.12.06.582956+480 E29150121E992 LEVEL: Severe
PID : 32484 TID : 46934463080768PROC : db2sysc 6
INSTANCE: db2inst1 NODE : 006 DB : ZHSJPTDB
EDUID : 150 EDUNAME: db2loggr (ZHSJPTDB) 6
FUNCTION: DB2 UDB, data protection services, sqlpgUpdateLFH, probe:880
MESSAGE : ADM1710C The database is not accessible because the DB2 database
manager cannot write to the log control file "SQLOGCTL.LFH.1" on
database partition "6". Possible reasons for this include: the file
does not exist; the file is not accessible to the database manager
because of network, file system, or OS problems; or incorrect file
permissions are preventing the database manager from writing to the
file. Ensure that the file is accessible to the database manager and
that the file system is functioning properly, and restart or
reconnect to the database.
2012-05-20-22.12.06.609336+480 E29151114E1254 LEVEL: Error (OS)
PID : 32484 TID : 46934463080768PROC : db2sysc 6
INSTANCE: db2inst1 NODE : 006 DB : ZHSJPTDB
EDUID : 150 EDUNAME: db2loggr (ZHSJPTDB) 6
FUNCTION: DB2 UDB, oper system services, sqloseekwrite64, probe:40
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, pwrite OSERR: EROFS (30)
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 16
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
不要气馁,可以尝试做如下操作,再看数据库能否恢复正常
umount /db2data/database/db2inst1/NODE0006
e2fsck -p /dev/bdbvg/lv_db2inst1_db_nd06
然后再mount该文件系统,启动数据库,看一切是否恢复正常(我这里是可以的)
阅读(2729) | 评论(0) | 转发(0) |