Hi there

I am traying to copy a big table between instances, I am using onunload and then onload

I used with other tables and it work ok.

but now I am getting
Error writing to tape device, Error No. = 22.

I am typing:
onunload -t /vol55-s/ev/etl/blj/blj_search.p -b 4 -s 1000000000000 b_blj:johnd.search

Can some body tell me where to look for this error or what is wromg ?

Thanks
GB

Hi.

I don´t know about this error message, but I know what you can do instead of use the onunload and the onload commands.

Use the
"unload to <filename> select * from <tablename>"
and the
"load from <filename> insert into <tablename>" in the other instance to load your table.
You must give the entire path for the file where you have unloaded the data, or be in the directory where you save it and give just the filename.

I hope it can help you.

Fernanda.

Thanks Fernanda I will try that

GB