Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2008
    Posts
    136

    Unanswered: to add container in DMS tablespace command.....is this right????

    alter tablespace CEI_TS_8K add (FILE '/san/db/carsdb/carsxmlstore/cei_ts_8k_path/cei_ts_1_8k' 1GB)"


    Above command is right?????

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have you considered reading the manual and the examples therein? http://publib.boulder.ibm.com/infoce.../r0000890.html
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Mar 2008
    Posts
    136
    yes i have read....there is no partition database...
    my current tablespace container is cei_ts_8k on path '/san/db/carsdb/carsxmlstore/cei_ts_8k_path/

    now i want to add new container on same path.....
    so above command is right???

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What do you mean with "there is no partition database"?

    Containers are identified by their absolute filename. As long as this is unique, you can have multiple containers in the same directory.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Pawan Kumar
    my current tablespace container is cei_ts_8k on path '/san/db/carsdb/carsxmlstore/cei_ts_8k_path/
    Seeing this, I'd think you've got yourself an SMS tablespace, not DMS.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Mar 2008
    Posts
    136
    I have done successfully with that command ....
    thanks for yr reply...

Posting Permissions

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