SAP Knowledge Base Article - Preview

2532028 - SAP IQ - Disk is or will be full on I/O to or allocation of file error during RW operations

Symptom

Data load operation failed due to following error whereas there were other dbfiles had enough free space.

Exception Thrown from oslib/hos_bio.cxx:902, Err# 33, tid 2 origtid 2
O/S Err#: 28, ErrID: 518 (hos_bioexception); SQLCode: -1006094, SQLState: 'QBA94', Severity: 14
[20332]: Disk is or will be full on I/O to or allocation of file /IQDEV/USER_MAIN_03
-- (oslib/hos_bio.cxx 902)
Write blk 32896750 for 16 blk(s) (dbBlkSz 32768)

 

--sp_iqfile

DBSpaceName,DBFileName,Path,SegmentType,RWMode,Online,Usage,DBFileSize,Reserve,StripeSize,BlkTypes,FirstBlk,LastBlk,OkToDrop,servername,mirrorLogicalFileName,IsDASSharedFile
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
'IQ_SYSTEM_MAIN','IQ_SYSTEM_MAIN_01',/IQDEV/IQ_SYSTEM_MAIN_01,'MAIN','RW','T','24','928G','0B','1K','1H,6079968F,32D,151A,1898O,128M,32C',1,30400000,'N',,'(NULL)','F'
'USER_MAIN','USER_MAIN_01',/IQDEV/USER_MAIN_01,'MAIN','RW','T','92','1T','0B','1K','1H,30829632A,1110O',33478656,67033087,'N',,'(NULL)','F'
'USER_MAIN','USER_MAIN_02',/IQDEV/USER_MAIN_02,'MAIN','RW','T','96','1T','0B','1K','1H,31899016A,1070O',71142144,104696575,'N',,'(NULL)','F'
'USER_MAIN','USER_MAIN_03',/IQDEV/USER_MAIN_03,'MAIN','RW','T','98','1T','0B','1K','1H,32734806A,1050O',108805632,142360063,'N',,'(NULL)','F'
...
'USER_MAIN','USER_MAIN_09',/IQDEV/USER_MAIN_09,'MAIN','RW','T','1','1T','0B','1K','1H,4024A,1075O',334786560,368340991,'N',,'(NULL)','F'
'USER_MAIN','USER_MAIN_10',/IQDEV/USER_MAIN_10,'MAIN','RW','T','1','1T','0B','1K','1H,4063A,1060O',372450048,406004479,'N',,'(NULL)','F'
'IQ_SHARED_TEMP','IQ_SHARED_TEMP_01',/IQDEV/IQ_SHARED_TEMP_01,'TEMPORARY','RW','T','2','928G','0B','1K','1H,288F,419347A',1,30400000,'Y',,'(NULL)','F'


Read more...

Environment

SAP IQ uses raw devices as IQ dbfiles

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

"Disk is or will be full"; "oslib/hos_bio.cxx"; "raw device"; "create dbspace"; "alter dbspace"; "size" , KBA , BC-SYB-IQ , Sybase IQ , 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.