Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2016
    Posts
    3

    Unanswered: creating partition tables consumes more space.

    Hi All,

    I am running db2look output sql file which I took from prod in test server.Smaller tables are getting created faster in no time, however partition tables taking too much time and consuming too much disk space.Lets say one single partition table is taking 20 mins to create and consumes disk space between 300 to 500 MB.As this is a test server, disk space is limited.500 MB just for table ddl is unbearable.Is there any way for creating tables without consuming this much disk space?Table creation DDL doesn't have any parameters related to extend allocation.Please find the attached
    sample DDL.

    Is there anything similar to deffered segment creation like in Oracle in DB2?

    DB2 version is DB2 v9.7.0.3 Fix Pack "3a".

    Regards,
    Aswin
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    If you do not need all those partitions in the test environment then do not create them there, or only create the ranges that you actually need.
    DB2 v9.7 on midrange does not have deferred partition creation.

Tags for this Thread

Posting Permissions

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