Sample Header Ad - 728x90

REORG command does not work in IBM Data studio but same works in Command Line Processor

0 votes
2 answers
4522 views
I'm using the latest version of IBM Data Studio 4.1.2.0 I tried to reorg a table using IBM Data Studio after some alterations on the table with this command. reorg table MYTABLE; This command shows an error >REFRESH was expected instead of reorg But even after using the REFRESH command, the table doesn't come out of the "reorg pending" state. The same command when I tried it via the DB2 Command Line Processor worked perfectly fine. Any suggestions on how to to enable the REORG command in Data Studio or is it not supported at all?
Asked by Aniruddha Kalburgi (115 rep)
Jan 15, 2017, 09:13 AM
Last activity: Apr 26, 2019, 04:52 PM