Skip to Content
author's profile photo Former Member
Former Member

DBIF_DSQL2_SQL_ERROR

while trying to execute some tranctions a short dump is getting created with

Error:DBIF_DSQL2_SQL_ERROR

CX_SY_NATIVE_SQL_ERROR

SAP Platform:Ecc6.0

Datebase: db2

OS: windows2003 Enterprise

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2008 at 11:08 AM

    Hi,

    To migrate roll management to auto, you're required to perform several steps. The PSAPUNDO tablespace has to created, PSAPROLL has to be deleted and several parameters has to be set in Oracle parameter file

    initSID.ora.

    The whole procedure is described in note 600141.

    Refer to link below:

    http://sap.ittoolbox.com/groups/technical-functional/sap-basis/errordbif_dsql2_sql_error-exceptioncx_sy_native_sql_error-977498

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 10:18 AM

    Hi,

    Please do a serach with same dump in forum, there are log of threads regarding the same.

    Thanks,

    Debasis.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 11:43 AM

    See all the supportive services (SQL/Distribution service cordinator/etc) are stared in automatic mode

    in ...

    > services.msc

    also see that in start up opetion (start>programmes>startup..?) service manager console for SQl is there if yes then open it and see all the services are started and in start service at system STARTUP is checked...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 11:11 PM

    Hi,

    This is a generic error message that is generated and search for this error will not do much good. Most common cause of this error message is due to something being full. I would check my memory first in st02 then check the db logs, tablespaces or disk space at the OS level.

    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.