Unload Success! (was: Re: unload / reload blues)
Posted in 1994
Topics: Storage & Space Management, Error Codes & Troubleshooting, Migration, Import/Export & Data Conversion
I found a way to get my Informix unload/reload process to work. (I've
done it twice now, so it must be repeatable. 8^) Highlight from the
successful methods are included below.
>Strike 3: (tbunload -> tbload) - This should be it, right? BZZZT!
>tbload doesn't like the tape's contents. (BTW, /dev/rcht0 is a 4mm SCSI
>DAT drive hooked up to server01.)
>
>The following command:
> server01% tbunload -t /dev/rcht0 -b 16 -s 2097152 db
>
>completes in ~15 minutes. But then, I try "tbunload" into an empty
>dbspace:
> server0% tbload -t server01:/dev/rcht0 -b 16 -s 2097152 db
> Please mount tape and press Return to continue ...
> Error inserting system catalog record.
> ISAM error: duplicate value for a record with unique key
I had my Unix system administrator move the tape device from server01 to
server0. Then I ran the above sequence again, with the new tape
configuration.
server01% tbload -t server0:/dev/rcht0 -b 16 -s 2097152 db
[takes about 45 minutes]
server0% tbunload -t /dev/rcht0 -b 16 -s 2097152 db
[also takes about 45 minutes]
In looking at the new database on server0, it's identical to the
database on server01 at the time the tbload was done. I'm happy. 8^)
I got several other suggestions about alternative ways to do this. I'll
summarize those in a followup post.
...gwr...
--
George Rapp
Mail: gwr@metronet.com (home, preferred) - gwr@edsr.eds.com (work)
or: /DD.ID=MSMWHQ01.GRAPP01/@eds.diamondnet.sprint.com (work)
Phone: 214/604-1036 (voice - work) 214/604-1126 (fax)