HP3000-L Archives

April 2008, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Dave Gale <[log in to unmask]>
Reply To:
Dave Gale <[log in to unmask]>
Date:
Wed, 9 Apr 2008 08:19:26 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (70 lines)
Friedrich:

There are 2 options:

1. Use a 3rd party tool like Adager or DBGeneral to do an analysis and 
repair.
2. Unload the dataset and reload.

HP never provided any tools with the image database, hence the unload 
and load. This is slow and with that type of volume could take days, 
depending on your tape technology. I personally prefer Adager as I have 
always had good results and excellent support from them.

Hope your day gets better!

Dave

Friedrich Harasleben wrote:
> Dear database experts
>
> we do have a problem on one of our big datasets (>7000000 entries)
>
> FIND risikonummer = "9CW2D5"
> BROKEN CHAIN POINTERS
> 0  ENTRIES QUALIFIED
>
> the problem results in aborting one of our COGBNOS/QDESIGN programs with 
> "data access error".
>
> - how can I find out which pointers are broken
> - how can I fix the problem
>
> thanks for any suggestions
> friedrich
>
> Mag. Friedrich Harasleben
> stv. Leiter IT & Operations
>
> Coface Austria Holding AG
> Coface Central Europe Holding AG
> Stubenring 24
> 1010 Wien
> Austria
> T: +43/1/515 54-300
> F: +43/1/515 54-50300
> www.coface.at
> www.cofacecentraleurope.com
>
> Firmenbuchnr. FN 65493 p (Coface Austria)
> Firmenbuchnr. FN 043204 k (Coface Central Europe)
> Handelsgericht Wien
>
> This e-mail message may contain confidential and/or privileged 
> information. If you are not the intended recipient (or have received this 
> e-mail in error) please notify the sender immediately and destroy this 
> e-mail. Any unauthorized copying, disclosure or distribution of the 
> material in this e-mail is strictly forbidden. 
>
> P Before printing, please think about the impact it has on the environment 
>
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>   


* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2