Baan support ask me to increase it as below.. i have attach the current dbs size in doc.

For baandb_log add additional 2 GB

For baandb_dbs add additional 1GB

For baandb_plog add additional 1GB

For baandb_tmp add additional 100MB

is increase the size require so big like the log, etc..

Hi,

Actually this is a job of your DBA...who can monitor DB growth closely and suggest/do changes.

Its recommanded to have similar datafile sizes and additional free space available in your DB to function it properly otherwise you might face hung issues.

regards,

-Suhas

i am the only IT support.. i am not good in DBA.

please help..

normally physical log and logical log are set to reuse, tmp also noneed unless really not enough.

only the data dbs you need to add chuck to cope the increase of data, if index dbs are use than you need to add that also.

if u have archieve comp, create a seperate dbs for it and will make your life easier.

so i will just add baandb_dbs add additional 1GB, is it? do i create one 1GB dbs file or split into 2 x 512mb dbs files?

so for the rest of the dbs, no need to add?

what do you mean by "archieve comp, create a seperate dbs for it and will make your life easier."

i am not good in this.

i not so sure about win base informix, but chunk is 2gb limit so is better you put the max 2gb. the ol dbs i not sure what is assign for so i won't give comment, if is use for index than you need to add as well.

when your system runs for some times, eg, 5,6 yrs. you purge the data from the live company to this archieve/history company, so you live company db will be smaller and backup faster.

history company you only backup when you do any update,

so for the ol dbs, currently is 99mb free out of 100mb. do i need to increase?

are you saying move the date to another campines..

eg.. production is 900

archive is 901

but will it overwrite the 901 date, or does it append to it, how do i do it?

so far we have 10yrs of data.. informix DB around 20GB in company 900.

does create smaller chunk better or create a 2gb chunk in term for performance in informix..?

is there any limit of no of chunk, i have quite a free chunk already..

what is ol dbs for? i think your index and data are load on the same dbs, therefore you mostly only need to add the baandb dbs.

yes, archieving is normal needed to keep your live company data under control size or certain years. ease of backup and better performance. archieve session will purge the data on live company and copy it to the archieve comp.

2gb better, as performance there are many factors.

limitation refer to table for your version
http://www-1.ibm.com/support/docview.wss?rs=631&context=SSGHZP&dc=DB520&dc=DB560&uid=swg21105436&loc=en_US&cs=UTF-8&lang=en&rss=ct631db2

i have increase the baandb_dbs additional 1GB as for the rest i did not add yet...