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

    Unanswered: Changing extent size of database

    I am working with db2 v7.2 aix 5.2

    I need to change the extent size of production database,
    is it true I have no chose except ,
    1- create new database with proper extent size
    2- Using db2look and db2move for exporting and importing data to new database. is it true?
    If the size of my database was 500 gig what should I do , it will take long 3 days to export/import data.

    please advise

  2. #2
    Join Date
    May 2003
    Since V7.2 is no longer supported by IBM, sounds like a good time to upgrade to Version 8.

    I assume you mean you want to change the extent size of one or more tablespaces. The database may have a defaut extent size for new tablespaces, but you can override that when you create each tablespace.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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