Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003

    Unanswered: what happens if we do not specify index tablespace ?

    I am using DB2 UDB on Aix.
    Say, We create a table by just specifying the tablespace it is suppose to be created in. And EXCLUDE the Index Tablespace information. In this case DB2 will store table data in the Tablespace specified (in create statement) My Question is where will DB2 store the Index Data.


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    I am fairly certain that it stores the indexes in the same tablespace.


Posting Permissions

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