Oninit cdi / Archive
Talk to an expert →

There are ONUNLOAD limits?

Posted in 2004

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

Rafael Padilla — — source: Usenet: comp.databases.informix

Hi, I have a Database on IDS 9.21 This database has 1Gb size and I can unload it with onunload command to a file system. Few days before I loaded large data in several tables and database become 5 GB using 3 chunks. I tried to onunload this database to file system again, specifying touched files like tape parameter for onunload command with a size of 2 Gb. First touched file was filled ok, then In other session, I renamed filled file (to change de tape) and touched other empty one, this second started fine, but at certain time ONUNLOAD sent me this error message: "ISAM error: illegal argument to ISAM function" I hope someone can give an advice! REGARDS!

↪ replying to Rafael Padilla
Jonathan Leffler — — source: Usenet: comp.databases.informix

Rafael Padilla wrote: > I have a Database on IDS 9.21 > This database has 1Gb size and I can unload it with onunload command > to a file system. > > Few days before I loaded large data in several tables and database > become 5 GB using 3 chunks. > > I tried to onunload this database to file system again, specifying > touched files like tape parameter for onunload command with a size of > 2 Gb. First touched file was filled ok, then In other session, I > renamed filled file (to change de tape) and touched other empty one, > this second started fine, but at certain time ONUNLOAD sent me this > error message: "ISAM error: illegal argument to ISAM function" > I hope someone can give an advice! IDS 9.40 is the first version that supports bigger than 2 GB files reliably. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler
Rafael Padilla — — source: Usenet: comp.databases.informix

Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<DbNLb.2688$zj7.2591@newsread1.news.pas.earthlink.net>... > Rafael Padilla wrote: > > I have a Database on IDS 9.21 > > This database has 1Gb size and I can unload it with onunload command > > to a file system. > > > > Few days before I loaded large data in several tables and database > > become 5 GB using 3 chunks. > > > > I tried to onunload this database to file system again, specifying > > touched files like tape parameter for onunload command with a size of > > 2 Gb. First touched file was filled ok, then In other session, I > > renamed filled file (to change de tape) and touched other empty one, > > this second started fine, but at certain time ONUNLOAD sent me this > > error message: "ISAM error: illegal argument to ISAM function" > > I hope someone can give an advice! > > > IDS 9.40 is the first version that supports bigger than 2 GB files > reliably. Thanks Jonathan! I'll consider it!

Glossary