Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2015
    Posts
    36
    Provided Answers: 2

    Answered: resize temporary tbs

    Hi,

    On db2 luw 9.7 i want to resize the temporary tbs but it is unsuccessful, i tried to find some info in google but the result in unclear and I couldn't find a solution.
    Its sms tablespace.

    some info:

    Code:
    -bash-4.2$ db2 list tablespace containers for 1 show detail
    
                Tablespace Containers for Tablespace 1
    
     Container ID                         = 0
     Name                                 = /db2/data/db2inst1/NODE0000/EHDEV153/T0000001/C0000000.TMP
     Type                                 = Path
     Total pages                          = 3228
     Useable pages                        = 3228
     Accessible                           = Yes
    
    
    -bash-4.2$ db2 "alter tablespace TEMPSPACE1 resize(all 4000)"
    DB21034E  The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.  During SQL processing it returned:
    SQL0281N  Table space "TEMPSPACE1" cannot be altered with additional
    containers because it is a system managed table space.  SQLSTATE=42921
    
    -bash-4.2$ db2 "alter tablespace TEMPSPACE1 extend(all 4000)"
    DB21034E  The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.  During SQL processing it returned:
    SQL0281N  Table space "TEMPSPACE1" cannot be altered with additional
    containers because it is a system managed table space.  SQLSTATE=42921
    
    -bash-4.2$ db2 "alter tablespace TEMPSPACE1 add (FILE '/db2/data/db2inst1/NODE0000/EHDEV153/T0000001/C0000001.TMP' 400)"
    DB21034E  The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.  During SQL processing it returned:
    SQL0104N  An unexpected token "FILE" was found following "(".  Expected tokens
    may include:  "<sms_container_path>".  SQLSTATE=42601

  2. Best Answer
    Posted by mark.b

    "Hi,

    You can't resize the SMS tablespaces.
    Drop it and recreate if needed."


  3. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    You can't resize the SMS tablespaces.
    Drop it and recreate if needed.
    Regards,
    Mark.

Posting Permissions

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