Re: Dbimport problems with IDS 10 from IDS731

MICHEL TAGAMI íàïèñà: > Dear all, > > I had to migrate my system according to the following scenario: > > Source: Machine 1 with AIX 5.2 and IDS7.31 > Destination: Machine 2 with AIX 5.3 and IDS10.0 > > Workaround: > 1) I could do some tests with dbexport and dbimport like that: > Dbexport from the Machine 1 and > Dbimport to the Machine 2, BUT I could see that my dbspaces were increasing > until about 33% more than the original size. > > 2) In another way, following the Migration documentation from IBM: > Copy of the datafiles (I don't have a raw device) from Source to Destination. > After that I just started the new IDS with "oninit -v", and them it > automatically converted the old database to the new one without increase my > dbspaces, BUT after all this conversion I have decided to dbexport from this > new scenario, drop the database and dbimport, AND the result was similar like > the first scenario, it means that my dbspaces increased about 33% more than > the original size. > > Question: > What happen? I just can't have plus 33% due to conversion issues! > Does anybody could have the same situation? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > Hi If you use dbexport without "-ss" switch then dbimport will automaticly increase extent size and last extens are usually free. But for informix dbspace is used. Dimtar Bachvarov