Symptom
You got the following errors in the db2diag.log while the file system itself has enough free space:
2020-01-08-14.18.01.062854+000 E15402627E783 LEVEL: Error (OS)
PID : 116370 TID : 139754188302080 PROC : db2sysc 0
INSTANCE: xxxx NODE : 000 DB : xxx
HOSTNAME: xxxx
EDUID : 31 EDUNAME: db2pclnr (TDS) 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)
DATA #1 : File descriptor, 4 bytes
453
DATA #2 : unsigned integer, 8 bytes
16384
DATA #3 : signed integer, 8 bytes
160808960
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
2020-01-08-14.18.01.063485+000 I15403411E2820 LEVEL: Error (OS)
PID : 116370 TID : 139754188302080 PROC : db2sysc 0
INSTANCE: xxxx NODE : 000 DB : xxx
HOSTNAME: xxxx
EDUID : 31 EDUNAME: db2pclnr (TDS) 0
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, aio_return OSERR: ENOSPC (28)
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 = 453
DATA #2 : String, 188 bytes
Real user ID of current process = 9067
Effective user ID of current process = 9067
Real group ID of current process = 1010
Effective group ID of current process = 1010
DATA #3 : String, 369 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) = 65534 / 65534
stack (S/H) = 8388608 / unlimited
rss (S/H) = unlimited / unlimited
DATA #4 : String, 41 bytes
current sbrk(0) value: 0x000000000075a000
DATA #5 : String, 264 bytes
Target File Information :
Size = 160563200
Link = No
Reference path = N/A
Type = 0x8000
Permissions = rw-------
UID = 9067
GID = 1010
Last modified time = 1578493080
DATA #6 : String, 375 bytes
File System Information of the target file :
Block size = 4096 bytes
Total size = 21137846272 bytes
Free size = 301711360 bytes
Total # of inodes = 1310720
FS name = rootfs
Mount point = /
FSID = 64794
FS type name = rootfs
DIO/CIO mount opt = None
Device type = N/A
FS type = 0xe
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
DIA8312C, "Disk full"
, KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.