IBM Support

IC64785: RECEIVE "SQL0968C THE FILE SYSTEM IS FULL" ERROR MESSAGE WHEN CREATING THE TABLESPACE.

Subscribe

You can track all active APARs for this component.

 

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