Results 1 to 4 of 4

Thread: reorg problem

  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: reorg problem

    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

  2. #2
    Join Date
    Oct 2004
    Location
    Norway
    Posts
    53
    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

  3. #3
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    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.
    David Quigley

  4. #4
    Join Date
    Oct 2004
    Location
    Norway
    Posts
    53
    Ahh, good think you reminded me quigleyd

    Terminate all utilities as well ...

    ---

    /pF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •