oracle984,导致SQLCODE: -984的原因和解决方法?

$ db2 ? sql0984n

SQL0984C COMMIT or ROLLBACK was not successful.  Subsequent SQL

statements cannot be processed.

Explanation:  A commit or rollback operation could not be

processed successfully because of a system error.  The

application program is not permitted to issue additional SQL

statements.  For example, a recovery routine associated with the

application program may not issue additional SQL statements.  The

database is marked as needing recovery and all applications using

the database are prevented from accessing the database.

The statement cannot be processed.

User Response:  Record the message number (SQLCODE) and all SQLCA

error information, if possible.  Terminate all applications using

the database.  Restart the database.  If installing the sample

database, drop it and install the sample database again.

If recovery is not possible, restore the database from a backup

copy.

If trace was active, invoke the Independent Trace Facility at the

operating system command prompt.  Refer to the Independent Trace

Facility in the Troubleshooting Guide for information on how to

use this facility.  Contact your technical service representative

with the following information:

Information required:

o   Problem description

o   SQLCODE

o   SQLCA contents if possible

o   Trace file if possible.

Federated system users: isolate the problem to the data source

failing the request (refer to the problem determination guide to

determine which data source is failing to process the SQL

statement) and take the necessary diagnostic steps and database

recovery procedures for that data source.  The problem

determination procedures and database recovery procedures for

data sources vary, so refer to the applicable data source

manuals.

sqlcode:  -984

sqlstate:  58005

$