I did a 'ALTER TABLE ALTER COLUMN on table XXX. I changed one column from CHAR(30) to VARCHAR(2000) and added one CHAR(1) column.
It was successful. But after the ALTER I got this error when access table XXX in a Java JDBC

DB2 SQL error: SQLCODE: -668, SQLSTATE: 57016, SQLERRMC: 7

Have tried everything found googling but could not get rid of the error.

The SQL used in Java is
SELECT T01."SEQNO", T01."VALUE3", "DELIMIT" FROM "SCHEMA.XXX" T01 WHERE T01."SEQNO"=1 FOR UPDATE OF "VALUE3", "DELIMIT"


Any ideas?

Thanks!

User response for reason-code:7

Reorganize the table using the REORG TABLE
command (note that INPLACE REORG TABLE
is not allowed for a table that is in the reorg
pending state).

Next time, try reading the official DB2 documentation. You can use the online InfoCenter (this link is for version 9.7) or download the PDF manual for DB2 Messages Vol 2.
SQL0668N

Thanks!
REORG works (IBM - Summarization and Pruning Agent failure attempting to insert a null value into the ITCAM for SOA summarization tables.).
DB2/NT is a little special. I did the same ALTER on DB2/AS400, Oracle, MS SQL server, MySQL prior to DB2/NT and they all went OK without special treatment.

I have the same problem after I've dropped a column (if I'd had known this)and I can't run the reorg command, I get this error message:
DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=TABLE;REORG ;JOIN <joined_table>, DRIVER=3.53.70

if I run a select on table I get other message:
DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;DB2UT015.EXP_RECORD

Is it already running the reorg command? any ideas how can I verify it?


thanks^1000...

SQLCODE -104 is a syntax error. What is the reorg command you are trying to do, and how are you trying to do it?

Andy

I've tried many forms, like
reorg table EXP_RECORD;
reorg table db2u7015.EXP_RECORD;

and I am using DbVisualizer, can be that the problem? looks like the editor doesn't recognize command reorg, because it doesn't highlight the word as it does with works like table or select...

That is what I suspected. REORG is not SQL, it is a DB2 command and cannot be executed as if it was SQL. You can either use the CLP to use REORG or you can use: IBM DB2 9.5 Information Center for Linux, UNIX, and Windows if you must use SQL.

Andy

and that worked just perfect! I really appreciate your advise!

I have a big amount of SQLs which have to be executed in a sequence. Your solution helped me in some cases, after the tables have been altered. BUT!!!! thera re a lot of situaitions, where the REORG statement doesn't help. I am trying to make the insert into tha table, get the 668 ErrorCode and the reorg doesn't make it work! Do you have guys any ideas why and how to solve it!

How can I check in which "pending" state the table currently is. Do I probably make some kind of additionial commit or wait before the next statement....

Thanks a lot in advance for your help!!!!!

You can get 668 for several reasons. You need to post the entire error you are getting.

Andy