IDS Forum

Re: Informix 7 Migration

Posted By: Alexandre Marini
Date: Thursday, 29 September 2011, at 8:08 a.m.

In Response To: RE: Re: Informix 7 Migration (Marcus Haarmann)

Hello Jon.
Another important thing, I´d rather use one primary VM for production
database + applications,
and another would be a secondary (Hdr or Rss), in case you need it for
failover purposes

(You mentioned your application is very critical, so that should be
strongly recommended, right?
I don´t see any kind of troubles letting your 4gl apps on the same
machine as your engine - even less with a small box, like yours.)

(Innovator-C provides you this, but only for 1 secondary node, in read
only mode....)

Regards.

Em 29/09/2011 07:11, Marcus Haarmann escreveu:
> Hi,
>
> regarding the question to upgrade from 7.x to 11.5 or 11.7,
> there is no direct upgrade path because this would be a platform change
> from AIX to Linux.
> You have to dbexport the data, copy everything and dbimport on the other
> machine.
> Keep the same settings for DB_LOCALE, CLIENT_LOCALE, DBMONEY etc. for
> this process.
> 10 GB of data with ~50 users in parallel should be doable with an
> Innovator instance (if users are equal to parallel sessions).
> Maybe this also works if you put the 4GL processes on the same machine,
> this could make things
> easier if you have operating system users as DB users.
> But I dont think you are restricted to one machine, cause IP is
> supported as transport in 4GL AFAIK.
> You should try to set up a test instance, getting hands on a Innovator
> Edition, which you can load free of charge,
> copy your data and check out if the 4GL stuff is working (maybe
> initially on the same machine).
>
> Marcus
>
> -----Original Message-----
> From: JONATHAN WEBB [mailto:jonathan.webb@musto.com]
> Sent: Thursday, September 29, 2011 12:26 PM
> To: ids@iiug.org
> Subject: Re: Informix 7 Migration [25058]
>
> Hi,
>
> First ill start by trying to answer some of your questions...apologies
> for any bits im missing, please ask if you'd like to know. Im a Wintel
> engineer
>
> We are using R4GL 7.5 (so ive been informed!) i dont know if that will
> have any impact at all?
>
> Active users, average about 50 users at once, if we push it, goes to 70.
>
> Theoretical maximum number would be 100 (never hit this!).
>
> The Informix DB is approximately 10Gb in size.
>
> This is the response that ive had from the developer, hopefully you can
> get more out of this than I can do.
>
> NB: The Collection aka TC, is the primary set of applications that are
> used.
>
> ________________________________________________________________________
> _______
>
> "The 4GL Environment consists of the Informix 4GL Development
> Environment, Informix 4GL Runtime Environment& the Informix 4GL
> applications (The Collection programs). The TC programs are not compiled
> to be direct executables they are run through the Informix 4GL Runtime
> environment. The Informix 4GL Development Environment and 4GL Runtime
> Environment are licensed per user. Licensing cost for 4GL and database
> is significant and varies between machine platforms/OS and number of
> processors on the host machine.
>
> NB We also use the Informix DB Access Tools (mainly used by developers,
> but users also execute queries through this tool).
>
> NB the Informix 4GL Runtime& TC programs must execute on the same
> server on which the database resides this is a requirement of Informix
> 4GL. "
>
> ________________________________________________________________________
> _______
>
> > From this im taking it that our Dev doesnt think that we could move the
>
> informix DB over to CentOS/Ubuntu install as the 4GL applications
> require
> local access to the informix DB. Does that sound about right?
>
> Where to now...
>
> So we have no money to do anything about licensing, or buying new
> hardware,
> hard financial times im sorry to say.
>
> What I do have is some half decent hardware avilable. A VMware ESXi
> 4.1u1 box,
> with two 2.9Ghz Xeon 6core CPU's. 1.5TB of disk space running on dual
> port 10k
> SAS drives in RAID 5, and 48GB of RAM. There is more than enough grunt
> on that
> box for the user base that we need to support.
>
> So visualization is the plan for the minute at least, it gives us the
> flexibility to move the machine around or push down to bear metal if we
> need
> dedicated hardware.
>
> With that in mind, CentOS would be the OS of choice, seeing as its
> background
> is Redhat it should provide the most compatibility for what we are
> doing, and
> the price is right.
>
> Im thinking that id be looking at building.
>
> 1 x VM for Informix Innovator C (free edition), this will allow me to
> address
> 4 cores and 2GB of RAM for the DB. Im guessing with the number of
> sessions we
> are running and the DB size this should be enough.
>
> 1 x VM for the 4GL applications to live on.
>
> So now the questions I have!
>
> Given what the dev has mentioned to me, does Aubit 4GL look like a
> possible
> solution?
>
> Is creating a couple of VM's the best place to start?
>
> How to migrate data from the Informix 7.5 live DB to the new VM runnning
> the
> latest Informix Innovator C?
>
> Is there a better way to do this?!
>
> Thanks again for all your time and help on this.
>
> Jon
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--

Alexandre Marini

Tecnologia da Informação - DBA

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

<Cert-Info-Mgmt_color.jpg>

IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
V11.70

IBM Information Management Informix Technical Professional v3

Messages In This Thread

• Informix 7 Migration
  JONATHAN WEBB -- Wednesday, 28 September 2011, at 11:31 a.m.
  • Re: Informix 7 Migration
    Alexandre Marini -- Wednesday, 28 September 2011, at 11:42 a.m.
  • Re: Informix 7 Migration
    Marco Greco -- Wednesday, 28 September 2011, at 11:47 a.m.
    • RE: Informix 7 Migration
      Noel Murphy -- Wednesday, 28 September 2011, at 11:58 a.m.
  • Re: Informix 7 Migration
    Obnoxio The Clown -- Wednesday, 28 September 2011, at 11:53 a.m.
    • Re: Informix 7 Migration
      Hrvoje Zokovic -- Wednesday, 28 September 2011, at 1:47 p.m.
      • Re: Informix 7 Migration
        JONATHAN WEBB -- Thursday, 29 September 2011, at 4:15 a.m.
  • Re: Informix 7 Migration
    JONATHAN WEBB -- Thursday, 29 September 2011, at 6:25 a.m.
    • RE: Re: Informix 7 Migration
      Marcus Haarmann -- Thursday, 29 September 2011, at 7:11 a.m.
      • Re: Informix 7 Migration
        Alexandre Marini -- Thursday, 29 September 2011, at 8:08 a.m.
      • Re: Re: Informix 7 Migration
        Art Kagel -- Saturday, 1 October 2011, at 8:11 p.m.
    • Re: Informix 7 Migration
      Obnoxio The Clown -- Thursday, 29 September 2011, at 7:34 p.m.
      • Re: Informix 7 Migration
        JONATHAN WEBB -- Monday, 3 October 2011, at 6:21 a.m.
  • RE: Informix 7 Migration
    Scott O'Rourke -- Thursday, 29 September 2011, at 9:46 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.