DB2 calling REORG command from JDBC

May 15, 2012 in Database

Sometimes, you need to run the DB2 REORG command from the JDBC code. You will need to run the REORG command usually after executing the ALTER TABLE DROP COLUMN statement. In order to execute the REORG command from JDBC, you can do this as follows:

Call Sysproc.admin_cmd ('reorg Table [YOUR_TABLE_NAME]');

I hope that this tip can be useful to you.

Leave a reply

Your email address will not be published. Required fields are marked *


Skip to toolbar