Hi,
normaly you schedule a backup with multiple paralllel running processes.
But for the restore often these processes run sequential, because the
backups are colloacted on a few tapes. The processes can not read parallel
from tape. So try to desperse your backups on more tapes. (To investigate
this ask your ADSM-ADmin to do several "q sess f=d" cmds, here you will see
sessions waiting for a tape which ois already allocated to an other
session.)
An other reason are the logs, depending on the amount of logs you have to
roll forward, this can take an astonishing time.
_________________________________________________
Kind Regards
Andreas Buser
Tel: ++41 61 285 73 21 Fax: ++41 61 285 90 27
mailto:[EMAIL PROTECTED]
Address:
Basler Versicherungen
Andreas Buser
Abt. Informatik
Aeschengraben 21
4002 Basel
Switzerland
"Ganu Sachin, IBM"
<[EMAIL PROTECTED] An: [EMAIL PROTECTED]
ENS.CO.IN> Kopie:
Gesendet von: "ADSM: Thema: Informix ON-Bar restoration
performance problem
Dist Stor Manager"
<[EMAIL PROTECTED]>
27.02.01 04:28
Bitte antworten an
"ADSM: Dist Stor
Manager"
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
*:- [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
