IDS Forum

Re: 10 Years of Innovation at IBM

Posted By: Jack Parker
Date: Thursday, 12 May 2011, at 12:08 p.m.

In Response To: Re: 10 Years of Innovation at IBM (Fernando Nunes)

Windows is an abomination and it's a wonder that anything works on it. =
I really have no right to whine.

SW is also more complicated and the stack is deeper than it was 20 years =
ago, any time we cobble stuff together there are going to be things that =
don't fit cleanly.

It would be nice to have some sort of HPL GUI on windows - even if it's =
not X related. However, it's not worth the trouble, onpladm pretty much =
does the job.

Xtree was a wonderful tool and it's a shame that it's been abandoned.

Perhaps I'm working at a lower level than I was 20 years ago, it just =
seems that I run into more trouble getting stuff to work these days. My =
first day on unix, I figured out lpadmin in under an hour. Decades =
later I'm struggling with ifxdeploy.

cheers
j.

On May 12, 2011, at 11:50 AM, Fernando Nunes wrote:

> I understand why they can't be supported. I tried to give this as an =
example=20
> where some features naturally prevent others from working.=20
>=20
> On Thu, May 12, 2011 at 4:34 PM, Madison Pruet <mpruet@us.ibm.com> =
wrote:=20
>=20
>> I've heard the complaint about raw tables before so will address =
that.=20
>>=20
>> MACH11 requires logging to communicate to the secondary nodes what =
changes=20
>> have been made on the primary. Yea we could implement a form of 'raw'=20=

>> table support --- but only by internally ignoring the fact that 'raw'=20=

>> tables aren't supposed to be logged and log them anyway.=20
>>=20
>> From: "Fernando Nunes" <domusonline@gmail.com>=20
>>=20
>> To: ids@iiug.org=20
>>=20
>> Date: 05/12/2011 10:11 AM=20
>>=20
>> Subject: Re: 10 Years of Innovation at IBM [23675]=20
>>=20
>> Sent by: ids-bounces@iiug.org=20
>>=20
>> That cleared a lot of stuff...=20
>> Some of the things are easy to explain, others not, and could =
eventually be=20
>>=20
>> considered bugs...=20
>>=20
>> On Thu, May 12, 2011 at 12:41 PM, Jack Parker=20
>> <jack.parker4@verizon.net>wrote:=20
>>=20
>>> All of the things that you used to be able to do you can still do, =
it's =3D=20
>>=20
>>> the "new" stuff.=20
>>>=20
>>> Try getting HPL to work under windows. There are all sorts of =3D=20
>>> restrictions. No pipes. No ipload interface, everything has to go =3D=20=

>>>=20
>>=20
>> ipload needs X-Windows. Windows has no X-Windows... It would be hard =
to=20
>> emulate it...=20
>>=20
>>> through onpladm, you can't actually invoke the job through onpladm =
(even=20
>> =3D=20
>>> though it is advertised as such - you have to invoke onpload), I =
forget =3D=20
>>=20
>>> now, but I seem to remember issues with device arrays.=20
>>>=20
>>>=20
>>=20
>>> Work on a mac, no Xtree.=20
>>>=20
>>>=20
>> Xtree is deprecated for a long time I believe. As such it wouldn't =
make=20
>> sense to put it on mac...=20
>>=20
>>> I've just spend a couple of days trying to get ifxdeploy to work on =
Win =3D=20
>>=20
>>> 2008. You have to turn your body sideways and approach it in just =
the =3D=20
>>> right direction (if you use ifxdeployassist from the command line =
you =3D=20
>>> have to be selective in what options you choose (I've given up there =
and=20
>> =3D=20
>>> moved to the GUI until I can get ifxdeploy to work), has to have =
java =3D=20
>>> installed and in the PATH, extracts to the local directory instead =
of =3D=20
>>> $INFORMIXDIR) - then complains that %INFORMIXDIR/etc/%ONCONFIG =
doesn't =3D=20
>>> exist - and currently it fails when trying to allocate dbspaces. I'm =
=3D=20
>>> currently working with folks at IBM on this one.=20
>>>=20
>>>=20
>> I havent' work with ifxdeploy. But this may lie under the bug =
umbrella?=20
>>=20
>>> Uninstall on Windows is iffy. You have to check that %INFORMIXDIR is =
=3D=20
>>> actually gone, %PATH doesn't get cleaned up, services may not have =
been =3D=20
>>=20
>>> cleaned up. I have a list of things I check, and 80% of the time I =
have =3D=20
>>=20
>>> to manually fix them.=20
>>>=20
>>=20
>> This too...=20
>>=20
>>> No fast alter if there's an opaque data type.=20
>>>=20
>>> You can't have fast alters that the engine doesn't know how to =
convert=20
>> "on=20
>> the fly".=20
>> I can understand that this may cause issues, but it's a downside of=20=

>> extensibility...=20
>>=20
>>> Building a data management by fragmentation scheme (age off old data =
by =3D=20
>>=20
>>> dropping fragments). You can't have RI turned on, can't have primary =
=3D=20
>>> keys, I can't recall all of the things I had to work around on that =
one,=20
>> =3D=20
>>> but it took a couple of months.=20
>>>=20
>>=20
>> Would need more details. And there were some bugs... One limitation =
is that=20
>>=20
>> you can't have a unique index using the same fragment schema if the=20=

