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.