Hi

We are using Informix 7.24.UC3 with Tivoli storage Manager on AIX 4.3.3. My
problem is about Database restoration.
I take complete databse backup by using onbar -b -w -L 0 command. For 194 GB
Database, system takes 3 hours and 30 min. But when I tried to restore same
backup using onbar -r -w -p, it takes around 26 Hours.

The hardware setup is as follows:-

RS/6000 H70 with 1.5 GB main memory, 2 SSA Advanced RAID controller
connected to SSA cabinet having 16 disks each of 36 GB. The 2 SSA
controllers have 4 SSA loops with 4 disks per loop and each loop is
configured as RAID 0.
The tape drive 3590 E11 is exclusively connected Fast / Wide SCSI controller
on H70.

The relevant contents of onconfig file are as follows:-

BAR_MAX_BACKUP  6
BAR_RETRY       1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 4
BAR_BSALIB_PATH=/usr/tivoli/tsm/client/informix/bin/bsashr10.o

Can anyone have any helpful OS/Informix/Hardware level hints to reduce the
restoration time ?

Pls feel free to contact me in case of any doubt.

Regards

Sachin Ganu
Information Security
IBM Global Services
C/o Siemens Kalwa Data Center
( BVQI Certified ISO 9002 )

* :- Direct :- +91-22-760 0033 / 48 / 47
          Board :-  +91-22-760 0001 - 6 Ext.:- 3596 / 3303
          Fax    :-  +91-22-760 0045

*:-  Sachin.Ganu AT kwa2.siemens.co DOT in <mailto:Sachin.Ganu AT 
kwa2.siemens.co DOT in>