Results 1 to 11 of 11
  1. #1
    Join Date
    Jul 2011
    Posts
    41

    Thumbs up Unanswered: need urgent help regarding the alteration on a SMS table space userspace1

    environment details : db2 9.7.4 on linux OS

    i need an urgent help regarding the alteration of the tablespace *userspace1*
    the mount in which the user space is present is full and i would want to add an other container to it which is on a different mount point and which has morespace.
    but i am unable to do the same

    i tried to user the command
    alter tablespace userspace1
    add(file,'newcontainername',2000);

    but this command works for the dms tablespaces but not on this sms.

    plz help..!!!
    Last edited by divya.s; 02-01-12 at 05:44.

  2. #2
    Join Date
    Jan 2012
    Posts
    20
    im not 100% sure about mi answer but i think that you cannot add containers to a SMS tablespace, it has to be a DMS tablespace.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    not possible
    you have to create a new ts on a new location and move some tables to this ts
    in non-dev/test environment it is always better to use dms also for maintenance reasons
    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

  4. #4
    Join Date
    Jul 2011
    Posts
    41
    so what would be the other option i could do immediately to the get application running,without dropping and recreating the table??

  5. #5
    Join Date
    Jul 2011
    Posts
    41
    moving the tables means droping and recreating them right??

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    you could copy the table with load cursor to a new table and finally rename the tables
    but be carefull that in the mean time no rows have been added/changed/..
    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

  7. #7
    Join Date
    Jan 2012
    Posts
    20
    you could try to reorg some tables using a tempspace to free some space lowing the HWM.

  8. #8
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by divya.s View Post
    environment details : db2 9.7.4 on linux OS
    You can use the new "admin_move_table" IBM DB2 9.7 for Linux, UNIX and Windows Information Center to move your tables to another tablespace on-the-fly.
    Maybe you must drop your FK contraints first and rebuild them aferwards.
    Quote Originally Posted by Revu View Post
    you could try to reorg some tables using a tempspace to free some space lowing the HWM.
    Does that work on SMS tablespaces?????

  9. #9
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Revu View Post
    you could try to reorg some tables using a tempspace to free some space lowing the HWM.
    High water mark in an SMS?

  10. #10
    Join Date
    Jan 2012
    Posts
    20
    i just want to explain that he could free some space in the tbs.

  11. #11
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Copy the SMS container to the new location and use db2relocatedb

    Cannot be done online, though

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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