DB2 ERROR CODE 901 [Résolu]

[Djromé]

Salut les Kracks,


J'ai un message d'erreur (malheureusement sans le code) dont j'aimerai connaître la <<Traduction>>. Auriez-vous déjà eût ce genre de message et que peut-il bien expliquer?:

Code :

1
2
3
[ERROR] [050511-13:35:38] [http-80-Processor23]: SQL Error: -901, SQLState: 58004
 
[ERROR] [050511-13:35:38] [http-80-Processor23]: [SQL0901] SQL system error.

D'avance merci

[pdz74]

Aucune idée de ce qu'est le -901. Aurais tu plus d'infos à nous donner ? Quelle requête exécutes tu ? Dans quel contexte ? Sur quel OS ? ...
Si ça peut t'aider, ci-dessous un copier/coller de la doc DB2 ZOS V9 :

UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS
Explanation: A system error occurred that prevented successful execution of the current SQL statement.
However, the error does not prevent successful execution of further SQL statements.
The error might occur if the length of the SQL statement is less than 0, or is greater than the DB2 maximum length for a statement.
This SQLCODE might also occur when distributed commit processing encounters an error. In this case, all servers in the unit of work that support distributed two-phase commit backed out the unit of work. If a server that does not support distributed two-phase commit has updates in the unit of work, that server must be queried to determine if its updates were committed or backed out.
Finally, this error might occur during commit if post-processing cannot be completed because of an update that changes the partition of a row. Resource unavailable problems can prevent the post-processing from completing. The existence of held cursors can prevent the post-processing from completing. Commit is failed. The transaction is aborted.
System action: The statement cannot be executed. A X’04E’ abend might be requested for the application.
The application program can have a recovery routine to recover from such an abend and can retry SQL statements.
Programmer response: If an abend occurred, notify the system programmer for analysis of the abend that caused this return code.
Even if an abend occurred, an application program receiving this return code can retry and is not prohibited from executing further SQL statements.
SQLSTATE: 58004

[allweneed]

SQL0271N Index file for table with fid
″<fid>″ is either missing, or is not
valid.
Explanation: The index file for the table with
fid ″<fid>″ is required during processing. The file
is either missing, or it is not valid.
The statement cannot be processed, and the
application is still connected to the database. This
condition does not affect other statements that do
not use the index on this table.
User Response: Ensure that all users are
disconnected from the database, then issue the
RESTART DATABASE command on all nodes.
Then try the request again.
The index (or indexes) is re-created when the
database is restarted.
sqlcode: -271
sqlstate: 58004