dbload question

Using Informix Online 7.30.UC3. Doing a dbexport/dbimport to create a new instance on the same machine on new disks which will then become live. A table on the old instance is in one dbspace. Here is some edited output from 'oncheck -pT': Current serial value 12097203 First extent size 435120 Next extent size 43512 Number of pages allocated 773995 Number of pages used 755554 Number of data pages 353204 Type Pages ---------------- ---------- Free 18441 Bit-Map 188 Index 402162 Data (Home) 353204 ---------- Total Pages 773995 The new instance has 3 dbspaces with the table fragmented by round- robin. When it was loaded there was the following result (again edited oncheck -pT output): Table fragment in DBspace dbspace_1 Current serial value 12088627 First extent size 837923 Next extent size 83792 Number of pages allocated 499947 Number of pages used 117682 Number of data pages 117652 Number of rows 4000155 Type Pages ---------------- ---------- Free 382265 Bit-Map 30 Index 0 Data (Home) 117652 ---------- Total Pages 499947 In other words one extent has been created through the whole of the extent for each of the three dbspaces! Does anyone have any light to shed on this? Known bug? 'feature'? PS we are going to specify the initial & next extent sizes to attempt to resolve the problem. -- Surfer!

Look at the EXTENT SIZE parameters in the original dbexport generated schema file. Likely that is the cause. Art S. Kagel "Surfer!" wrote: > > Using Informix Online 7.30.UC3. > > Doing a dbexport/dbimport to create a new instance on the same machine > on new disks which will then become live. > > A table on the old instance is in one dbspace. Here is some edited > output from 'oncheck -pT': > > Current serial value 12097203 > First extent size 435120 > Next extent size 43512 > Number of pages allocated 773995 > Number of pages used 755554 > Number of data pages 353204 > > Type Pages > ---------------- ---------- > Free 18441 > Bit-Map 188 > Index 402162 > Data (Home) 353204 > ---------- > Total Pages 773995 > > The new instance has 3 dbspaces with the table fragmented by round- > robin. When it was loaded there was the following result (again edited > oncheck -pT output):> > Table fragment in DBspace dbspace_1 > > Current serial value 12088627 > First extent size 837923 > Next extent size 83792 > Number of pages allocated 499947 > Number of pages used 117682 > Number of data pages 117652 > Number of rows 4000155 > > Type Pages > ---------------- ---------- > Free 382265 > Bit-Map 30 > Index 0 > Data (Home) 117652 > ---------- > Total Pages 499947 > > In other words one extent has been created through the whole of the > extent for each of the three dbspaces! > > Does anyone have any light to shed on this? > > Known bug? > > 'feature'? > > PS we are going to specify the initial & next extent sizes to attempt to > resolve the problem. > > -- > Surfer!

We didn't use the -ss flags and no extent sizes were specified - this approach served us well in the original move to Online. In article <39BFD98F.9B42EA86@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Look at the EXTENT SIZE parameters in the original dbexport generated >schema file. Likely that is the cause. > >Art S. Kagel > >"Surfer!" wrote: >> >> Using Informix Online 7.30.UC3. >> >> Doing a dbexport/dbimport to create a new instance on the same machine >> on new disks which will then become live. >> >> A table on the old instance is in one dbspace. Here is some edited >> output from 'oncheck -pT': >> >> Current serial value 12097203 >> First extent size 435120 >> Next extent size 43512 >> Number of pages allocated 773995 >> Number of pages used 755554 >> Number of data pages 353204 >> >> Type Pages >> ---------------- ---------- >> Free 18441 >> Bit-Map 188 >> Index 402162 >> Data (Home) 353204 >> ---------- >> Total Pages 773995 >> >> The new instance has 3 dbspaces with the table fragmented by round- >> robin. When it was loaded there was the following result (again edited >> oncheck -pT output):>> >> Table fragment in DBspace dbspace_1 >> >> Current serial value 12088627 >> First extent size 837923 >> Next extent size 83792 >> Number of pages allocated 499947 >> Number of pages used 117682 >> Number of data pages 117652 >> Number of rows 4000155 >> >> Type Pages >> ---------------- ---------- >> Free 382265 >> Bit-Map 30 >> Index 0 >> Data (Home) 117652 >> ---------- >> Total Pages 499947 >> >> In other words one extent has been created through the whole of the >> extent for each of the three dbspaces! >> >> Does anyone have any light to shed on this? >> >> Known bug? >> >> 'feature'? >> >> PS we are going to specify the initial & next extent sizes to attempt to >> resolve the problem. >> >> -- >> Surfer! -- Surfer!