Re: Using HPL for migration
On Wed, 17 Sep 2003 13:28:14 -0400, John Carlson <john_carlson@whsmithusa.com> wrote: >On Wed, 17 Sep 2003 18:50:26 +0200, Nebojsa Sevo ><DELETE_mips@zg.tel.hr> wrote: > >>If I want to use HPL for migrating from 7.2x to 9.3x which format I must use for >>uloading / loading data? > >Safest way would be use the DELIMITED unload format. You might be >able to use the no-convert format, I think. If I remember correctly, >no-convert can be used if there are no changes to the table structure >and it is code page dependent. > >>Is there anything else I have to be aware of? >> > >No chance of doing an in-place upgrade? Actually, I am going to delete my archive database. I have to put datas somewhere else because "someone will may be need them one day". I hope that when that day come (if it come) I will have 9.x. So, if I will unload my data to file using HPL, is there 2GB limit? nebojsa ------------------------------------ Remove spam block (DELETE_) to reply
On Thu, 18 Sep 2003 17:43:01 +0200, Nebojsa Sevo <DELETE_mips@zg.tel.hr> wrote: >On Wed, 17 Sep 2003 13:28:14 -0400, John Carlson <john_carlson@whsmithusa.com> >wrote: > >>On Wed, 17 Sep 2003 18:50:26 +0200, Nebojsa Sevo >><DELETE_mips@zg.tel.hr> wrote: >> >>>If I want to use HPL for migrating from 7.2x to 9.3x which format I must use for >>>uloading / loading data? >> >>Safest way would be use the DELIMITED unload format. You might be >>able to use the no-convert format, I think. If I remember correctly, >>no-convert can be used if there are no changes to the table structure >>and it is code page dependent. >> >>>Is there anything else I have to be aware of? >>> >> >>No chance of doing an in-place upgrade? > >Actually, I am going to delete my archive database. I have to put datas >somewhere else because "someone will may be need them one day". I hope that when >that day come (if it come) I will have 9.x. >So, if I will unload my data to file using HPL, is there 2GB limit? > Not if you use multiple unload files in a "device array". Check out my article on the Informix Developer Zone . . . http://www7b.boulder.ibm.com/dmdd/zones/informix/library/techarticle/0307carlson/0307carlson.html Might be able to jumpstart some ideas.
Nebojsa Sevo wrote: > > On Wed, 17 Sep 2003 13:28:14 -0400, John Carlson <john_carlson@whsmithusa.com> > wrote: > > >On Wed, 17 Sep 2003 18:50:26 +0200, Nebojsa Sevo > ><DELETE_mips@zg.tel.hr> wrote: > > > >>If I want to use HPL for migrating from 7.2x to 9.3x which format I must use for > >>uloading / loading data? > > > >Safest way would be use the DELIMITED unload format. You might be > >able to use the no-convert format, I think. If I remember correctly, > >no-convert can be used if there are no changes to the table structure > >and it is code page dependent. > > > >>Is there anything else I have to be aware of? > >> > > > >No chance of doing an in-place upgrade? > > Actually, I am going to delete my archive database. I have to put datas > somewhere else because "someone will may be need them one day". I hope that when > that day come (if it come) I will have 9.x. > So, if I will unload my data to file using HPL, is there 2GB limit? > > nebojsa > > ------------------------------------ > Remove spam block (DELETE_) to reply find my posting on this, IIRR somewhen Apr or May No. There never was a 2GB limit, if you write to pipe. Even no 2GB limit, if you write to " | cat > somefile " (not so beautiful, I know) if there is no 2GB limit imposed by your operating system .... dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe