软件开发db2 9.7

db2启动IO错误

急!急!急!db2不能启动了,今天在编写自动备份脚本的时候发现数据库报IO错误,就重启了服务器,结果服务器上的db2就启动不了了。报错SQL1652N  发生了文件 I/O 错误。其他信息如下:2014-05-14-17.08.09.582536+480 E4E1011          ...显示全部
急!急!急!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                                  ....收起
参与6

查看其它 4 个回答zhangyiw的回答

zhangyiwzhangyiw系统运维工程师gdrcu
检查实例用户,在数据库目录是否可以touch 文件
曾经试过,在VMware 的虚拟机上,突然间所有文件系统无法写,db2start报错,只能重启。还好修复问题。
银行 · 2014-05-17
浏览2562

回答者

zhangyiw
系统运维工程师gdrcu
擅长领域: 存储python集中式存储

zhangyiw 最近回答过的问题

回答状态

  • 发布时间:2014-05-17
  • 关注会员:1 人
  • 回答浏览:2562
  • X社区推广