Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2010
    Location
    USA
    Posts
    10

    Unanswered: how can drop the tablespace

    There is a error while drop the tablespace
    some tables on one tablespace , tablespace container was deleted ,its status is "off line"
    i drop the tabalespace but occured the error code
    SQL0282N Table space "TEST_DAT_TS" cannot be dropped because at least one of
    the tables in it, "DB2INST2.TEST", has one or more of its parts in another
    table space. SQLSTATE=55024

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Some tables have indexes and/or LOBs stored in another tablespace. So, you have to drop all related tablespaces using a single "drop tablespaces" statement.
    Example: db2 "drop tablespaces (x,y,z)"

Posting Permissions

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