All 5 messages in topic - view as tree
From: Alessandro Vercelli - view profile
Date: Wed, Aug 23 2006 6:06 pm
Email: "Alessandro Vercelli"
Hi all,
I'm setting up an IDS database for test purposes (both IDS 9.40.UC4 on
Redhat AS 3), so I unloaded a table from a production db into a file and
transferred the file to test node.
When I try to load data with command:
onload -t
a message "Please mount tape and press Return to continue ..." is showed
and when I press enter "Invalid tape."
Source and destination db names are different but I don't believe this
is the problem, both DBs have same dbspaces.
Has anyone any suggestion and/or hint?
Thanks for the help,
Alessandro
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Reply Rate this post: Text for clearing space
From: Floyd Wellershaus - view profile
Date: Wed, Aug 23 2006 6:38 pm
Email: Floyd Wellershaus
echo "load from fullpath/filename insert into tablename" |dbaccess dbname
========================
-<
Database Administrator
Unix Administrator
email: fwell...@yahoo.com
Home: 703-430-0805
Cell: 703-477-6045
========================
http://www.one.org/
- Hide quoted text -
- Show quoted text -
----- Original Message ----
From: Alessandro Vercelli
To: informix-l...@iiug.org
Sent: Wednesday, August 23, 2006 12:06:04 PM
Subject: Onload "invalid tape" using file
Hi all,
I'm setting up an IDS database for test purposes (both IDS 9.40.UC4 on
Redhat AS 3), so I unloaded a table from a production db into a file and
transferred the file to test node.
When I try to load data with command:
onload -t
a message "Please mount tape and press Return to continue ..." is showed
and when I press enter "Invalid tape."
Source and destination db names are different but I don't believe this
is the problem, both DBs have same dbspaces.
Has anyone any suggestion and/or hint?
Thanks for the help,
Alessandro
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
_______________________________________________
Informix-list mailing list
Informix-l...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Reply Rate this post: Text for clearing space
From: Tsutomu Ogiwara - view profile
Date: Thurs, Aug 24 2006 7:49 am
Email: "Tsutomu Ogiwara"
Hi Alessandro.
Specify -b
onunload -b .. -s ...
Specify same size.
Hope this helps.
--
Tsutomu Ogiwara from Tokyo Japan.
- Hide quoted text -
- Show quoted text -
>From: "Alessandro Vercelli"
>To: informix-l...@iiug.org
>Subject: Onload "invalid tape" using file
>Date: Wed, 23 Aug 2006 16:06:04 +0000 (UTC)
>Hi all,
>I'm setting up an IDS database for test purposes (both IDS 9.40.UC4 on
>Redhat AS 3), so I unloaded a table from a production db into a file and
>transferred the file to test node.
>When I try to load data with command:
>onload -t
>a message "Please mount tape and press Return to continue ..." is showed
>and when I press enter "Invalid tape."
>Source and destination db names are different but I don't believe this
>is the problem, both DBs have same dbspaces.
>Has anyone any suggestion and/or hint?
>Thanks for the help,
>Alessandro
>--
>Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
>_______________________________________________
>Informix-list mailing list
>Informix-l...@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list
Reply Rate this post: Text for clearing space
From: Alessandro Vercelli - view profile
Date: Thurs, Aug 24 2006 11:17 am
Email: "Alessandro Vercelli"
Load (and unload) utility works with text files, while I'm using onload
which works with data files.
Regards,
Alessandro
"Floyd Wellershaus"
news:mailman.340.1156350759.20706.informix-list@iiug.org
> echo "load from fullpath/filename insert into tablename" |dbaccess dbname
> ========================
> -<
> Database Administrator
> Unix Administrator
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Reply Rate this post: Text for clearing space
From: Alessandro Vercelli - view profile
Date: Thurs, Aug 24 2006 11:26 am
Email: "Alessandro Vercelli"
Hi Tsutomu,
it helped very well: I used 4096 as block size (the same of the
filesystem) and 0 as tape size (i.e. the size passed to write is the
physical block size) and it worked fine.
Many thanks for your help,
Alessandro
"Tsutomu Ogiwara"
news:mailman.347.1156398289.20706.informix-list@iiug.org
> Hi Alessandro.
> Specify -b
> onunload -b .. -s ...
> Specify same size.
> Hope this helps.
> --
> Tsutomu Ogiwara from Tokyo Japan.
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Reply Rate this post: Text for clearing space
End of messages
No comments:
Post a Comment