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

Question

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?

See dba.stackexchange.com/questions/54245/…
– mustaccio
Commented Jan 16, 2017 at 15:49 — mustaccio, Commented Jan 16, 2017 at 15:49

MichaelTiefenbacher · Accepted Answer · 2017-01-15 21:07:54Z

1

I guess you tried to run it in an editor window. YOu have to switch to

DB2 server Command Line Processor

in the Configuration tab of the editor. Do not forget to explicitly connect to your database

connect to sample ;
reorg table suppliers;

Alternatively you could switch to "Administer Databases" and run the reorg from the contect menu of a table:

answered Jan 15, 2017 at 21:07

4983 silver badges6 bronze badges

1

Alternatively (from editor window): call sysproc.admin_cmd('reorg table suppliers')
– Ian Bjorhovde
Commented Jan 16, 2017 at 15:33

Add a comment |

mustaccio · Accepted Answer · 2019-04-26 16:52:03Z

1

 CALL SYSPROC.ADMIN_CMD( 'REORG TABLE SCHEMA.TABLENAME' )

mustaccio

26.6k24 gold badges58 silver badges74 bronze badges

answered Apr 25, 2019 at 14:31

Jhonnatan Eduardo

1112 bronze badges

Jhonnatan, we prefer code snippets highlighted with appropriate tags, please don't roll back the edit.
– mustaccio
Commented Apr 26, 2019 at 16:53

Add a comment |

2 Answers 2