急!急!急!db2不能启动了,今天在编写自动备份脚本的时候发现数据库报IO错误,就重启了服务器,结果服务器上的db2就启动不了了。报错SQL1652N 发生了文件 I/O 错误。其他信息如下:
2014-05-14-17.08.09.582536+480 E4E1011 LEVEL: Error (OS)
PID : 8216 TID : 140310255552288PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, open OSERR: EACCES (13)
DATA #1 : Codepath, 8 bytes
5:6:11:12:22:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_CRTREV, SQLO_READWRITE, SQLO_EXCLUSIVE, SQLO_WRITETHRU, SQLO_DELAY, SQLO_EXPLOCK, SQLO_CLOSE_ON_EXEC
DATA #4 : Hex integer, 4 bytes
0x000001B4
DATA #5 : signed integer, 4 bytes
0
DATA #6 : signed integer, 4 bytes
0
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
2014-05-14-17.08.09.583424+480 I1016E1631 LEVEL: Error (OS)
PID : 8216 TID : 140310255552288PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, open OSERR: EACCES (13)
DATA #1 : String, 137 bytes
A total of 2 analysis will be performed :
- User info
- Path access permission
Target file = /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #2 : String, 184 bytes
Real user ID of current process = 502
Effective user ID of current process = 502
Real group ID of current process = 102
Effective group ID of current process = 102
DATA #3 : String, 274 bytes
Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
:: (subdirectories)
0:0:755 (home)
777:102:755 (db2inst1)
777:102:3775 (sqllib)
777:102:3775 (ctrl)
777:102:644 (db2strst.lck)
CALLSTCK:
[0] 0x00007F9C8DAFB3FE pdOSSeLoggingCallback + 0x20C
[1] 0x00007F9C8C9C730C /home/db2inst1/sqllib/lib64/libdb2osse.so.1 + 0x1B230C
[2] 0x00007F9C8C9C7203 ossLogSysRC + 0xBF
[3] 0x00007F9C8C9BC43E /home/db2inst1/sqllib/lib64/libdb2osse.so.1 + 0x1A743E
[4] 0x00007F9C8C9B97BD ossErrorAnalysis + 0x2D
[5] 0x00007F9C8F422F61 sqloSystemErrorHandler + 0x6D7
[6] 0x00007F9C8E022C82 sqloopenp + 0x1278
[7] 0x00007F9C8DC02AA2 _Z19sqleGetStStLockFileiiP12SQLO_FHANDLEPcP5sqlca + 0x15E
[8] 0x00007F9C8DC02125 _Z20sqleProcessStartStopiPvP18SQLE_INTERNAL_ARGSP9sqlf_kcfdPcijjP5sqlca + 0x1E1
[9] 0x0000000000403B82 main + 0xA6A
2014-05-14-17.08.09.586701+480 I2648E390 LEVEL: Error
PID : 8216 TID : 140310255552288PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x00007FFF4B839F88 : 0100 0F84 ....2014-05-14-17.08.09.582536+480 E4E1011 LEVEL: Error (OS)
PID : 8216 TID : 140310255552288PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, open OSERR: EACCES (13)
DATA #1 : Codepath, 8 bytes
5:6:11:12:22:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_CRTREV, SQLO_READWRITE, SQLO_EXCLUSIVE, SQLO_WRITETHRU, SQLO_DELAY, SQLO_EXPLOCK, SQLO_CLOSE_ON_EXEC
DATA #4 : Hex integer, 4 bytes
0x000001B4
DATA #5 : signed integer, 4 bytes
0
DATA #6 : signed integer, 4 bytes
0
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
2014-05-14-17.08.09.583424+480 I1016E1631 LEVEL: Error (OS)
PID : 8216 TID : 140310255552288PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, open OSERR: EACCES (13)
DATA #1 : String, 137 bytes
A total of 2 analysis will be performed :
- User info
- Path access permission
Target file = /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #2 : String, 184 bytes
Real user ID of current process = 502
Effective user ID of current process = 502
Real group ID of current process = 102
Effective group ID of current process = 102
DATA #3 : String, 274 bytes
Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
:: (subdirectories)
0:0:755 (home)
777:102:755 (db2inst1)
777:102:3775 (sqllib)
777:102:3775 (ctrl)
777:102:644 (db2strst.lck)
CALLSTCK:
[0] 0x00007F9C8DAFB3FE pdOSSeLoggingCallback + 0x20C
[1] 0x00007F9C8C9C730C /home/db2inst1/sqllib/lib64/libdb2osse.so.1 + 0x1B230C
[2] 0x00007F9C8C9C7203 ossLogSysRC + 0xBF
[3] 0x00007F9C8C9BC43E /home/db2inst1/sqllib/lib64/libdb2osse.so.1 + 0x1A743E
[4] 0x00007F9C8C9B97BD ossErrorAnalysis + 0x2D
[5] 0x00007F9C8F422F61 sqloSystemErrorHandler + 0x6D7
[6] 0x00007F9C8E022C82 sqloopenp + 0x1278
[7] 0x00007F9C8DC02AA2 _Z19sqleGetStStLockFileiiP12SQLO_FHANDLEPcP5sqlca + 0x15E
[8] 0x00007F9C8DC02125 _Z20sqleProcessStartStopiPvP18SQLE_INTERNAL_ARGSP9sqlf_kcfdPcijjP5sqlca + 0x1E1
[9] 0x0000000000403B82 main + 0xA6A
2014-05-14-17.08.09.586701+480 I2648E390 LEVEL: Error
PID : 8216 TID : 140310255552288PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x00007FFF4B839F88 : 0100 0F84 ....收起