>> fragmentation column is not contained in the index. This affects =
other=20
>> databases besides Informix and has technical reasons...=20
>>=20
>>> There is all this "new" stuff, but it no longer seems to be fully =3D=20=

>>> thought through.=20
>>>=20
>>=20
>> I suppose you have some valid points, but you also point out things =
that=20
>> are=20
>> simply not possible. I could mention others... raw tables in MACH 11=20=

>> environments etc.=20
>> Some things are a natural consequence of using some more advance =
features.=20
>>=20
>>>=20
>>> I love that building an index updates statistics=20
>>>=20
>>>=20
>> I think we all do :)=20
>> --=20
>> Fernando Nunes=20
>> Portugal=20
>>=20
>> http://informix-technology.blogspot.com=20
>> My email works... but I don't check it frequently...=20
>>=20
>> --0016e68e80269aff6a04a3158fb5=20
>>=20
>>=20
>>=20
>>=20
> =
**************************************************************************=
*****=20
>>=20
>> Forum Note: Use "Reply" to post a response in the discussion forum.=20=

>>=20
>>=20
>>=20
>>=20
> =
**************************************************************************=
*****=20
>> Forum Note: Use "Reply" to post a response in the discussion forum.=20=

>>=20
>>=20
>=20
> --=20
> Fernando Nunes=20
> Portugal=20
>=20
> http://informix-technology.blogspot.com=20
> My email works... but I don't check it frequently...=20
>=20
> --001636ef0da8747d6604a31626e9=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=

>=20

Messages In This Thread

• 10 Years of Innovation at IBM
  Jerry Keesee -- Tuesday, 10 May 2011, at 4:05 p.m.
  • RE: 10 Years of Innovation at IBM
    Joerg Volz -- Tuesday, 10 May 2011, at 4:27 p.m.
    • RE: 10 Years of Innovation at IBM
      amarini@fazenda.ms.gov.br -- Tuesday, 10 May 2011, at 8:33 p.m.
  • Re: 10 Years of Innovation at IBM
    Art Kagel -- Tuesday, 10 May 2011, at 4:56 p.m.
    • Re: 10 Years of Innovation at IBM
      rroussey@comcast.net -- Wednesday, 11 May 2011, at 8:54 a.m.
  • RES: 10 Years of Innovation at IBM
    Celso Cabral Coimbra -- Wednesday, 11 May 2011, at 10:18 a.m.
    • Re: 10 Years of Innovation at IBM
      Art Kagel -- Wednesday, 11 May 2011, at 10:36 a.m.
      • RES: 10 Years of Innovation at IBM
        Celso Cabral Coimbra -- Wednesday, 11 May 2011, at 11:01 a.m.
        • Re: 10 Years of Innovation at IBM
          Fernando Nunes -- Wednesday, 11 May 2011, at 11:07 a.m.
          • RES: 10 Years of Innovation at IBM
            Celso Cabral Coimbra -- Wednesday, 11 May 2011, at 11:20 a.m.
            • Re: RES: 10 Years of Innovation at IBM
              John Miller iii -- Wednesday, 11 May 2011, at 11:43 a.m.
              • Re: RES: 10 Years of Innovation at IBM
                Fernando Nunes -- Wednesday, 11 May 2011, at 11:55 a.m.
        • Re: 10 Years of Innovation at IBM
          Art Kagel -- Wednesday, 11 May 2011, at 11:31 a.m.
  • Re: 10 Years of Innovation at IBM
    Peter_Logan@spartanstores.com -- Wednesday, 11 May 2011, at 11:06 a.m.
  • Re: 10 Years of Innovation at IBM
    Fernando Nunes -- Wednesday, 11 May 2011, at 5:07 p.m.
  • Re: 10 Years of Innovation at IBM
    Obnoxio The Clown -- Wednesday, 11 May 2011, at 5:50 p.m.
  • Re: 10 Years of Innovation at IBM
    Jack Parker -- Wednesday, 11 May 2011, at 10:37 p.m.
    • Re: 10 Years of Innovation at IBM
      Fernando Nunes -- Thursday, 12 May 2011, at 6:00 a.m.
      • Re: 10 Years of Innovation at IBM
        Jack Parker -- Thursday, 12 May 2011, at 7:41 a.m.
        • Re: 10 Years of Innovation at IBM
          Fernando Nunes -- Thursday, 12 May 2011, at 11:08 a.m.
          • Re: 10 Years of Innovation at IBM
            Madison Pruet -- Thursday, 12 May 2011, at 11:34 a.m.
            • Re: 10 Years of Innovation at IBM
              Fernando Nunes -- Thursday, 12 May 2011, at 11:50 a.m.
              • Re: 10 Years of Innovation at IBM
                Jack Parker -- Thursday, 12 May 2011, at 12:08 p.m.
  • Re: 10 Years of Innovation at IBM
    VICTOR VAT -- Thursday, 12 May 2011, at 11:44 a.m.
    • Re: 10 Years of Innovation at IBM
      Art Kagel -- Thursday, 12 May 2011, at 12:12 p.m.
      • Re: 10 Years of Innovation at IBM
        VICTOR VAT -- Thursday, 12 May 2011, at 12:37 p.m.
  • Re: 10 Years of Innovation at IBM
    FRANK -- Friday, 13 May 2011, at 5:27 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.