I reorged a table and one of the temp tablespace that was being used seems to be stuck in the reorg state. I tried to use the alter tablespace command to switch it to online, but it did not work. Does anyone have any suggestions?

Thanks

In Catalog Manager on our MainFrame, I simply write: start access(force)

You also have the DB2 Control Center where you may change the states of your tablespace.

---

/pF

If your running on UNIX, we have seen tablespace get stuck in different states, look up DB2 APAR IY48902. Run it against the db, and see if it shows that tablespase with a problem.

You must have nothing connected to the database, and the utility must run in exclusive mode.

Ahh, good think you reminded me quigleyd

Terminate all utilities as well ...

---

/pF