Restores

I note that there are different code streams now between IDS Workgroup and Enterprise Edition. And I've just tried to restore an 11.5FC6 EE archive onto a test server ..... ontape -r -t STDIO < /scratch//99.dmp Backup data version is not compatible with Online version: IBM Informix Dynamic Server Version 11.50.FC6WE Physical restore failed - function Invalid archive tape failed code -1 errno 0 Ugh! A couple of questions: - is this just something done in the version comparison part of the restore program, or is there a fundamental difference in the structures? - assuming the former can it be easily obviated? Thanks Neil

The first reserved page, page 0, contains the version of the server that created the instance (ie with oninit -i) and so the only version that can properly restore an archive. Similarly the archive itself writes out a similar descriptive page at the beginning of the archive file/tape. Ontape/onbar checks both IB. All IDS releases share the same code base AFAIAA. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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, Mar 23, 2010 at 6:50 PM, Neil Truby <neil.truby@ardenta.com> wrote: > I note that there are different code streams now between IDS Workgroup and > Enterprise Edition. > > And I've just tried to restore an 11.5FC6 EE archive onto a test server > ..... > > ontape -r -t STDIO < /scratch//99.dmp> > Backup data version is not compatible with Online version: > IBM Informix Dynamic Server Version 11.50.FC6WE > Physical restore failed - function Invalid archive tape failed code -1 > errno > 0 > > Ugh! > > A couple of questions: > - is this just something done in the version comparison part of the restore > program, or is there a fundamental difference in the structures? > - assuming the former can it be easily obviated? > > Thanks > Neil > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

"Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.44.1269387546.1071.informix-list@iiug.org... >> The first reserved page, page 0, contains the version of the server that >> created the instance (ie with oninit -i) and so the only version that can >> properly restore an archive. Similarly the archive itself writes out a >> similar descriptive page at the beginning of the archive file/tape. >> Ontape/onbar checks both IB. >> All IDS releases share the same code base AFAIAA. Well in 11.5 they definitely don't. Take IDS 11.5 FC6. Enterprise (EE): IBM Informix Dynamic Server Version 11.50.FC6 Software Serial Number AAA#B000000 WorkGroup WGE: IBM Informix Dynamic Server Version 11.50.FC6WE Software Serial Number AAA#B000000 WGE now puts out messages at initialisation: 23:53:26 Warning: The IBM IDS Workgroup Edition license restriction limits 23:53:26 the total shared memory size for this server to 16777216 KB. 23:53:26 The size has been reset to the limit to bring up the database server. And, as you saw from my example, IDS 11.5 WGE cannot restore an EE archive, even though the versions are otherwise identical. However, having installed 11.5 EE to effect the restore I then stopped the instance and brought it up with IDS 11.5 FC6 WGE and it is fine and has passed all basic checks. So I think it is just a cosmetic thing. And it's going to be a pain in the arse too :-(((( >> Ontape/onbar checks both IB. A competent programmer should be able to edit the archive file then? Wonder if I can find one ..... Thanks Neil

You've never heard of #DEFINE and #if DEFINED()? Same code, different compiles. That's how the resoruce limitations are implemented as well as the version checks. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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, Mar 23, 2010 at 7:52 PM, Neil Truby <neil.truby@ardenta.com> wrote: > "Art Kagel" <art.kagel@gmail.com> wrote in message > news:mailman.44.1269387546.1071.informix-list@iiug.org... > >> The first reserved page, page 0, contains the version of the server that > >> created the instance (ie with oninit -i) and so the only version that > can > >> properly restore an archive. Similarly the archive itself writes out a > >> similar descriptive page at the beginning of the archive file/tape. > >> Ontape/onbar checks both IB. > >> All IDS releases share the same code base AFAIAA. > > Well in 11.5 they definitely don't. Take IDS 11.5 FC6. > > Enterprise (EE): > IBM Informix Dynamic Server Version 11.50.FC6 Software Serial Number > AAA#B000000 > > WorkGroup WGE: > IBM Informix Dynamic Server Version 11.50.FC6WE Software Serial Number > AAA#B000000 > > WGE now puts out messages at initialisation: > 23:53:26 Warning: The IBM IDS Workgroup Edition license restriction limits > 23:53:26 the total shared memory size for this server to 16777216 KB. > 23:53:26 The size has been reset to the limit to bring up the database > server.> > And, as you saw from my example, IDS 11.5 WGE cannot restore an EE archive, > even though the versions are otherwise identical. > > However, having installed 11.5 EE to effect the restore I then stopped the > instance and brought it up with IDS 11.5 FC6 WGE and it is fine and has > passed all basic checks. So I think it is just a cosmetic thing. > > And it's going to be a pain in the arse too :-(((( > > >> Ontape/onbar checks both IB. > A competent programmer should be able to edit the archive file then? > Wonder > if I can find one ..... > > Thanks > Neil > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

"Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.46.1269395389.1071.informix-list@iiug.org... >> You've never heard of #DEFINE and #if DEFINED()? Same code, different >> compiles. That's how the resoruce limitations are implemented as well as >> the version checks. Maybe we're just arguing semantics? You have to download different software for WGE then for EE (I know, I've just wasted half an hour downloading and installing EE just so I can do the restore ;-)). Depending upon which you've download they do different things, like put out resource restriction messages, and in fact actually apply the restrictions. Since there's nothing on my (or your syste,) which the oninit program can query to decide whether you are an EE or WGE customer, the code *must* be different, even if very supericially, surely ...?!

Granted and accepted. As far as the semantics, when hard core developers (I still count myself in there) talk about the 'code base' we refer to the source code files. If two executable entities are compiled from the same source files, they have the same code base. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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, Mar 23, 2010 at 11:18 PM, Neil Truby <neil.truby@ardenta.com> wrote: > "Art Kagel" <art.kagel@gmail.com> wrote in message > news:mailman.46.1269395389.1071.informix-list@iiug.org... > >> You've never heard of #DEFINE and #if DEFINED()? Same code, different > >> compiles. That's how the resoruce limitations are implemented as well > as > >> the version checks. > > Maybe we're just arguing semantics? > You have to download different software for WGE then for EE (I know, I've > just wasted half an hour downloading and installing EE just so I can do the > restore ;-)). > Depending upon which you've download they do different things, like put out > resource restriction messages, and in fact actually apply the restrictions. > Since there's nothing on my (or your syste,) which the oninit program can > query to decide whether you are an EE or WGE customer, the code *must* be > different, even if very supericially, surely ...?! > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

>> "Art Kagel" <art.kagel@gmail.com> wrote in message >> news:mailman.47.1269402096.1071.informix-list@iiug.org... Granted and accepted. >> As far as the semantics, when hard core developers (I still count myself >> in there) talk about the 'code base' we refer to the source code files. >> If two executable entities are compiled from the same source files, they >> have the same code base. Cool. Point is, as I have discovered you can't restore an EE backup to a WGE system, which caused me a headache, and which I think could affect quite a few sites, as it's quite common to have EE for live and WGE for non-production ....