I'd say the best thing to do would be to use Adager or DBGeneral (fast, efficient, reliable). These tools will check the integrity of the whole database and fix any other problems there may be.
If you were to decide to unload/load single datasets, you could also use Suprtool.
Thanks...François
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Jack Connor
Sent: Wednesday, April 09, 2008 9:05 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] BROKEN CHAIN POINTERS
Ditto on the Adager or DBGeneral products; they make life a whole lot
easier.
However, if you have the disc space, you can do a file equate of
DBUNLOAD;DEV=DISC and unload/load from disc.
Also, if you have the RAPID (DICTDBU, etc) you can unload/load single
sets to/from disc.
Jack
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Dave Gale
Sent: Wednesday, April 09, 2008 8:19 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] BROKEN CHAIN POINTERS
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 *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
Remarque - Cette transmission est pour l'usage exclusif du ou des destinataires indiqués et peut contenir de l'information confidentielle ou protégée. Si vous n'êtes pas le destinataire indiqué, veuillez supprimer cette transmission ainsi que tout fichier joint et aviser l'expéditeur par courriel immédiatement. Toute révision, utilisation, divulgation ou distribution non autorisée est interdite.
Notice: This transmission is for the sole use of the intended recipient(s) and may contain information that is confidential and/or privileged. If you are not the intended recipient, please delete this transmission and any attachments and notify the sender by return email immediately. Any unauthorized review, use, disclosure or distribution is prohibited.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
