We are backing up our Informix databases using SQL-BackTrack for Informix. This
allows us to restore by table as opposed to the whole thing. I find that
restoring the WHOLE data base usually takes about twice the time of the backup
(I have three application instances using Informix databases. You also failed to
mention what your TSM environment looked like and thus, I will assume that you
have optimized the parameters which can affect a restore. My onconfig file
parameters are identical for all three instances:

#Backup / Restore stuff
BAR_MAX_BACKUP  2
BAR_RETRY       2
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 15
HETERO_COMMIT   0
BAR_DEBUG_LOG   /tmp/dbg_bar.dmart
BAR_ACT_LOG     /tmp/bar_act_log.dmart
BAR_BSALIB_PATH /usr/bmc/IFX/ibacktrack/lib/bsashr10.o

George Lesho
Storage/System Admin
AFC Enterprises







"Ganu Sachin, IBM" <Sachin.Ganu AT KWA2.SIEMENS.CO DOT IN> on 04/10/2001 
03:46:18 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: George Lesho/Partners/AFC)
Fax to:
Subject:  FW: Informix ON-Bar restoration performance problem



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 250
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 ?

We had lodged call SAP-OSS and they have come back to us saying problem with
TSM. But we are able to backup same database in 3.5 hr.  So we are not able
to find out the problem
Regards

Sachin