SQL0968C The file system is full. SQLSTATE=57011 during EXPORT

[#1]

Hi Experts

          We are facing the error SQL0968C  The file system is full.  SQLSTATE=57011 during the EXPORT of the System. The log for the package which is  failed  as shown

LOG:

/usr/sap/PR3/SYS/exe/run/R3load: START OF LOG: 20150415023459

/usr/sap/PR3/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#21 $ SAP

/usr/sap/PR3/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Dec 12 2009 04:42:01

/usr/sap/PR3/SYS/exe/run/R3load -e BSIS.cmd -datacodepage 4102 -l BSIS.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: Export without hintfile

(GSI) INFO: dbname   = "PR3                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "HP-UX"

(GSI) INFO: nodename = "prqr3"

(GSI) INFO: release  = "B.11.23"

(GSI) INFO: version  = "U"

(GSI) INFO: machine  = "ia64"

(GSI) INFO: instno   = "0020260282"

(EXP) ERROR: DbSlExeRead failed

  rc = 99, table "BSIS"

  (SQL error -968)

  error message returned by DbSl:

SQL0968C  The file system is full.  SQLSTATE=57011

(DB) INFO: disconnected from DB

/usr/sap/PR3/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/PR3/SYS/exe/run/R3load: END OF LOG: 20150415032219

[former_member182657 · Accepted solution]

Hi,

SQL0968C  The file system is full

Have you checked space at OS level & table spaces,If required try to extend table space if any & retry the process again.

Good luck !!

[Former Member · Accepted solution]

Hi Gaurav Rana

       Thanks for fast reply.

           We checked at os level we have spaces. The following was the output when i go for df -b command

# df -b

/db2                  (/dev/vg01/lvol5       ) :  1909661 Kbytes free

/home               (/dev/vg01/lvol6       ) : 10318228 Kbytes free

/opt                   (/dev/vg01/lvol7       ) :  5254704 Kbytes free

/tmp                  (/dev/vg01/lvol8       ) :  9621318 Kbytes free

/usr                   (/dev/vg01/lvol9       ) :  5196303 Kbytes free

/var                   (/dev/vg01/lvol10      ) : 17278600 Kbytes free

/stand                (/dev/vg01/lvol1       ) :  1943738 Kbytes free

/                        (/dev/vg01/lvol4       ) : 19097424 Kbytes free -----------export directory location

After that When i go for command "db2 list tablespaces show detail" i found that the following tablespaces which are got fulled. The log was as follows

Tablespace ID                        = 3

Name                                   = PSAPTEMP16

Type                                 = System managed space

Contents                             = System Temporary data

State                                = 0x0000

Detailed explanation:

Normal

Total pages                          = 1

Useable pages                        = 1

Used pages                           = 1

Free pages                           = Not applicable

High water mark (pages)              = Not applicable

Page size (bytes)                    = 16384

Extent size (pages)                  = 2

Prefetch size (pages)                = 2

Number of containers                 = 1

----------------------------------------

Tablespace ID                        = 4

Name                                 = SYSTOOLSTMPSPACE

Type                                 = System managed space

Contents                             = User Temporary data

State                                = 0x0000

   Detailed explanation:

     Normal

Total pages                          = 1

Useable pages                        = 1

Used pages                           = 1

Free pages                           = Not applicable

High water mark (pages)              = Not applicable

Page size (bytes)                    = 16384

Extent size (pages)                  = 2

Prefetch size (pages)                = 2

Number of containers                 = 1

Thanks & Regards

MANIKANTA

[former_member182657 · Accepted solution]

Hi Manikanta,

Suggest you to check with SAP Note  365314 - DB2 UDB for AIX: User Limits for db2<sid>/<sid>adm

&  1099936 - DB6: SQL0670N The row length of a table exceeds 4005 bytes

Additionally do check for any space quotas on your system with a complete restart of system.

Regards,