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

 Up
  Ontape restore hangs         


Author: Doug Lawry
Date: Sep 21, 2008 03:33

Hi everyone.

IDS 11.10.FC2 on SUSE 10.1. Migrating development instance to another server
and storage array (same OS, version and onconfig). 130GB uncompressed ontape
backup made on old system will not restore on the new machine. Standard
output stops after listing the dbspaces. Message log stops on first
checkpoint after starting physical restore. Process running but nothing
further happening 5 hours later.

Tried both restore from directory device (ontape -p -d) and piped
(ontape -p -t STDIO). No different with "-r" instead of "-p". TAPEBLK 32,
TAPESIZE 0, ulimit unlimited. Shared memory checked clear beforehand using
"ipcs". No error messages other than the following which we always get on
startup (100 x 20MB logical logs):

WARNING! Logical log layout may cause Dynamic Server to get into
a locked state. Recommended smallest logical log size
is 16 times maximum concurrent user threads.

Worked around the problem using dd | rsh | dd and instance started fine on
first attempt, so dbspaces (or anything other than ontape) not the problem.
Show full article (1.29Kb)
2 Comments
  Project Management 2.0 !         


Author: project manager
Date: Sep 20, 2008 17:18

no comments
  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)
30 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
1 Comment
  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
1 2 3