CODEWITHSUNDEEP
sqldb2ibm-cloudalter
Muthu RL
Muthu RL

Reputation: 11

Bluemix SQL Service - How to REORG Table

I am using an SQL Service in Bluemix. All was fine till I had to alter a Table. After altering the table, I have to run the REORG command which I am not able to do. How to run the REORG command for an SQL service in Bluemix. My assumption is that it can be only done by an admin in Bluemix. If so then it is a major drawback since I cant see any support forum for Bluemix. Any guidance will be helpful. Thanks.

Upvotes: 1

Views: 243

Answers (2)

Crescenzo Migliaccio
Crescenzo Migliaccio

Reputation: 1249

run the reorg from the console using the admin stored procedure:

CALL SYSPROC.ADMIN_CMD ('REORG TABLE ')

Upvotes: 2

Umberto Manganiello
Umberto Manganiello

Reputation: 3233

I guess you're referring to a SQL Database service instance on Bluemix. I suggest you to open a support request using one of the following methods:

  • Use the Support Widget. It is available from the user avatar in the    upper right corner of the main Bluemix UI.  After opening the support    widget panel, select Get Help > Get In Touch , select the type of assistance you need, and then fill out the support form.
  • Use the Support Site 'Get Help' form. This form is available on a separate site that is made available for ticket submission when you cannot log into Bluemix and access the Support Widget. Go to http://ibm.biz/bluemixsupport and fill in the support request form.

Upvotes: 0

Related Questions