数据库在同一时间点报相同错误 进程为db2pclnr？
以下是6号的报错信息，昨天在同一时间点报了相同错误
相关进程是db2pclnr
查了百度对这个进程的解释是：清除缓冲池脏页面到磁盘
但是用df -g查看文件系统使用率都是正常的 所以又觉得不是磁盘空间不足
因为百度对这个进程的相关解释过少，所以还想知道什么时候会触发这个进程db2pclnr
2020-08-06-12.34.19.068213+480 E1861220796A787 LEVEL: Error (OS)
PID : 20775018 TID : 31962 PROC : db2sysc 0
INSTANCE: istrpt NODE : 000 DB : AMRPTDB
HOSTNAME: hasmdbp01
EDUID : 31962 EDUNAME: db2pclnr (AMRPTDB) 0
FUNCTION: DB2 UDB, oper system services, sqloLioAIOCollect, probe:100
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
CALLED : OS, -, aio_return
OSERR : ENOSPC (28) "No space left on device"
DATA #1 : File descriptor, 4 bytes
366
DATA #2 : unsigned integer, 8 bytes
16384
DATA #3 : signed integer, 8 bytes
175112192
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
2020-08-06-12.34.19.069230+480 I1861221584A3234 LEVEL: Error (OS)
PID : 20775018 TID : 30934 PROC : db2sysc 0
INSTANCE: istrpt NODE : 000 DB : AMRPTDB
HOSTNAME: hasmdbp01
EDUID : 30934 EDUNAME: db2pclnr (AMRPTDB) 0
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, aio_return
OSERR : ENOSPC (28) "No space left on device"
DATA #1 : String, 132 bytes
A total of 4 analysis will be performed :
- User info
- ulimit info
- Target file info
- File system
Target file handle = 366
DATA #2 : String, 188 bytes
Real user ID of current process = 1002
Effective user ID of current process = 1002
Real group ID of current process = 1002
Effective group ID of current process = 1002
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: 0x0000000137b86300
DATA #5 : String, 265 bytes
Target File Information :
Size = 1274413056
Link = No
Reference path = N/A
Type = 0x8000
Permissions = rw-------
UID = 1002
GID = 1002
Last modified time = 1596688459
DATA #6 : String, 363 bytes
File System Information of the target file :
Block size = 4096 bytes
Total size = 5368709120 bytes
Free size = 0 bytes
Total # of inodes = 2464
FS name = N/A
Mount point = /istrpt
FSID (major,minor)= 4, 1
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] 0x0900000009DE00E0 pdOSSeLoggingCallback + 0x59C
[1] 0x0900000000C3387C oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1BC
[2] 0x0900000000C33CF0 ossLogSysRC + 0x70
[3] 0x0900000000C5C23C ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xD7C
[4] 0x090000000BFBBD9C sqloSystemErrorHandler + 0x514
[5] 0x090000000BFB93A0 sqloCheckIoResults__20SQLO_LIO_HANDLE_DATAFUliP11SQLO_IO_REQ@OL@21304 + 0x1D8
[6] 0x090000000BFBD6D8 sqloCheckIoResults__24@88@SQLO_LIO_HANDLE_DATAFUliP11SQLO_IO_REQ + 0x308
[7] 0x090000000A0F9F50 sqloLioAIOCollect__20SQLO_LIO_HANDLE_DATAFUlP23SQLO_LIO_COLLECT_STATUSPP11SQLO_IO_REQ13SQLO_LIO_PORT + 0x1730
[8] 0x090000000A118664 sqloLioCollectNBlocks + 0x38
[9] 0x090000000A1464A4 sqlbClnrCollectSomeAIO__FP12SQLB_CLNR_CBUl + 0x70
[10] 0x090000000A13EB70 sqlbClnrEntryPoint__FP12sqbPgClnrEdu + 0x30
[11] 0x090000000A159AD0 sqlbClnrEntryPoint__FP12sqbPgClnrEdu + 0x91C
[12] 0x090000000AECCF98 RunEDU__12sqbPgClnrEduFv + 0x34
[13] 0x090000000A840704 EDUDriver__9sqzEDUObjFv + 0x3F0
[14] 0x090000000A3AE4C4 sqloEDUEntry + 0x3A4
[15] 0x0900000000567E10 _pthread_body + 0xF0
[16] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF