We are thinking to move Baan's most selected tables,which are tiitm001 and tdinv001 etc. for gaining performance to move the less busy disks(disk1,disk2) with opening a new dbspace only for them.

Following average February busy column of sar command for all disks:

disk1 % 1.7
Informix_Binary
Informix_Temp
Logical Log

disk2 % 61.7
Data

disk3 % 58.1
Data

disk4 % 3.9
Baan_Binary
Physical Log
Rootdbs

1.)is it sensible to move these tables to disks disk1 and disk2? if yes,which of them?

2.)Which tables can we move other than tiitm001 and tdinv001 which you know get most selective hits on themselves?
[50.1 51.7 busy column busy column

1) Move the tables to disk 1 and 4 as these are least used
2) Forgot how to determine most frequently used tables but I know that tables with logical and physical log should not be loaded too much by other things than logging to keep performance acceptable.

What Baan version you are using? I assume Baan IV cX

The best approach to identify the tables to MOVE will be monitor the table growth over the period of time (may be by taking row count of tables) may be once in a week for 4-5 weeks and then identify the table growth.

I suggest you to include Non Finalized transaction / Finalized transaction / ILC Inventory TRX (if you r using ILC) etc tables as well.

-- Avinash

Apart from inv001 and itm001 tables which other tables we should put on the new dbspace. You say in your answer as include Non Finalized transaction / Finalized transaction / ILC Inventory TRX.

But i want to hear the full and exact names of them?
For example, Would you suggest ilc106,too?

Thanks in advance.

Hi,

I think it will be better if you can quote the version of Baan you r using either in your profile or in the quote for the exact answers.

I assume it is Baan ERP 5.x

following tables can be included
tfgld410 / tfgld416 / tfgld417 (provided you r using Baan FInance fully)
whinr100 / whinr110 (if you have lot of inventory trx)

-- Avinash

Mr. askajale

we are using Baan IV and full packages of it under HP-UX with 4 CPU,5 GB RAM.

Hello,

As you are on Baan IV, you should think of putting following tables

tfgld102 (Non Finalized TRX)
tfgld106 *Finalized TRX)
tdinv100
tdinv150

-- Avinash

Hi,

What business are you in?
Which packages do you use and how many users can you link to each package?

How is your hardware configured?
I see four disks. Are these logical or the physical disks.

We run with a mirrorred stripe set on a Sun E450.
A stripe set consists of 5 disks. The complete set of 5 disks is mirrorred on an other stripe set. Writing is done simultanously on both sets, reading is done from each set individualy.
Each time aconsultant works on our system they admit that it's fast. So there must be some thruth in this configuraton.

Our firm is on furniture manifacturing. we have 200 concurrent users.20 user for tf, 70 user for ti, 90 user for td and 10 user for ts packages.

Our avarage daily disk data increasing is about 200 MB.We have 10 physical SCSI disks ,which half of them mirrored.They are for Appl.(Baan IV) and DB(Informix) data. Apart from these disks we have 2 disks for Unix OS.