ADSM-L

FW: Informix ON-Bar restoration performance problem

2001-04-10 04:44:21
Subject: FW: Informix ON-Bar restoration performance problem
From: "Ganu Sachin, IBM" <Sachin.Ganu AT KWA2.SIEMENS.CO DOT IN>
Date: Tue, 10 Apr 2001 14:16:18 +0530
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
<Prev in Thread] Current Thread [Next in Thread>