Oninit cdi / Archive
Talk to an expert →

Onload "invalid tape" using file

Posted in 2006

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life

Alessandro Vercelli — — source: Usenet: comp.databases.informix

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 <full_path>/<file_name> <db_name>:informix.<table_name> 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

↪ replying to Alessandro Vercelli
Floyd Wellershaus — — source: Usenet: comp.databases.informix

echo "load from fullpath/filename insert into tablename" |dbaccess dbname ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/ ----- Original Message ---- From: Alessandro Vercelli <alever@libero.it> To: informix-list@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 <full_path>/<file_name> <db_name>:informix.<table_name> 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-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Alessandro Vercelli
Tsutomu Ogiwara — — source: Usenet: comp.databases.informix

Hi Alessandro. Specify -b <block size>] [-s <tape size>] with onload when you executed onunload -b .. -s ...Specify same size. Hope this helps. -- Tsutomu Ogiwara from Tokyo Japan. >From: "Alessandro Vercelli" <alever@libero.it> >To: informix-list@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 <full_path>/<file_name> <db_name>:informix.<table_name>> >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-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Floyd Wellershaus
Alessandro Vercelli — — source: Usenet: comp.databases.informix

Load (and unload) utility works with text files, while I'm using onload which works with data files. Regards, Alessandro "Floyd Wellershaus" <fwellers@yahoo.com> wrote in message news:mailman.340.1156350759.20706.informix-list@iiug.org > echo "load from fullpath/filename insert into tablename" |dbaccess dbname > > > ======================== > -<<Floyd Wellershaus>>- > Database Administrator > Unix Administrator > -- Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

↪ replying to Tsutomu Ogiwara
Alessandro Vercelli — — source: Usenet: comp.databases.informix

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" <tsutomu_ogiwara@hotmail.com> wrote in message news:mailman.347.1156398289.20706.informix-list@iiug.org > Hi Alessandro. > > Specify -b <block size>] [-s <tape size>] with onload when you executed > onunload -b .. -s ...> Specify same size. > > Hope this helps. > > -- > Tsutomu Ogiwara from Tokyo Japan. > > -- Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Glossary