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:Andreas.Buser AT Basler DOT ch

Address:
Basler Versicherungen
Andreas Buser
Abt. Informatik
Aeschengraben 21
4002 Basel
Switzerland



                    "Ganu Sachin, IBM"
                    <Sachin.Ganu AT KWA2 DOT SIEM        An:     ADSM-L AT 
VM.MARIST DOT EDU
                    ENS.CO.IN>                    Kopie:
                    Gesendet von: "ADSM:          Thema:  Informix ON-Bar 
restoration performance problem
                    Dist Stor Manager"
                    <ADSM-L AT VM.MARIST DOT EDU>


                    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

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