Results 1 to 4 of 4

Thread: 9.5 LARGE RIDs

  1. #1
    Join Date
    Jul 2005
    Posts
    103

    Unanswered: 9.5 LARGE RIDs

    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I believe that you have to use the ALTER TABLESPACE command.

    Andy

  3. #3
    Join Date
    Jul 2005
    Posts
    103
    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.

  4. #4
    Join Date
    Apr 2008
    Posts
    39
    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

Posting Permissions

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