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]

In addition check with siimilar thread

[Former Member]

Hi Gaurav

      We found that our PSAPTEMP16 tablespace which is SYSTEM MANAGED size was full. we saw it on db2diag.log file

So can we increase PSAPTEMP16 tablespace. If yes please tell me the command. The log was

MESSAGE : ADM6017E  The table space "PSAPTEMP16" (ID "3") is full. Detected on

          container "/db2/PR3/saptemp1/NODE0000/temp16/PSAPTEMP16.container000"

          (ID "0").  The underlying file system is full or the maximum allowed

          space usage for the file system has been reached. It is also possible

          that there are user limits in place with respect to maximum file size

          and these limits have been reached.

Thanks & Regards

MANIKANTA

[former_member182657]

Hi Manikanta,

Could you check with SCN thread

Regards,

[Former Member]

Hello Manikanta,

While performing export, the system copy guide has a standard suggestion about size of your temporary tablespace, which is normally a percentage of size of your DB.

Nobody can tell you how much you should maintain, however you can monitor its usage during export using DB tools to see that its contents grow and shrink depending on the how many parallel processes you start during export and how big packages are.

Explore this area first before restarting your export by simply fixing this issue.

Good luck.

Regards,

Siddhesh