Help with dbcopy/dbmove

Hi all! I'm trying to move some tables with Blob fields (stored in sbspaces) from an 11.50FC9 (HP-UX) to 12.10FC2(Linux). I've tried to use dbcopy and dbmove from the last utils2_ak package, but, in both cases, I'm getting the following errors: - dbcopy: copy_table: Invalid data type: 41 - dbmove: Opening cursor with rowid > 0. Error: -9270(0) on EXECUTE copystmt. Last good rowid = 0. As per I've read, this kind of movement should work with this utilities (or maybe I'm wrong and I can't use them to do the work...) Thanks for your help! Luis.

Luis: Bad news, dbcopy has never been extended to handle smart blobs, it only handles TEXT and BYTE type blobs. Dbmove, because it basically uses INSERT INTO .... SELECT FROM, cannot be used to move extended types (which includes BLOB and CLOB type columns) between servers. I could extend dbcopy support to CLOBs and BLOBs, but it would entail significant work and there are issues that I have avoided dealing with because smart blob documents can be shared by multiple source records which cause unwanted duplication at the target database. The best option for you would be to use external tables using pipes to move the data from one database to the other if you don't want to unload the data to disk and reload it. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Feb 4, 2014 at 6:36 AM, LUIS VENTURA <luisventurap@gmail.com> wrote: > Hi all! > > I'm trying to move some tables with Blob fields (stored in sbspaces) from > an > 11.50FC9 (HP-UX) to 12.10FC2(Linux). > > I've tried to use dbcopy and dbmove from the last utils2_ak package, but, > in > both cases, I'm getting the following errors: > - dbcopy: copy_table: Invalid data type: 41 > - dbmove: Opening cursor with rowid > 0. > > Error: -9270(0) on EXECUTE copystmt. > > Last good rowid = 0. > > As per I've read, this kind of movement should work with this utilities (or > maybe I'm wrong and I can't use them to do the work...) > > Thanks for your help! > Luis. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11336f44b8378404f19362da