Results 1 to 3 of 3

Thread: drop tablespace

  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    Unanswered: drop tablespace

    db2 ese 9.5 fp 8 on P/linux
    I have restored a part of a db with rebuild command for testing
    but in the log there have been some statements accessing other tablespaces and these have also been defined in catalog but are in restore pending state
    I tried to drop these, but SQL0282N is presented
    some tables are present in these tablespaces, but can not be dropped, because of SQL0290N
    the problem is that a backup started by procedure is giving errors
    is there any possibility to drop these tables/tablespaces, because they are not needed.
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    After a partial restore with rebuild option, excluded tablespaces should be in restore pending state (for db using archival logging). You should be able to drop tablespaces in this state. For sql0282n, some table parts (ie, data/index/lobs) are defined in separate tablespaces. You can drop these related tablespaces using one command (ie. drop tablespaces <data>, <index>, <lob>).

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    yes
    db2 "drop tablespace TS_L_JBPM40_D_4K, TS_R_JBPM40_i_4K, TS_R_JBPM40_d_4K"
    DB20000I The SQL command completed successfully.
    if dropping them together all is ok..
    thanks for the help/update
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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