Hi,

We are using baan4c4 on solaris8 and Informix9.21 as our database.
1. Can anyone tell me on how to compute/formula of the INITIAL and NEXT size to the $BSE/lib/infomrix/inf_storage file
2. Do I need to put a INITIAL and NEXT size to the index of the $BSE/lib/Informix/inf_storage file
3. How can I monitor all the extents size of all tables. :)

http://database.sarang.net/database/informix/faq/iiug/ifaqk.htm#APPK

Extents in Baan are only used when a table is first created. you can always change it afterwards in Informix.

I'm an Oracle kinda guy, but I am guessing that Informix comes with tools/scripts to monitor extents.

Hello,

Check out previous post on this subject.

http://www.baanboard.com/baanboard/showthread.php?t=7990&highlight=extents

This should get you started.

Cheers
Neal Matthews
IT Support Analyst
ATY Automotive & Industrial Components (UK) Ltd

Hi Neal Matthews,

I just got the result from the SQL below result of table tfgld106888:

ttfgld106888 13 29562374 4927062
tfgld1068881 115 1318678 219780
tfgld1068882 115 1725732 287622
tfgld1068883 113 1949227 324871
tfgld1068884 114 2243018 373836
tfgld1068885 115 2246398 374400
tfgld1068886 114 2243018 373836
tfgld1068887 114 2242992 373832
tfgld1068888 114 2243018 373836

my question is how would be the entry to the inf_storage for the index pls see below my entry of tfgld106888 at inf_storage file.

tfgld106:888:T:group:1:10:INITIAL 272 NEXT 340 DBSPACE co888_106dbs LOCK row
tfgld106:888:I::1::DBSPACE co888_106idx

do we need to add all the index or just get the large result?

Thanks

Marlon

Hello Marlon,

From what I understand the index extent sizing is worked out internally by the db.

See this post on dbforums

http://www.dbforums.com/t1047398.html

Concentrate on the extent sizes for the table and then see what effect this has on the index extents.

In my inf_storage I just copy the index line from the table line and change the dbspace as I store my indexs in seperate dbspaces.

Hope this makes sense. Bear in mind the server that I've done this on is not live yet but it appears to be running ok.

Cheers
Neal

Hi Neal,

Thanks a lot. Am planning to do it 1rst at our test server.

Cheers
Marlon