database error -99999

[Former Member]

Hello,

We are getting database error-99999 in SM21 and transaction db02/st04.

We have db2 version 8.2.6 ob AIX 5.3

Kindly, suggest.

[Frank-Martin]

Hi,

SQL error -99999 typically indicates some kind of CLI error. To find out what went wrong ,you need to retrieve at least the error message text from the ABAP short dump or from the developer trace file of the corresponding work process.

The developer trace file will also contain other helpful information like the statement text of the SQL statement that went wrong and the input and output parameters during statement execution.

Regards

Frank