myschema and extents
Posted in 2009
Have to migrate an IDS 9.30 from Debian over to an 11.50 on Suse. Lots of tables have more than 20 extents so i thought it would be a good idea to reorganize them during the migration. Played with Art-s myschema hoping it would issue CREATE TABLE statements with appropriate extent sizes but it always issues the current extent size which is of course way to small for a table with currently more than 100 extents for example. Played wit "-m", "-a" and different other options, no luck. I can see the current used pages in the comment but the extent size in the create statements never changes. Do i miss something? Or is it working as designed and i have to walk the script modifying all needed places by hand using the information in the comments? Is there another tool which i could use that would generate schema scripts with recalculated extent sizes? Regards Dirk