db2stop 出现IO错误
各位大神今早在做db2的升级 然后在跑 db2stop的时候出现了IO错误$ db2stopSQL1652N File I/O error occurred.然后看了这个里面的介绍用root去跑了下 db2iudpthttp://www-01.ibm.com/support/docview.wss?uid=swg21659666然后还是有错误 貌似是access的问题. ...显示全部
各位大神今早在做db2的升级 然后在跑 db2stop的时候出现了IO错误$ db2stop
SQL1652N File I/O error occurred.
然后看了这个里面的介绍用root去跑了下 db2iudpt
http://www-01.ibm.com/support/docview.wss?uid=swg21659666
然后还是有错误 貌似是access的问题. 可是看了下/home/db2inst1 权限对着呢呀!
一下是从db2diag.log里 求大神们给点建议 去查那里的权限
2014-03-03-11.38.57.947659+330 E248362A880 LEVEL: Error (OS)
PID : 5373994 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
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) "Permission denied"
DATA #1 : Codepath, 8 bytes
5:6:14:15:17:23:24:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : Bitmask, 4 bytes
0x0000074F
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-03-03-11.38.58.019529+330 I249243A1647 LEVEL: Error (OS)
PID : 5373994 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, open
OSERR : EACCES (13) "Permission denied"
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, 182 bytes
Real user ID of current process = 209
Effective user ID of current process = 207
Real group ID of current process = 208
Effective group ID of current process = 0
DATA #3 : String, 41 bytes
current sbrk(0) value: 0x00000001101a1560
DATA #4 : String, 258 bytes
Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
:: (subdirectories)
0:0:755 (home)
0:0:775 (db2inst1)
0:0:3775 (sqllib)
0:0:3775 (ctrl)
0:0:644 (db2strst.lck)
CALLSTCK:
[0] 0x090000000BA7FBB0 pdOSSeLoggingCallback + 0x80
[1] 0x090000000209F8B0 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1B0
[2] 0x090000000209FE14 ossLogSysRC + 0xD4
[3] 0x09000000020AF3B4 ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xC74
[4] 0x090000000ABBB7DC sqloSystemErrorHandler + 0x39C
[5] 0x090000000ABBCCC8 sqloSystemErrorHandler@glue6AB + 0x1A8
[6] 0x090000000A6E8A18 sqloopenp + 0xCEC
[7] 0x090000000BAE58EC sqleProcessStartStop__FiPvP18SQLE_INTERNAL_ARGSP9sqlf_kcfdPcT1UiT7P5sqlca + 0x298
[8] 0x0000000100001688 main + 0xE48
[9] 0x00000001000002D8 __start + 0x98
2014-03-03-11.38.58.032472+330 I250891A398 LEVEL: Error
PID : 5373994 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD6B4 : 840F 0001 ....
2014-03-03-14.03.41.010293+330 E251290A879 LEVEL: Error (OS)
PID : 4456672 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
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) "Permission denied"
DATA #1 : Codepath, 8 bytes
5:6:14:15:17:23:24:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : Bitmask, 4 bytes
0x0000074F
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-03-03-14.03.41.012321+330 I252170A397 LEVEL: Error
PID : 4456672 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD734 : 840F 0001 ....
2014-03-23-07.55.10.233776+330 E252568A879 LEVEL: Error (OS)
PID : 9896096 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
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) "Permission denied"
DATA #1 : Codepath, 8 bytes
5:6:14:15:17:23:24:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : Bitmask, 4 bytes
0x0000074F
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-03-23-07.55.10.455073+330 I253448A397 LEVEL: Error
PID : 9896096 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD734 : 840F 0001 ....
2014-03-23-07.55.20.851053+330 E253846A879 LEVEL: Error (OS)
PID : 9896104 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
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) "Permission denied"
DATA #1 : Codepath, 8 bytes
5:6:14:15:17:23:24:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : Bitmask, 4 bytes
0x0000074F
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-03-23-07.55.20.852210+330 I254726A397 LEVEL: Error
PID : 9896104 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD734 : 840F 0001 ....
DBI1089E Error in saving current instance related information in the
/home/db2inst1/sqllib/backup directory.
Explanation:
There may be several reasons for this error. It is likely that one of
the following situations has occurred:
* The given directory does not have sufficient permissions or does not
have the write permission.
* There is no space left on the file system.
User response:
Take an appropriate corrective action and issue the command again.
DBI1079I Output is saved in the log file /tmp/db2iupdt.log.8061100.
Explanation:
All processed and failed operations have been saved into this log file.
User response:
Do not modify this file in any way. This file is for IBM Technical
Support reference.收起
SQL1652N File I/O error occurred.
然后看了这个里面的介绍用root去跑了下 db2iudpt
http://www-01.ibm.com/support/docview.wss?uid=swg21659666
然后还是有错误 貌似是access的问题. 可是看了下/home/db2inst1 权限对着呢呀!
一下是从db2diag.log里 求大神们给点建议 去查那里的权限
2014-03-03-11.38.57.947659+330 E248362A880 LEVEL: Error (OS)
PID : 5373994 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
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) "Permission denied"
DATA #1 : Codepath, 8 bytes
5:6:14:15:17:23:24:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : Bitmask, 4 bytes
0x0000074F
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-03-03-11.38.58.019529+330 I249243A1647 LEVEL: Error (OS)
PID : 5373994 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, open
OSERR : EACCES (13) "Permission denied"
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, 182 bytes
Real user ID of current process = 209
Effective user ID of current process = 207
Real group ID of current process = 208
Effective group ID of current process = 0
DATA #3 : String, 41 bytes
current sbrk(0) value: 0x00000001101a1560
DATA #4 : String, 258 bytes
Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
0:0:755 (home)
0:0:775 (db2inst1)
0:0:3775 (sqllib)
0:0:3775 (ctrl)
0:0:644 (db2strst.lck)
CALLSTCK:
[0] 0x090000000BA7FBB0 pdOSSeLoggingCallback + 0x80
[1] 0x090000000209F8B0 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1B0
[2] 0x090000000209FE14 ossLogSysRC + 0xD4
[3] 0x09000000020AF3B4 ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xC74
[4] 0x090000000ABBB7DC sqloSystemErrorHandler + 0x39C
[5] 0x090000000ABBCCC8 sqloSystemErrorHandler@glue6AB + 0x1A8
[6] 0x090000000A6E8A18 sqloopenp + 0xCEC
[7] 0x090000000BAE58EC sqleProcessStartStop__FiPvP18SQLE_INTERNAL_ARGSP9sqlf_kcfdPcT1UiT7P5sqlca + 0x298
[8] 0x0000000100001688 main + 0xE48
[9] 0x00000001000002D8 __start + 0x98
2014-03-03-11.38.58.032472+330 I250891A398 LEVEL: Error
PID : 5373994 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD6B4 : 840F 0001 ....
2014-03-03-14.03.41.010293+330 E251290A879 LEVEL: Error (OS)
PID : 4456672 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
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) "Permission denied"
DATA #1 : Codepath, 8 bytes
5:6:14:15:17:23:24:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : Bitmask, 4 bytes
0x0000074F
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-03-03-14.03.41.012321+330 I252170A397 LEVEL: Error
PID : 4456672 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD734 : 840F 0001 ....
2014-03-23-07.55.10.233776+330 E252568A879 LEVEL: Error (OS)
PID : 9896096 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
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) "Permission denied"
DATA #1 : Codepath, 8 bytes
5:6:14:15:17:23:24:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : Bitmask, 4 bytes
0x0000074F
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-03-23-07.55.10.455073+330 I253448A397 LEVEL: Error
PID : 9896096 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD734 : 840F 0001 ....
2014-03-23-07.55.20.851053+330 E253846A879 LEVEL: Error (OS)
PID : 9896104 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
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) "Permission denied"
DATA #1 : Codepath, 8 bytes
5:6:14:15:17:23:24:37
DATA #2 : File name, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #3 : Bitmask, 4 bytes
0x0000074F
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-03-23-07.55.20.852210+330 I254726A397 LEVEL: Error
PID : 9896104 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:20
MESSAGE : /home/db2inst1/sqllib/ctrl/db2strst.lck
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD734 : 840F 0001 ....
DBI1089E Error in saving current instance related information in the
/home/db2inst1/sqllib/backup directory.
Explanation:
There may be several reasons for this error. It is likely that one of
the following situations has occurred:
* The given directory does not have sufficient permissions or does not
have the write permission.
* There is no space left on the file system.
User response:
Take an appropriate corrective action and issue the command again.
DBI1079I Output is saved in the log file /tmp/db2iupdt.log.8061100.
Explanation:
All processed and failed operations have been saved into this log file.
User response:
Do not modify this file in any way. This file is for IBM Technical
Support reference.收起