inf 9.2 taking much more space than 7.23

How are you measuring the amount of space used? Peter Shankey <shankeyp@charlestoncounty.org> wrote in message news:39B1B796.301388EC@charlestoncounty.org... > Using dbexport and dbimport I copied a database fro 7.23 to 9.2 . > Version 9.2 is taking much more space than 7.23. The database does not > have any blob data, just standard data types (char date integer) > indexes, keys nothing special. The db was not fragmented. It was just > in one dbspace. The db consists of about 900 tables and is taking more > than one gig more of space. The dbexport and import lines are: > > dbexport -o /adsm/dbexp/prod ifas> and > dbimport -i /adsm/dbexp/prod -d ifasdbs ifas> > any ideas??? > thanks > Pete >

Using dbexport and dbimport I copied a database fro 7.23 to 9.2 . Version 9.2 is taking much more space than 7.23. The database does not have any blob data, just standard data types (char date integer) indexes, keys nothing special. The db was not fragmented. It was just in one dbspace. The db consists of about 900 tables and is taking more than one gig more of space. The dbexport and import lines are: dbexport -o /adsm/dbexp/prod ifasand dbimport -i /adsm/dbexp/prod -d ifasdbs ifas any ideas??? thanks Pete

I measure the amount of space being used two ways. Both ways showed the same values: onstat -d counted chunks and free spaceUsing the sql: database sysmaster;select d.name dbspace_name, (sum(c.chksize))*4096 Total_Size, (sum(c.chksize) - sum(c.nfree))*4096 Size_used, (sum(nfree))*4096 Size_of_free_space, round ((sum(nfree)) / (sum(chksize)) * 100, 0) percent_free from sysdbspaces d, syschunks c where d.dbsnum = c.dbsnum group by 1 order by 1; note the size of the db on 7.23 is about 4G and on 9.2 it is about 6G. Neil Truby wrote: > How are you measuring the amount of space used? > > Peter Shankey <shankeyp@charlestoncounty.org> wrote in message > news:39B1B796.301388EC@charlestoncounty.org... > > Using dbexport and dbimport I copied a database fro 7.23 to 9.2 . > > Version 9.2 is taking much more space than 7.23. The database does not > > have any blob data, just standard data types (char date integer) > > indexes, keys nothing special. The db was not fragmented. It was just > > in one dbspace. The db consists of about 900 tables and is taking more > > than one gig more of space. The dbexport and import lines are: > > > > dbexport -o /adsm/dbexp/prod ifas> > and > > dbimport -i /adsm/dbexp/prod -d ifasdbs ifas> > > > any ideas??? > > thanks > > Pete > >

It is quite possible you have a lot of unused pages within your tables. This would be caused if you ended up loading to much data, deleted the records, and then added the proper amount, or even just different extent sizes, causing the engine to allocate an extent, then only use a small amount of that extent. I believe oncheck -pt will tell you the number of pages used vs allocated. You might see if 9.2 and 7.23 tables have the same number of pages used, and just a different number of pages allocated for a table. Hope this helps, Will Peter Shankey wrote: > I measure the amount of space being used two ways. Both ways showed the same > values: > onstat -d counted chunks and free space> Using the sql: > > database sysmaster;> select > d.name dbspace_name, > (sum(c.chksize))*4096 Total_Size, > (sum(c.chksize) - sum(c.nfree))*4096 Size_used, > (sum(nfree))*4096 Size_of_free_space, > round ((sum(nfree)) / (sum(chksize)) * 100, 0) percent_free > from sysdbspaces d, syschunks c > where d.dbsnum = c.dbsnum > group by 1 > order by 1; > > note the size of the db on 7.23 is about 4G and on 9.2 it is about 6G. > > Neil Truby wrote: > > > How are you measuring the amount of space used? > > > > Peter Shankey <shankeyp@charlestoncounty.org> wrote in message > > news:39B1B796.301388EC@charlestoncounty.org... > > > Using dbexport and dbimport I copied a database fro 7.23 to 9.2 . > > > Version 9.2 is taking much more space than 7.23. The database does not > > > have any blob data, just standard data types (char date integer) > > > indexes, keys nothing special. The db was not fragmented. It was just > > > in one dbspace. The db consists of about 900 tables and is taking more > > > than one gig more of space. The dbexport and import lines are: > > > > > > dbexport -o /adsm/dbexp/prod ifas> > > and > > > dbimport -i /adsm/dbexp/prod -d ifasdbs ifas> > > > > > any ideas??? > > > thanks > > > Pete > > >

