9.5 LARGE RIDs

wehrle · #1 (**permalink**) 11-12-08, 10:07

I just migrated a database from 8.2 to 9.5.
I will be converting the tablespaces to data type "Large."
Can someone confirm for me that a reorg of an existing table and it's index(s) will effectively convert the table and it's index(s) to use Larges RIDs?

Thanks.

ARWinner · #2 (**permalink**) 11-12-08, 11:50

I believe that you have to use the ALTER TABLESPACE command.

Andy

wehrle · #3 (**permalink**) 11-12-08, 11:56

Yes, ALTER TABLESPACE . . . will ALLOW the tablespace to have large tables/indeces, but the question is what makes the existing tables/indeces HAVE large rids/slots? My understanding is that a table reorg will do it.

madhu_kaza · #4 (**permalink**) 11-12-08, 13:46

Yes, REORG of existing table and indexes will do.

For more info you can refer to this link
http://it.toolbox.com/blogs/db2luw/c...in-db2-9-13219

Internet Services

Web Development

Digital Marketing

Consumer Tech