APAR status
Closed as fixed if next.
Error description
"SQL0968C The file system is full" error message when creating the tablespace. This problem is specific to following environment: OS: SLES11 DB: DB2 V9.7 internal disks forming a RAID1E, block size 512 byte external disks forming a RAID6 attached by SCSI, block size 4096byte Example: - ------- db2 "CREATE TABLESPACE ras_db_dyn MANAGED BY DATABASE USING ( FILE '/ras_dyn/ras_db_dyn.dbf' 10000) NO FILE SYSTEM CACHING" # RC = 4: SQL0968C The file system is full. SQLSTATE=57011 db2diag.log file entries: ------------------------ 2009-09-02-11.13.58.111251+120 E4431E1263 LEVEL: Error ( OS) PID : 3060 TID : 140115020081488PROC : db2sysc INSTANCE: db2gis1 NODE : 000 DB : SAMPLEA PPHDL : 0-241 APPID: * LOCAL.db2gis1.090902090450 A UTHID : DB2GIS1 E DUID : 25 EDUNAME: db2agent (SAMPLE) F UNCTION: DB2 UDB, oper system services, sqloseekwrite64, p robe:20 M ESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." DIA8312C Disk was full. C ALLED : OS, -, pwrite OSERR: EINVAL ( 22) D ATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes File Handle = 35 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 = No Write-through Mode = No File Not Tracked = No D ATA #2 : unsigned integer, 8 bytes 5 12 D ATA #3 : signed integer, 8 bytes 5 12 D ATA #4 : signed integer, 8 bytes - 1 D ATA #5 : String, 105 bytes S earch for ossError*Analysis probe point after this log entry f or further s elf-diagnosis of this problem. 2 009-09-02-11.13.58.111515+120 I5695E1989 LEVEL: Error ( OS) P ID : 3060 TID : 140115020081488PROC : d b2sysc I NSTANCE: db2gis1 NODE : 000 DB : SAMPLEA PPHDL : 0-241 APPID: * LOCAL.db2gis1.090902090450 A UTHID : DB2GIS1 E DUID : 25 EDUNAME: db2agent (SAMPLE) F UNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100 C ALLED : OS, -, pwrite OSERR: EINVAL ( 22) D ATA #1 : String, 116 bytes A total of 3 analysis will be performed : - User info - Target file info - I/O attempt Target file handle = 35 D ATA #2 : String, 184 bytes Real user ID of current process = 502 Effective user ID of current process = 502 Real group ID of current process = 202 Effective group ID of current process = 202 D ATA #3 : String, 254 bytes T arget File Information : Size = 0 Link = No Reference path = N/A Type = 0x8000 Permissions = rw------- UID = 502 GID = 202 Last modified time = 1251882838 D ATA #4 : String, 33 bytes I /O attempt not implemented yet. C ALLSTCK: [0] 0x00007F6F1DF033FE pdOSSeLoggingCallback + 0x20C [1] 0x00007F6F1CDCF30C / home/db2gis1/sqllib/lib64/libdb2osse.so.1 + 0x1B230C [2] 0x00007F6F1CDCF203 ossLogSysRC + 0xBF [3] 0x00007F6F1CDC443E / home/db2gis1/sqllib/lib64/libdb2osse.so.1 + 0x1A743E [4] 0x00007F6F1CDC17BD ossErrorAnalysis + 0x2D [5] 0x00007F6F1F82AF61 sqloSystemErrorHandler + 0x6D7 [6] 0x00007F6F1E427B38 sqloseekwrite64 + 0x66E [7] 0x00007F6F1EAFB309 _ Z26sqlbDMSAddContainerRequestP12SQLB_POOL_CBP16SQLB_POOLCONT_CBP 12SQLB_GLOBALSP14SQLB_pfParIoCbbm + 0x154F [8] 0x00007F6F1EB0D6FF _ Z29sqlbDoDMSAddContainerRequestsP12SQLB_POOL_CBP16SQLB_POOLCONT_ CBjP26SQLB_AS_CONT_AND_PATH_INFOP12SQLB_GLOBALS + 0x2D5 [9] 0x00007F6F1EB0D34E _ Z29sqlbDMSAddContainersToNewPoolP12SQLB_POOL_CBiP16SQLB_POOLCONT _CBP12SQLB_GLOBALS + 0x37A 2 009-09-02-11.13.58.118479+120 I7685E619 LEVEL: Error P ID : 3060 TID : 140115020081488PROC : d b2sysc I NSTANCE: db2gis1 NODE : 000 DB : SAMPLEA PPHDL : 0-241 APPID: * LOCAL.db2gis1.090902090450 A UTHID : DB2GIS1 E DUID : 25 EDUNAME: db2agent (SAMPLE) F UNCTION: DB2 UDB, buffer pool services, s qlbDMSAddContainerRequest, probe:865 M ESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." DIA8312C Disk was full. D ATA #1 : <preformatted> E rror acquiring container 0 (/ras_dyn/ras_db_dyn.dbf) for tbsp 6 . Rc = 850F000C - ------------------------
Local fix
Set registry variable DB2_DIRECT_IO=false
Problem summary
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * ERROR DESCRIPTION:"SQL0968C The file system is full" error * * message whencreatingthe tablespace.This problem is specific * * to following environment:OS: SLES11DB: DB2 V9.7internal * * disks forming a RAID1E, block size 512 byteexternal disks * * forming a RAID6 attached by SCSI, block * * size4096byteExample:--------db2 "CREATE TABLESPACE * * ras_db_dyn MANAGED BY DATABASE USING(FILE * * '/ras_dyn/ras_db_dyn.dbf' 10000) NO FILE SYSTEMCACHING"# RC * * = 4:SQL0968C The file system is full. * * SQLSTATE=57011db2diag.log file * * entries:------------------------2009-09-02-11.13.58.111251+120 * E4431E1263 LEVEL:Error(OS)PID : 3060 * * TID : 140115020081488PROC :db2syscINSTANCE: db2gis1 * * NODE : 000 DB :SAMPLEAPPHDL : 0-241 * * APPID:*LOCAL.db2gis1.090902090450AUTHID : * * DB2GIS1EDUID : 25 EDUNAME: db2agent * * (SAMPLE)FUNCTION: DB2 UDB, oper system services, * * sqloseekwrite64,probe:20MESSAGE : * * ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."DIA8312C * * Disk was full.CALLED : OS, -, pwrite * * OSERR:EINVAL (22)DATA #1 : File handle, * * PD_TYPE_SQO_FILE_HDL, 8 bytesFile Handle = * * 35File System Block Size = 0 bytesFile System Type * * = UNKNOWNFile Handle Flags :Require Sector Align = * * NoDIO/CIO Mode = YesRaw Block Device = * * NoReserved Handle = NoFlush On Close = * * YesThread-Level Lock = NoWrite-through Mode = * * NoFile Not Tracked = NoDATA #2 : unsigned integer, 8 * * bytes512DATA #3 : signed integer, 8 bytes512DATA #4 : signed * * integer, 8 bytes-1DATA #5 : String, 105 bytesSearch for * * ossError*Analysis probe point after this log entryfor * * furtherself-diagnosis of this * * problem.2009-09-02-11.13.58.111515+120 I5695E1989 * * LEVEL:Error (OS)PID : 3060 TID : * * 140115020081488PROC :db2syscINSTANCE: db2gis1 * * NODE : 000 DB :SAMPLEAPPHDL : 0-241 * * APPID:*LOCAL.db2gis1.090902090450AUTHID : DB2GIS1EDUID * * : 25 EDUNAME: db2agent (SAMPLE)FUNCTION: * * DB2 Common, OSSe, ossErrorIOAnalysis, probe:100CALLED : OS, * * -, pwrite OSERR:EINVAL (22)DATA #1 * * : String, 116 bytesAtotal of 3 analysis will be performed :- * * User info- Target file info- I/O attemptTarget file handle = * * 35DATA #2 : String, 184 bytesReal user ID of current process * * = 502Effective user ID of current process = 502Real * * group ID of current process = 202Effective group ID of * * current process = 202DATA #3 : String, 254 bytesTarget File * * Information :Size = 0Link = * * NoReference path = N/AType = * * 0x8000Permissions = rw-------UID = * * 502GID = 202Last modified time = * * 1251882838DATA #4 : String, 33 bytesI/O attempt not * * implemented yet.CALLSTCK:[0] 0x00007F6F1DF033FE * * pdOSSeLoggingCallback + 0x20C[1] * * 0x00007F6F1CDCF30C/home/db2gis1/sqllib/lib64/libdb2osse.so.1 * * + 0x1B230C[2] 0x00007F6F1CDCF203 ossLogSysRC + 0xBF[3] * * 0x00007F6F1CDC443E/home/db2gis1/sqllib/lib64/libdb2osse.so.1 * * + 0x1A743E[4] 0x00007F6F1CDC17BD ossErrorAnalysis + 0x2D[5] * * 0x00007F6F1F82AF61 sqloSystemErrorHandler + 0x6D7[6] * * 0x00007F6F1E427B38 sqloseekwrite64 + 0x66E[7] * * 0x00007F6F1EAFB309Z26sqlbDMSAddContainerRequestP12SQLB_POOL_CB * 0x00007F6F1EB0D6FFZ29sqlbDoDMSAddContainerRequestsP12SQLB_POOL * 0x00007F6F1EB0D34EZ29sqlbDMSAddContainersToNewPoolP12SQLB_POOL * I7685E619 LEVEL:Error PID : 3060 * * TID : 140115020081488PROC :db2syscINSTANCE: db2gis1 * * NODE : 000 DB :SAMPLEAPPHDL : 0-241 * * APPID:*LOCAL.db2gis1.090902090450AUTHID : * * DB2GIS1EDUID : 25 EDUNAME: db2agent * * (SAMPLE)FUNCTION: DB2 UDB, buffer pool * * services,sqlbDMSAddContainerRequest, probe:865MESSAGE : * * ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."DIA8312C * * Disk was full.DATA #1 : <preformatted>Error acquiring * * container 0 (/ras_dyn/ras_db_dyn.dbf) fortbsp 6. Rc = * * 850F000C------------------------- * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.7 FP2ORSet registry variable * * DB2_DIRECT_IO=false * ****************************************************************
Problem conclusion
DB2 V9.7 FP2
Temporary fix
Comments
APAR Information
APAR number
IC64785
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
970
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-11-24
Closed date
2010-05-25
Last modified date
2010-05-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R970 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 May 2010