Re: onload question
Posted in 1997
Erika Malchiodi <emalchio@NOSPAMbbn.com> wrote:
>I'm trying to use onload to load data from disk (not from tape).
>I have informix on an NT machine (which has no tape drive), and
>am trying the following command at the dos prompt:
>> onload -t c:\\info.dat -d testdbs test
>I get a message saying:
>Please mount tape and press Return to continue...
>I hit Return and get this:
>Incorrect tape type
>Please mount tape and press Return to continue...
>Is there any way around this problem?
I have been having the same problem with my HP systems. The only way
I have found around this problem is to NOT use the -l option on the
onunload.
I have used the following two commands successfully.
onunload -t /dev/rmt/0m -b 16 -s 4000000 fsprod
onload -t /dev/rmt/0m -b 16 -s 4000000 -d fsprod_data_01 fsprod
However, I have a follow up question. When I do the onload, it
appears to ignore the schema and tries to put all the tables in the
same dbspace. I have two dbspaces for tables:
fsprod_data_01
fsprod_data_02
and two index spaces
fsprod_index_01
fsprod_index_02
Using onload, the indexes appear to build in the correct dbspaces but
the tables are all goin into the first dbspace.
Any clues?
Barry Leb
National Linen Service
1420 Peachtree Street
MS #314
Atlanta, GA 30309
(404) 853-6119
(404) 853-6485 fax
e-mail: barryleb@mindspring.com