Skip to Content
0
Former Member
Jul 15, 2009 at 07:30 AM

SQL error in the database when accessing a table.

515 Views

Hi Experts,

Our development system ecc6 is running on DB2 and Linux. Since yesterday when we log in, throws a dump which shows a message SQL error in the database when accessing a table. We are not able to access any database table.

In sm21 it shows - SQL0968C The file system is full. SQLSTATE=57011 row=1

Also R3trans -d throws return code 12. 
 ETW000  [dev trc     ,00000]  *** ERROR in ExecuteDirect[dbdb6.c, 5955] CON = 0 (BEGIN)
4 ETW000                                                                              37  0.699513
4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLExecDirect ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0968C  The file system is full.  SQLSTATE=57
4 ETW000                                                                              33  0.699546
4 ETW000  [dev trc     ,00000]  &+     011
4 ETW000                                                                              19  0.699565
4 ETW000  [dev trc     ,00000]  &+
4 ETW000                                                                              18  0.699583
4 ETW000  [dev trc     ,00000]  &+     DROP VIEW SAPTOOLS.DB2_WORKLOAD_CHECK
4 ETW000                                                                              18  0.699601
4 ETW000  [dev trc     ,00000]  &+
4 ETW000                                                                              27  0.699628
4 ETW000  [dev trc     ,00000]  &+
4 ETW000                                                                              18  0.699646
4 ETW000  [dev trc     ,00000]  *** ERROR in ExecuteDirect[dbdb6.c, 5955] (END)       12  0.699658
4 ETW000  [dev trc     ,00000]  Could not check DB2 registry settings.               419  0.700077
4 ETW000  [dev trc     ,00000]  disconnected from 'R3D', con_hdl=0, appl_hdl=505
4 ETW000                                                                            8139  0.708216
2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'R3D'"

----


But we are having space in the file system.

Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda3             16500568   4846944  10815436  31% /
udev                  13631488   1369336  12262152  11% /dev
/dev/sda2              2071416   1367352    598840  70% /tmp
/dev/sdb5            104852988  71774964  33078024  69% /SAPDVD_INSTA
/dev/sdc6             47189400  22419320  24770080  48% /db2/R3D/sapdata1
/dev/sdc7             47189400  22419320  24770080  48% /db2/R3D/sapdata2
/dev/sdc8             47189400  22419320  24770080  48% /db2/R3D/sapdata3
/dev/sdc9             47189400  22419320  24770080  48% /db2/R3D/sapdata4
/dev/sdc10            41944376  31007152  10937224  74% /db2/R3D/db2arch
/dev/sdc11              514028    444036     69992  87% /db2/R3D/db2dump
/dev/sdc5              2104376    597384   1506992  29% /db2/db2r3d
/dev/sdd11             2104376   2076620     27756  99% /db2/R3D/log_dir
/dev/sdd12             2056188   2011024     45164  98% /db2/R3D/log_dir2
/dev/sdd7              5245016    943584   4301432  18% /sapmnt/R3D
/dev/sdd8              2104376    845364   1259012  41% /sapmnt/TRD
/dev/sdd5             12586424   6229192   6357232  50% /usr/sap/R3D
/dev/sdd9              2104376    250028   1854348  12% /usr/sap/SMD
/dev/sdd10            10490040    844596   9645444   9% /usr/sap/TRD
/dev/sdd6             12586488   7183488   5403000  58% /usr/sap/trans

-


Kindly suggest how to solve.

Thanks and Regards,

Amit Jana.