|
|
Up |
|
|
  |
Author: Ian Michael GumbyIan 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 |
|
  |
|
|
  |
Author: TomTom
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
|
|
  |
|
|
  |
Author: mosserpmosserp
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 |
|
  |
Author: mosserpmosserp
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 |
|
  |
Author: mosserpmosserp
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 |
|
  |
Author: Habichtsberg, ReinhardHabichtsberg, 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
|
|
  |
Author: Guillermo Gómez ValcárcelGuillermo 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 |
|
  |
|
|
  |
Author: Fernando NunesFernando 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.
|
| |
|
2 Comments |
|
|
|
|
|
|