about dump : DBIF_RSQL_SQL_ERROR

[ki-uk_lee]

Hi Expert,

I faced the SQL error : DBIF_RSQL_SQL_ERROR.

Short text : SQL error in the database when accessing a table.

Database error text........: "SQL0968C The file system is full. SQLSTATE=57011"

Internal call code.........: "[RSQL/FTCH/BSIS ]"

The cause of the problem is OS file system.

The file system is below.

/db2/ECP/saptemp1

I know that this file system is a temp space.

When use this space except reorg?

Thanks.

Lee

[former_member189725 · Accepted solution]

Either extend the filesystem /db2/ECP/saptemp1 or add paths to the TEMP tablespace in other filesystems. Probably you are using a NW 640 based system. These objects are created during operations like sorts, joins etc are only required during the runtime of the application.

[former_member188883]

Hi,

/db2/ECP/saptemp1 may not be used during reorg. It holds some temporary log files for database operations and does not consume more space.

Could you check what are the contents of this file system. May be some unwanted files are dump into it hence making the space full.

Hope this is useful.

Regards,

Deepak Kori

[former_member182505]

Hi

The files of the SAP Database are stored in the directories /db2/<sapsid>/sapdata1/[NODE0000] ...

/db2/<sapsid>/sapdataN/[NODE0000], and /db2/<sapsid>/sapdatat or

/db2/<sapsid>/saptemp<x>/[NODE0000].

Can you please send the filesystem details.

Check the link..

Thanks

Sadiq

Edited by: sadiq iqbal on Dec 15, 2011 11:20 AM