Oninit cdi / Archive
Talk to an expert →

ontape vs onbar

Posted in 2005

Topics: Backup & Restore, Platform-Specific Issues, Versions, Editions & End-of-Life

Neil Truby — — source: Usenet: comp.databases.informix

IDS 10.0FC3 on Solaris 9 I'm doing some backups to disk. An ontape backup of the 30G database with a 768k TAPEBLK takes about 25 mins, but an onbar -b -L 0 takes over twice as long. I wonder if it's that the block size being used is much smaller? There's some excellent documentation in the DB2 Information Center, but this doesn;t seem to be configurable. Also, it's writing out 15 x 2Gbyte files (sequentially) rather than one large file: thought this would be different post-9.40. Anyone know why? Thanks Neil

↪ replying to Neil Truby
TBP — — source: Usenet: comp.databases.informix

Neil Truby wrote: > IDS 10.0FC3 on Solaris 9 > > I'm doing some backups to disk. > > An ontape backup of the 30G database with a 768k TAPEBLK takes about 25 > mins, but an onbar -b -L 0 takes over twice as long. > > I wonder if it's that the block size being used is much smaller? There's > some excellent documentation in the DB2 Information Center, but this doesn;t > seem to be configurable. > > Also, it's writing out 15 x 2Gbyte files (sequentially) rather than one > large file: thought this would be different post-9.40. Anyone know why? > > Thanks > Neil > > BAR_MAX_BACKUP 0????? How many dbspaces? What is your storage manager? How does onbar -b -w run?

↪ replying to TBP
Neil Truby — — source: Usenet: comp.databases.informix

"TBP" <TheBigPotato@NotHere.Co.Uk> wrote in message news:UxPKe.4176$QU4.3989@newsfe5-win.ntli.net... > Neil Truby wrote: >> IDS 10.0FC3 on Solaris 9 >> >> I'm doing some backups to disk. >> >> An ontape backup of the 30G database with a 768k TAPEBLK takes about 25 >> mins, but an onbar -b -L 0 takes over twice as long. >> >> I wonder if it's that the block size being used is much smaller? There's >> some excellent documentation in the DB2 Information Center, but this >> doesn;t >> seem to be configurable. >> >> Also, it's writing out 15 x 2Gbyte files (sequentially) rather than one >> large file: thought this would be different post-9.40. Anyone know why? >> >> Thanks >> Neil >> >> > BAR_MAX_BACKUP 0????? What does it do? Gosh, I'm going to have to read TFM aren't I? ;-) > How many dbspaces? Root, log log, phys log (3 x temp), one large application dbspace. > What is your storage manager? ISM How does onbar -b -w run?

Glossary