I've had some problems with my database monitoring tool, Ignite. It fails to start because it gets an error for certain queries that it tries to do, this is an example:
SELECT CAST(stmt_text AS BLOB) igniteex, num_executions, num_compilations, rows_read, rows_written, stmt_sorts
FROM table(snapshot_dyn_sql('[db_name]',-2)) AS sntable
This query (and the others, which are much longer) works just fine (and are very fast) when I execute it from my database analyzing tool (Aqua Data Studio). Ignite however reports an SQLException with SQLCODE values that are not listed (for example here).
The database is IBM DB2 9.7. The SQLCODE values returned are -930, -954, -443, which seems to be not listed anywhere. Does anyone know what these SQLCODE values mean?
The correct documentation for this is here.
SQLCODE -443 means a DB2 routine returns an error.
SQLCODE -930 means that there is not enough storage available. This storage is not in terms of disk space or total memory, but seems to be concerned with allocated memory for the database manager.
SQLCODE -954 means basically the same as -930; but it says all memory is used rather than "not enough for this task".
Anyway, restarting the db2 server did remove these errors.