Our DB/2 application does some migration steps when a new version of the code is installed. One of these steps requires dropping a column from a table (which in DB/2 9 can be done with an ALTER TABLE DROP COLUMN statement).

But the resulting table is unusable until "REORG TABLE x" is executed. I can do this from the DB/2 command line, but it fails when run from from JDBC:

com.ibm.db2.jcc.c.SqlException: An unexpected token "TABLE" was found following "REORG ". Expected tokens may include: "JOIN <joined_table>".

This implies to me that this form of REORG cannot be done from JDBC... which really kills our auto-migration concept. Is there any way to do this strictly from JDBC? We cannot have manual admin steps in our application startup and migration sequence...

Thanks for any ideas!

PS. DB/2 version details:

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09010" with
level identifier "02010107".
Informational tokens are "DB2 v9.1.0.356", "s060629", "NT32", and Fix Pack "0".

Call Sysproc.admin_cmd ('reorg Table Xxxxxxxxxx');

BTW, it is DB2, not DB/2.

Use the ADMIN_CMD stored procedure:

DB2 Database for Linux, UNIX, and Windows

Andy

That is very old code. You should apply the latest fixpack, which I believe is FP7. If you are using DB2 Express-C then you cannot apply fixpacks to that version.