comp.databases.informix
  Home FAQ Contact Sign in
comp.databases.informix only
 
Advanced search
September 2008
motuwethfrsasuw
1234567 36
891011121314 37
15161718192021 38
22232425262728 39
2930      40
2008
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2008 2007 2006  
total
comp.databases.informix Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  Why the IDS Community should be hopping mad!         


Author: Ian Michael Gumby
Date: Sep 19, 2008 06:28

Call me a nut. I don't care.

I support all of the major databases except SQLServer, but I might
start learning it for the hell of it.
Informix wasn't my first database. Prior to Informix I dealt a bit
with 4Phase, Progress, and my own proprietary database for a fetal
anatomy study project done under an NSF grant when I was a senior in
high school and the summer before college.

But Informix caught my attention because of the elegance of its design
and the attention paid to details. Sure it had some warts, but with
each revision, the worst of them were removed.

After Phil White left the building, the next 3 CEOs were fools. Ok PG
wasn't a fool. He was a horse trader and wanted to cash out of his
investment and move on to the next big deal. You have to respect that.

Under IBM, Janet wanted to slowly kill IDS and relegate it to the same
status as IMS, something that IBM still supports today.

But the truth is that IDS is a great product. There are features in
11.5 that are still ahead of the pack and its still one of the best
general purpose rdbms on the market today.
Show full article (2.98Kb)
20 Comments
  RE: Tech Tip du Jour: Free Stanford Online Courses         


Author: Ian Michael Gumby
Date: Sep 19, 2008 06:04

Yawn.

Try MIT. They've been offering free classes online for quite some time:
http://ocw.mit.edu/OcwWeb/web/home/home/index.htm

I'm sure Marty would agree that MIT kicks Stanford's ass except when it comes to football.
;-)
(Its an inside joke. MIT doesn't have a varsity football program, its a club sport.)

-G> Date: Fri, 19 Sep 2008 07:32:07 +0100> Subject: Tech Tip du Jour: Free Stanford Online Courses> From: obnoxio@serendipita.com> To: informix-list@iiug.org; classics@iiug.org> CC: ids@iiug.org> > http://obotheclown.blogspot.com/2008/09/tech-tip-du-jour-stanford-engineering.ht...> > -- > Bye now,> Obnoxio> > http://obotheclown.blogspot.com/> > > _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008
Show full article (2.08Kb)
no comments
  Dostats error         


Author: Tom
Date: Sep 19, 2008 05:49

I started getting this error from dostats when I started using IDS
11.5.FC1. I have the same exact databases
in IDS 10, IDS 9 and IDS 7 instances and do not get the error in any
of them.

systdistold ... Cannot Update statistics for procedure: systdistold:
systdistold. SQL= -674, ISAM=0

We have no such procedure in any database.

Thanks,

Tom
no comments
  Tech Tip du Jour: Free Stanford Online Courses         


Author: Obnoxio The Clown
Date: Sep 18, 2008 23:32

1 Comment
  RE: dbcopy over secure/encrypted line         


Author: mosserp
Date: Sep 18, 2008 15:56

(sorry for the top-post)

Yeah, I can run the dbcopy in normal mode. We cannot use the -P or -U
options, because we run under privileged accts for which we do not have
the passwords (effectively, we sudo to the accts). The piece that is
missing is to be able to use a secure/encrypted connection between the
two boxes, such as using ssh. I have the keys set up between them, but
AFAIK, the data sent via dbcopy does NOT by default travel over an ssh
connection. Am I wrong? I tried to set up ssh port forwarding, but
that just seemed to hose things up when I tried to use dbcopy via
that/those ports. Maybe I just set it up wrong - dunno. That's why I
was asking if anyone had already done this.

I got some very useful suggestions re HPL & named-pipes & ssh, and will
definitely take a serious look at that route. But I'm comfortable with
and like dbcopy, and was just hoping for a simple solution using that
tool.
Show full article (12.17Kb)
1 Comment
  RE: dbcopy over secure/encrypted line         


Author: mosserp
Date: Sep 18, 2008 10:19

> From: Ian Michael Gumby [mailto:im_gumby@hotmail.com]
> Sent: Thursday, September 18, 2008 10:03 AM
> To: Mosser, Paul A.; curtis@crowson1.com; informix-list@iiug.org
> Subject: RE: dbcopy over secure/encrypted line
>
> Why not write a simple python script that has two database
connections.
> One to the old database and one to the new database?
>
> In short, you select data from one table, insert row in to new table
on
> second box.
>
> If you want better performance, then create multiple threads and do a
> table per thread.
>
> This will move your data over, never having to stage it on disk.
>
Show full article (0.88Kb)
3 Comments
  dbcopy over secure/encrypted line         


Author: mosserp
Date: Sep 17, 2008 14:50

Anyone have an ideas on how to use Art K.'s "dbcopy" utility over a
secure/encrypted line? I tried to set up port forwarding under ssh, but
am not having any luck. Anyone made this to work?

TIA,
Paul M.
9 Comments
  RE: IDS+Solaris+LDoms         


Author: Habichtsberg, Reinhard
Date: Sep 17, 2008 02:43

Hi,

we have Solaris 10 with local zones. In the local zone are running IDS
9.40FC8/FC9 instances. Not problems encountered yet, though we are not using
zfs.

On another machine we have two IDS 9.40FC9 and a IDS 11.10 instance in the
global zone of Solaris 10. Here are no local zones configured. Running
without problems.

HTH,
Reinhard.

-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of Cesar Inacio Martins
Sent: Friday, September 12, 2008 7:02 PM
To: informix-list cdi
Subject: IDS+Solaris+LDoms

Hi,

Somebody already work with Informix on Sun Solaris SPARC with LDoms
(Logical Domains)??
Show full article (1.24Kb)
no comments
  RE: Installing IDS on Mac OS X         


Author: Guillermo Gómez Valcárcel
Date: Sep 17, 2008 02:13

Carlton,

The link resource
ftp://ftp.xmission.com/pub/users/d/dbaresrc/Intro_IDS_on_Mac_V2.pdf
doesn't work. The directories under users are empty.

Thank you,
Guillermo.

-----Mensaje original-----
De: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
En nombre de Carlton Doe
Enviado el: martes, 16 de septiembre de 2008 23:27
Para: informix-list@iiug.org
Asunto: Installing IDS on Mac OS X

There was a recent post about problems installing on the Mac.
Unfortunately, most of the information contained in the post was not
as accurate as it should be. As someone who's been using IDS on Mac
since March, let me correct a few things.
Show full article (2.26Kb)
1 Comment
  For demo and flash lovers...         


Author: Fernando Nunes
Date: Sep 16, 2008 17:53

1. Access IBM TV:
http://www.ibm.com/software/info/television/index.jsp?lang=en_us&cat=infomanagem...

2. On the right side, there is a list of a lot of media titles. Scroll down
until you find several Informix titles which include:

- Mr. Ambuj Goyal (current IBM Information Management General Manager)
message about IDS 11
- A funny video explaining why you don't see much of Informix
- A flash demo of IDS 11 (overview)
- A flash demo of IDS 11 security features

You can also search for "informix" and you'll find a shorter, more direct, list
of media (flash, videos...)

I don't think Informix DBAs will jump for joy, and they certainly won't give
you great technical details, but... Use it as it pleases you.

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
2 Comments
1 2 3 4 5 6 7 8 9