The other thing to look at is the value of FILLFACTOR in the 9.2x ONCONFIG file it can affect the amount of slack in each index node. Art S. Kagel Peter Shankey wrote: > > I measure the amount of space being used two ways. Both ways showed the same > values: > onstat -d counted chunks and free space> Using the sql: > > database sysmaster;> select > d.name dbspace_name, > (sum(c.chksize))*4096 Total_Size, > (sum(c.chksize) - sum(c.nfree))*4096 Size_used, > (sum(nfree))*4096 Size_of_free_space, > round ((sum(nfree)) / (sum(chksize)) * 100, 0) percent_free > from sysdbspaces d, syschunks c > where d.dbsnum = c.dbsnum > group by 1 > order by 1; > > note the size of the db on 7.23 is about 4G and on 9.2 it is about 6G. > > Neil Truby wrote: > > > How are you measuring the amount of space used? > > > > Peter Shankey <shankeyp@charlestoncounty.org> wrote in message > > news:39B1B796.301388EC@charlestoncounty.org... > > > Using dbexport and dbimport I copied a database fro 7.23 to 9.2 . > > > Version 9.2 is taking much more space than 7.23. The database does not > > > have any blob data, just standard data types (char date integer) > > > indexes, keys nothing special. The db was not fragmented. It was just > > > in one dbspace. The db consists of about 900 tables and is taking more > > > than one gig more of space. The dbexport and import lines are: > > > > > > dbexport -o /adsm/dbexp/prod ifas> > > and > > > dbimport -i /adsm/dbexp/prod -d ifasdbs ifas> > > > > > any ideas??? > > > thanks > > > Pete > > >

I did check the FILLFACTOR both 7.23 and 9.2 are set to 90%. "Art S. Kagel" wrote: > The other thing to look at is the value of FILLFACTOR in the 9.2x ONCONFIG > file it can affect the amount of slack in each index node. > > Art S. Kagel > > Peter Shankey wrote: > > > > I measure the amount of space being used two ways. Both ways showed the same > > values: > > onstat -d counted chunks and free space> > Using the sql: > > > > database sysmaster;> > select > > d.name dbspace_name, > > (sum(c.chksize))*4096 Total_Size, > > (sum(c.chksize) - sum(c.nfree))*4096 Size_used, > > (sum(nfree))*4096 Size_of_free_space, > > round ((sum(nfree)) / (sum(chksize)) * 100, 0) percent_free > > from sysdbspaces d, syschunks c > > where d.dbsnum = c.dbsnum > > group by 1 > > order by 1; > > > > note the size of the db on 7.23 is about 4G and on 9.2 it is about 6G. > > > > Neil Truby wrote: > > > > > How are you measuring the amount of space used? > > > > > > Peter Shankey <shankeyp@charlestoncounty.org> wrote in message > > > news:39B1B796.301388EC@charlestoncounty.org... > > > > Using dbexport and dbimport I copied a database fro 7.23 to 9.2 . > > > > Version 9.2 is taking much more space than 7.23. The database does not > > > > have any blob data, just standard data types (char date integer) > > > > indexes, keys nothing special. The db was not fragmented. It was just > > > > in one dbspace. The db consists of about 900 tables and is taking more > > > > than one gig more of space. The dbexport and import lines are: > > > > > > > > dbexport -o /adsm/dbexp/prod ifas> > > > and > > > > dbimport -i /adsm/dbexp/prod -d ifasdbs ifas> > > > > > > > any ideas??? > > > > thanks > > > > Pete > > > > -- Pete Shankey shankeyp@charlestoncounty.org