Try not using the -w command this could be causing the long restore time...
try using
onbar -b -l0 and when it restores it will restore individual tablespaces
that it wrote to multiple tapes.. multi streaming versus single streaming.
Thanks
Marc
_________________________________________________
Marc Layne
Product Manager - Services, Storage and Software Solutions
Faritec
Mobile: +27 82 4169086 email: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
Office: + 27 21 7629702 http://www.faritec.co.za/
_________________________________________________
-----Original Message-----
From: Andreas Buser [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2001 09:11
To: [EMAIL PROTECTED]
Subject: Re: Informix ON-Bar restoration performance problem
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]>
"This message may contain information which is confidential, private or
privileged in nature. If you are not the intended recipient, you may not
peruse, use, disseminate, distribute or copy this message or file which is
attached to this message. If you have received this message in error,
please notify the sender immediately by e-mail, facsimile or telephone and
thereafter return and/or destroy the original message.
Any views of this communication are those of the sender except where the
sender specifically states them to be those of Faritec (Proprietary) Limited
("Faritec") and/or Midrange Distribution Services (Pty) Ltd.
Please note that the recipient must scan this e-mail and any attached files
for viruses and the like. While we do everything possible to protect
information from viruses, Faritec accepts no liability of whatever nature
for any loss, liability, damage or expense resulting directly or indirectly
from the access and/or downloading of any files which are attached to this
e-mail message."
