Segregate Logical Log and Physical Log from rootdb (Informix)

One of how tuning the informix database is segregate Logical Log and Physical Log from rootdbs space. Following below my steps to segregate it:

Segregate Logical log from rootdbs:

1. Change current logical to the bottom by running command 'onmode -l'
2. Create new dbspace for logical log, example 'log_space' then add 'chunk'
3. Setting dbpace for logical log
'onmonitor > Parameters > Add-Log'
4. Example we want to create six logical log
We have to create new logical log by running command:
$ onparams -a -d logspace -s 100000 Run this command six times
5. Delete old Logical Log by running:
$ onparams -d -l 1 -----> where '1' is 'uniqid'
do that untill sixth uniqid

Segregate Physical log from rootdbs:

1. Create new dbspace for Physical log, example 'phy_space' then add 'chunk'
2. Create new space by running:
$ onparams -p -s 1000000 -d phy_space
3. Check it with 'onstat -d'


'you know.... it's very easy'