Unanswered: creating partition tables consumes more space.
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
Is there anything similar to deffered segment creation like in Oracle in DB2?
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.