Customer Defined Data Classes on Cluster Tables?
I noticed that there is no option within db13 to change the storage option to a customer defined data class, for cluster tables. I am sure this is by design but wanted to check to see if anyone has had any luck defining a data class on a cluster table.
We could move a cluster table to a DB2 tablespace and define the new Data Class through dbacockpit/db02, but there is no option to change the data class definition in the data dictionary (se13) to use the new Data Class for the table itself.
Mainly what we are aiming for is to be able to move 2 tables into their own tablespaces on the target server, during a migration. Sapinst is looking at the Data Classes to create DDLDB6.XML, which defines the tablespace assignments to the target server, so perhaps there is a preferred method of making this change, if it does exist.
Thanks for any insights,
kiran kumar vejendla replied
Definately there should be a way to create a dataclass. In SE13 you could able to assign the table to data class if the tabart is already created. you can directly create a tabart by creating entry in table tadb6, if it is db6 database(naming convention for table is TA<DB TYPE>). if you already exported and you want to import certain tables in different table spaces still you can do it with minimal customainzation of your XML files. add entry for your new table spaces / data classes in DDLDB6.XML and change the data class for the tables the corresponding STR file. (Identiy STR file based on original dataclass, no need to create seperate str file).