dbTalk Databases Forums  

onbar dbspace restore with fragmentation

comp.databases.informix comp.databases.informix


Discuss onbar dbspace restore with fragmentation in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
red_valsen
 
Posts: n/a

Default onbar dbspace restore with fragmentation - 01-06-2012 , 02:02 PM






Five minutes after my data warehouse project's weekly ETL script for
its logged database completed, an assert failure occurred and the
informixserver halted at a checkpoint. When I forced it to continue,
the instance remained online but an entire dbspace with constituent
chunks was marked down. The dbspace contains data from a single table
that is fragmented across multiple dbspaces. If I execute an onbar
restore for the dbspace, will the data be reliably restored despite
the fragmentation or any referential integrity constraints?

Using IDS 10.00.FC7 on RHELAS9/2.6.9.

Reply With Quote
  #2  
Old   
Jon Ritson
 
Posts: n/a

Default Re: onbar dbspace restore with fragmentation - 01-08-2012 , 02:08 AM






Yes ... you may have to play with backing up the logs(obviously using onbar) first.

Question is more "why did it af?". If due to a bad disk (i.e. not an Informix defect) then you should sort that out, otherwise why will it not happen again?

JJ

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.