Skip to Content

about dump : DBIF_RSQL_SQL_ERROR

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 15, 2011 at 05:55 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2011 at 05:46 AM

    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..

    Reorganize tables in DB2

    Thanks

    Sadiq

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2011 at 05:47 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.