C
ChUIMonster
Guest
When dealing with a vendor supplied system it is best to leave their storage areas in place. For the most part you can create new areas and move stuff into the new areas mostly without causing problems. Incremental df files are probably not going to have AREA info in them unless the vendor is creating a new table, index or LOB. In those cases they are /probably/ going to try to create it in an area that they expect to exist. Which is why you keep their old areas hanging around (I like to make them variable length so that i don't waste disk space on empty areas...). But you cannot assume that -- sometimes they forget and dump new stuff in the schema area. So your best bet is to grep the df for AREA upfront and tweak it before loading. Or you can scan the areas after the fact and look for things that ended up where you don't want them.
Continue reading...
Continue reading...