大家帮帮忙分析一下下面的错误是什么原因引起的,谢谢。
以下是db2diag.log日志
2013-12-28-23.00.08.885603+480 E269785A1172 LEVEL: Error (OS)
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, oper system services, sqlowrite, probe:70
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
CALLED : OS, -, write
OSERR : ENOSPC (28) "No space left on device"
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 26
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = Yes
Raw Block Device = No
Reserved Handle = No
Flush On Close = Yes
Thread-Level Lock = Yes
Write-through Mode = No
File Not Tracked = No
DATA #2 : unsigned integer, 8 bytes
262144
DATA #3 : signed integer, 8 bytes
147456
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
2013-12-28-23.00.08.886564+480 I270958A3062 LEVEL: Error (OS)
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, write
OSERR : ENOSPC (28) "No space left on device"
DATA #1 : String, 146 bytes
A total of 5 analysis will be performed :
- User info
- ulimit info
- Target file info
- I/O attempt
- File system
Target file handle = 26
DATA #2 : String, 184 bytes
Real user ID of current process = 321
Effective user ID of current process = 321
Real group ID of current process = 320
Effective group ID of current process = 320
DATA #3 : String, 381 bytes
Current process limits (unit in bytes except for nofiles) :
mem (S/H) = unlimited / unlimited
core (S/H) = unlimited / unlimited
cpu (S/H) = unlimited / unlimited
data (S/H) = unlimited / unlimited
fsize (S/H) = unlimited / unlimited
nofiles (S/H) = unlimited / unlimited
stack (S/H) = 4294967296 / 4294967296
rss (S/H) = unlimited / unlimited
DATA #4 : String, 41 bytes
current sbrk(0) value: 0x00000001149e4ec0
DATA #5 : String, 262 bytes
Target File Information :
Size = 266493952
Link = No
Reference path = N/A
Type = 0x8000
Permissions = rw-------
UID = 321
GID = 320
Last modified time = 1388242808
DATA #6 : String, 33 bytes
I/O attempt not implemented yet.
DATA #7 : String, 366 bytes
File System Information of the target file :
Block size = 4096 bytes
Total size = 8589934592 bytes
Free size = 0 bytes
Total # of inodes = 96
FS name = N/A
Mount point = /amfe/dblog
FSID (major,minor)= 10, 3
FS type name = jfs2
DIO/CIO mount opt = None
Device type = N/A
FS type = 0x6
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000000D62224 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[1] 0x0900000000D626DC ossLogSysRC + 0x9C
[2] 0x0900000000D88E00 ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xC40
[3] 0x0900000000D8AE68
ossErrorAnalysis@AF12_1 + 0x48
[4] 0x09000000061B1AFC sqloSystemErrorHandler + 0x52C
[5] 0x0900000006AE7F50 sqlowrite + 0x6A8
[6] 0x0900000008EF70C0 sqlpgifl__FP9SQLP_DBCBPcP9SQLP_LECBT2UlUsC9SQLP_LSN8CUl + 0xBA0
[7] 0x0900000008EFC394 sqlpgCallGIFL__FP9SQLP_DBCBUl + 0x1084
[8] 0x09000000078BCB64 sqlpgadf__FP9SQLP_DBCBb + 0x9B0
[9] 0x0900000006B436AC sqlpLoggrMain__11sqpLoggrEduFv + 0x3DC0
[10] 0x0900000006933154 RunEDU__11sqpLoggrEduFv + 0x34
[11] 0x0900000006931704 EDUDriver__9sqzEDUObjFv + 0x3EC
[12] 0x09000000069312DC sqlzRunEDU__FPcUi + 0x10
[13] 0x090000000693E248 sqloEDUEntry + 0x264
[14] 0x0900000000623C90 _pthread_body + 0xF0
[15] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2013-12-28-23.00.08.887356+480 I274021A546 LEVEL: Error
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgifl, probe:50
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
DATA #1 : String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: Address is NULL
2013-12-28-23.00.08.888566+480 I274568A431 LEVEL: Error
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgCallGIFL, probe:2750
DATA #1 :
Error rc -2062614516 when initializing log file 118
2013-12-28-23.00.08.889024+480 E275000A443 LEVEL: Error
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgadf, probe:1970
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
2013-12-28-23.00.08.889501+480 I275444A415 LEVEL: Info
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgadf, probe:1970
DATA #1 :
Last log file not required: S0000086.LOG.
2013-12-28-23.00.08.889951+480 I275860A518 LEVEL: Info
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrAttemptPeriodicLogAllocation, probe:465
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
DATA #1 :
Ignoring return code.
2013-12-29-23.00.01.930574+480 E276379A530 LEVEL: Info
PID : 14483538 TID : 7454 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
APPHDL : 0-5288 APPID: *LOCAL.db2inst1.131229150001
AUTHID : DB2INST1 HOSTNAME: bj1amfdb01
EDUID : 7454 EDUNAME: db2agent (FUNDDB) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:542
DATA #1 :
Autonomic backup/restore - using parallelism = 10.
2013-12-29-23.00.01.938307+480 E276910A557 LEVEL: Info
PID : 14483538 TID : 7454 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
APPHDL : 0-5288 APPID: *LOCAL.db2inst1.131229150001
AUTHID : DB2INST1 HOSTNAME: bj1amfdb01
EDUID : 7454 EDUNAME: db2agent (FUNDDB) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetAvailableHeapPages, probe:648
DATA #1 :
Autonomic BAR - heap consumption.
Targetting (50%) - 130784 of 261568 pages.
2013-12-29-23.00.01.938836+480 E277468A544 LEVEL: Info
PID : 14483538 TID : 7454 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
APPHDL : 0-5288 APPID: *LOCAL.db2inst1.131229150001
AUTHID : DB2INST1 HOSTNAME: bj1amfdb01
EDUID : 7454 EDUNAME: db2agent (FUNDDB) 0
FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers, probe:903
DATA #1 :
Autonomic backup - tuning enabled.
Using buffer size = 4097, number = 10.
2013-12-29-23.00.01.953397+480 E278013A490 LEVEL: Info
PID : 14483538 TID : 7454 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
APPHDL : 0-5288 APPID: *LOCAL.db2inst1.131229150001
AUTHID : DB2INST1 HOSTNAME: bj1amfdb01
EDUID : 7454 EDUNAME: db2agent (FUNDDB) 0
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1784
MESSAGE : Starting an online db backup.
2013-12-29-23.00.08.175615+480 E278504A1899 LEVEL: Info
PID : 14483538 TID : 7454 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
APPHDL : 0-5288 APPID: *LOCAL.db2inst1.131229150001
AUTHID : DB2INST1 HOSTNAME: bj1amfdb01
EDUID : 7454 EDUNAME: db2agent (FUNDDB) 0
FUNCTION: DB2 UDB, database utilities, sqluxLogDataStats, probe:393
MESSAGE : Performance statistics
DATA #1 : String, 1391 bytes
Number of buffers = 10
Buffer size = 16781312 (4097 4kB pages)
BM# Total I/O MsgQ WaitQ Buffers kBytes
--- -------- -------- -------- -------- -------- --------
000 5.74 1.18 4.22 0.02 69 1095168
001 5.69 0.11 0.23 5.34 2 26112
002 5.69 0.61 2.51 2.45 33 524800
003 5.69 0.11 0.00 5.57 1 12288
004 5.69 0.29 1.26 4.08 15 236544
005 5.70 1.64 3.01 0.98 20 295424
006 5.69 0.07 0.00 5.60 1 10496
007 5.69 0.17 0.01 5.49 2 27392
008 5.69 0.20 1.04 4.42 4 49664
009 5.69 0.05 0.00 5.63 1 1760
--- -------- -------- -------- -------- -------- --------
TOT 57.00 4.47 12.30 39.63 148 2279648
MC# Total I/O MsgQ WaitQ Buffers kBytes
--- -------- -------- -------- -------- -------- --------
000 6.12 6.00 0.10 0.00 149 2409068
--- -------- -------- -------- -------- -------- --------
TOT 6.12 6.00 0.10 0.00 149 2409068
2013-12-29-23.00.08.176036+480 E280404A464 LEVEL: Info
PID : 14483538 TID : 7454 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
APPHDL : 0-5288 APPID: *LOCAL.db2inst1.131229150001
AUTHID : DB2INST1 HOSTNAME: bj1amfdb01
EDUID : 7454 EDUNAME: db2agent (FUNDDB) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:979
MESSAGE : Backup complete.
2013-12-29-23.00.08.628661+480 E280869A428 LEVEL: Info
PID : 14483538 TID : 23224 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23224 EDUNAME: db2logmgr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S0000087.LOG.
2013-12-29-23.00.08.631163+480 I281298A539 LEVEL: Info
PID : 14483538 TID : 23224 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23224 EDUNAME: db2logmgr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
DATA #1 :
Completed archive for log file S0000087.LOG to /amfe/dbarchlog/db2inst1/FUNDDB/NODE0000/LOGSTREAM0000/C0000000/ from /amfe/dblog/NOD
E0000/LOGSTREAM0000/.
2013-12-29-23.00.08.784601+480 I281838A509 LEVEL: Warning
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRenameFileDuringLogReclaim, probe:8002
DATA #1 : String, 42 bytes
Delete small file instead of extending it.
DATA #2 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
87
2013-12-29-23.00.09.789054+480 E282348A1172 LEVEL: Error (OS)
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, oper system services, sqlowrite, probe:70
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
CALLED : OS, -, write
OSERR : ENOSPC (28) "No space left on device"
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 27
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = Yes
Raw Block Device = No
Reserved Handle = No
Flush On Close = Yes
Thread-Level Lock = Yes
Write-through Mode = No
File Not Tracked = No
DATA #2 : unsigned integer, 8 bytes
262144
DATA #3 : signed integer, 8 bytes
147456
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
2013-12-29-23.00.09.790024+480 I283521A3062 LEVEL: Error (OS)
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, write
OSERR : ENOSPC (28) "No space left on device"
DATA #1 : String, 146 bytes
A total of 5 analysis will be performed :
- User info
- ulimit info
- Target file info
- I/O attempt
- File system
Target file handle = 27
DATA #2 : String, 184 bytes
Real user ID of current process = 321
Effective user ID of current process = 321
Real group ID of current process = 320
Effective group ID of current process = 320
DATA #3 : String, 381 bytes
Current process limits (unit in bytes except for nofiles) :
mem (S/H) = unlimited / unlimited
core (S/H) = unlimited / unlimited
cpu (S/H) = unlimited / unlimited
data (S/H) = unlimited / unlimited
fsize (S/H) = unlimited / unlimited
nofiles (S/H) = unlimited / unlimited
stack (S/H) = 4294967296 / 4294967296
rss (S/H) = unlimited / unlimited
DATA #4 : String, 41 bytes
current sbrk(0) value: 0x00000001149e4ec0
DATA #5 : String, 262 bytes
Target File Information :
Size = 266493952
Link = No
Reference path = N/A
Type = 0x8000
Permissions = rw-------
UID = 321
GID = 320
Last modified time = 1388329209
DATA #6 : String, 33 bytes
I/O attempt not implemented yet.
DATA #7 : String, 366 bytes
File System Information of the target file :
Block size = 4096 bytes
Total size = 8589934592 bytes
Free size = 0 bytes
Total # of inodes = 96
FS name = N/A
Mount point = /amfe/dblog
FSID (major,minor)= 10, 3
FS type name = jfs2
DIO/CIO mount opt = None
Device type = N/A
FS type = 0x6
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000000D62224 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[1] 0x0900000000D626DC ossLogSysRC + 0x9C
[2] 0x0900000000D88E00 ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xC40
[3] 0x0900000000D8AE68 ossErrorAnalysis@AF12_1 + 0x48
[4] 0x09000000061B1AFC sqloSystemErrorHandler + 0x52C
[5] 0x0900000006AE7F50 sqlowrite + 0x6A8
[6] 0x0900000008EF70C0 sqlpgifl__FP9SQLP_DBCBPcP9SQLP_LECBT2UlUsC9SQLP_LSN8CUl + 0xBA0
[7] 0x0900000008EFC394 sqlpgCallGIFL__FP9SQLP_DBCBUl + 0x1084
[8] 0x09000000078BCB64 sqlpgadf__FP9SQLP_DBCBb + 0x9B0
[9] 0x0900000006B436AC sqlpLoggrMain__11sqpLoggrEduFv + 0x3DC0
[10] 0x0900000006933154 RunEDU__11sqpLoggrEduFv + 0x34
[11] 0x0900000006931704 EDUDriver__9sqzEDUObjFv + 0x3EC
[12] 0x09000000069312DC sqlzRunEDU__FPcUi + 0x10
[13] 0x090000000693E248 sqloEDUEntry + 0x264
[14] 0x0900000000623C90 _pthread_body + 0xF0
[15] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2013-12-29-23.00.09.790818+480 I286584A546 LEVEL: Error
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgifl, probe:50
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
DATA #1 : String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: Address is NULL
2013-12-29-23.00.09.792049+480 I287131A431 LEVEL: Error
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgCallGIFL, probe:2750
DATA #1 :
Error rc -2062614516 when initializing log file 119
2013-12-29-23.00.09.792509+480 E287563A443 LEVEL: Error
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgadf, probe:1970
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
2013-12-29-23.00.09.792987+480 I288007A415 LEVEL: Info
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgadf, probe:1970
DATA #1 :
Last log file not required: S0000087.LOG.
2013-12-29-23.00.09.793438+480 I288423A518 LEVEL: Info
PID : 14483538 TID : 23481 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FUNDDB
HOSTNAME: bj1amfdb01
EDUID : 23481 EDUNAME: db2loggr (FUNDDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrAttemptPeriodicLogAllocation, probe:465
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
DATA #1 :
Ignoring return code.收起