Unknown SQLCODE values

Question

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?

May be you should reference the product documentation for error codes, instead of some random internet page. Look for SQL0930N, SQL0954N, SQL0443N respectively. — mustaccio
– mustaccio, Commented Aug 21, 2014 at 11:49
Well I was looking at this page, but since it didn't include the codes I needed and also I thought it was hard to navigate, I preferred the link I posted. Thanks for pointing me to the correct section! — Mats Rydberg
– Mats Rydberg, Commented Aug 21, 2014 at 11:55
@MatsRydberg, the page you were looking at is for DB2 for z/OS. While many things are the same between DB2 on z/OS, LUW, and IBM i. There are many differences also. Best to stick with the docs for your platform and version. — Charles
– Charles, Commented Aug 21, 2014 at 12:09
A shortcut to the info is to ask db2. From a sh you can do db2 "? SQL930" and get info about the error. — Lennart - Slava Ukraini
– Lennart - Slava Ukraini, Commented Aug 21, 2014 at 18:24
You can even get the info from Aqua: VALUES (SYSPROC.SQLERRM ('SQL930', '', '', 'en_US', 0)) — Lennart - Slava Ukraini
– Lennart - Slava Ukraini, Commented Aug 21, 2014 at 18:30

Mats Rydberg · Accepted Answer · 2014-08-22 08:10:33Z

1

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.

answered Aug 22, 2014 at 8:10

Mats Rydberg

114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mats Rydberg Over a year ago

I can't put links to the other two codes due to low reputation. They are here as -930 and -954 instead.

Collectives™ on Stack Overflow

Unknown SQLCODE values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related