Heck, I'm doing Hadoop/HBase cause its bleeding age, and its fun. You do realize that those at IBM that still champion IDS are not going to do...

Ian Michael Gumby

02-05-2010 07:36 PM
Ian Michael Gumby

On 2 Feb., 14:53, Superboer <superbo... (AT) t-online (DOT) de> wrote: Nice idea :-) Looking at the financial results of IBM Information Management...

eherber

02-05-2010 07:20 PM
fandelau

I would like to populate a bunch of tables in database 'B" with consistent data from similar tables in database 'A'. Database 'A' is the secondary...

pretzel

02-05-2010 06:53 PM
pretzel

Thank you both Art and Eric for your input on informix Mirroring. have a great day. --Dave On Wed, Feb 3, 2010 at 3:57 PM, Art Kagel <art.kagel...

Dave

02-04-2010 05:37 PM
Fernando Nunes

All, in a recent post on IIUG forum (http://www.iiug.org/forums/ids/ index.cgi/read/18706) Art and others explained why it's important to run update...

Davorin Kremenjas

02-04-2010 10:53 AM
Davorin Kremenjas

Advanced DataTools is pleased to announce that Art Kagel joined the company as a Principal Database Consultant on January 4, 2010. Art brings...

Lester Knutsen

02-03-2010 12:32 PM
eherber

Ruby/Informix is a library for connecting to an existing Informix database using the Ruby programming language. The core of this library is written...

Gerardo Santana Gómez Garrido

02-03-2010 03:15 AM
Davorin Kremenjas

I need to know if is possible build a load job with deluxe with no conversion. I know that it is possible only by one direct insert or update on...

Peternt

02-02-2010 10:33 AM
Peternt

Hello A developer is asking about Web Logic and their documentation and how that relates to informix and the database statement caching. here is what...

Tom Lehr

02-01-2010 04:45 PM
jrenaut

I have some tables that have effective and expiration dates. Once in a while someone manages to create records with overlapping dates...

brenddie

02-01-2010 02:50 PM
brenddie

Hi My situation: 1. I use MACH11 with IDS 11.50FC5W2 on Sun Solaris On Secondary server UPDATABLE_SECONDARY 0. 2. On SDS server assert and server...

zaiets.komus@gmail.com

02-01-2010 02:07 AM
zaiets.komus@gmail.com

Didn't see that anyone posted this in the...

John Carlson

01-31-2010 03:18 PM
Ian Michael Gumby

shmat: : out of available data space, check system memory parameters (e.g. MAXMEM). I found documentation on how to change the SHMBASE parameter for...

brenddie

01-29-2010 11:40 PM
brenddie

Hello, if I start the following SQL script with dbaccess I get an error message. UPDATE fyar2sta Set BEWPRS=73,62 Where Sa=0 and Artikel...

Ralf Hackmann

01-29-2010 01:43 PM
Jonathan Leffler

Hi, We have an immediate requirement for different Location in india Interested candidtes can send in their profiles to mamta (AT) jobworldindia...

mam

01-29-2010 03:13 AM
mam

I used to have a link to the old Informix website I could use to tell if a version of IDS was 32-bit or 64-bit. Now that was a long, long time ago...

Cats

01-28-2010 01:52 PM
Surfer!

IDS 11.5 FC5 Linux x86 I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. It didn't...

Laurie Gustin

01-27-2010 04:46 PM
jrenaut

I'm attempting to set up access to an Informix-SE database on a Sun server from a Web server running Apache/PHP on CentOS. So far, I'm having no...

Hultgren, Walt

01-22-2010 09:44 AM
Superboer

After migrating to ids11.5FC5 and back to old versio 11.5FC3 due to some bug. database 'sysadmin' table : ph_run & ph_alert grow very fast,...

joe

01-22-2010 05:02 AM
theBP

Hey All, I'm an informix noob and I'm having some problems trying to UNION two tables due to some date/time fields. One table had a DateTime and...

J. Hart

01-21-2010 01:33 PM
J. Hart

IDS 11.5FC6 on RHEL 5.2. We're getting a warning, or maybe error, each time we start one of the many instances on this server. requested number of...

Neil Truby

01-21-2010 11:48 AM
Art Kagel

While doing some changes to the onconfig file I noticed that the SHMNOACCESS parameter is set to what seems to be garbage text: RESIDENT ...

brenddie

01-21-2010 06:15 AM
Ian Michael Gumby

hi all how can one see the last time statistics were update for a view? or does it just relate back to when the tables within the view were last...

Tom Lehr

01-20-2010 09:54 AM
Art Kagel

How can I get/monitor session environment variable information from the Database? We are using IDS 11.50.FC4. Specifically, I would like to see...

Dave

01-19-2010 11:55 AM
Informix DBA

I'm a MS SQL guy and brand new to Informix. I'm trying to find a status time in minutes and I can't seem to figure it out. Select...

J. Hart

01-19-2010 09:29 AM
J. Hart

Hello all after altering the next extent size of a table, is it recommended to run update stats over the table? thanks tom

Tom Lehr

01-19-2010 08:49 AM
Art Kagel

Greetings, Can someone define or point me to a document that defines all of the output from the onstat -g ses session_id command? Specifically, I...

Tom

01-19-2010 08:48 AM
Art Kagel

Hi We get the following compiler error when trying to create an Informix table with a member consisting of a 2-dimensional array using 4GL. Is...

David Reed

01-19-2010 08:39 AM
Art Kagel

But I can build a cluster of Hadoop/HBase machines and set up a DW in less than 8 days! (Ok, assuming that the machines are already built and are...

Ian Michael Gumby

01-18-2010 06:24 PM
Ian Michael Gumby

Folks, Advanced DataTools is hosting a series of Webcasts on Building a Data Warehouse with Informix. The first one is scheduled for next Tuesday...

Lester Knutsen

01-18-2010 05:49 PM
Lester Knutsen

You have no error/exception handling in your procedure. Look at the ON EXCEPTION and RAISE EXCEPTION SPL statements. You have to perform a ROLLBACK...

Art Kagel

01-18-2010 03:51 PM
Art Kagel

We have IDS 9.40. I am trying to put a lock on the order based on the certain criteria(order source) When the order is created with that criteria,...

Gentian Hila

01-18-2010 02:24 PM
Gentian Hila

Hi to all, I faced an optimizer problem in Informix. Why does Informix _not_ use an index which would increase the performance very much? The...

Mathias

01-15-2010 07:42 AM
Mathias

Does anyone know how often the Live data gets pushed into the Saved Data within OAT's SQL Explorer? I've been playing with it for a few days. I've...

Nick

01-14-2010 05:02 PM
brenddie

Hello, I must change a value of a field acording to the value of an other field in >8000 records. The relation wich fields must be changed with...

Ralf Hackmann

01-12-2010 06:37 AM
Art Kagel

* Clown tires of thankless task. * Er, that's it. -- RGB

RedGrittyBrick

01-12-2010 04:20 AM
Bogdan BOTEZ

Hi, If anyone wants to know if archecker works or not, I can categorically say YES! One of my team just dropped a table with 4 years of data in...

Jarrod Teale

01-08-2010 12:45 AM
Jarrod Teale

Hi all, We have moved our Informix Database ( 11.x on RHEL 5 ) to SAN VMAX and we have enabled SRDF on SAN. We were told by Vendor that when...

sdhaya

01-07-2010 02:34 PM
david@smooth1.co.uk

Hello at all, I have a windows system (2003 server sp2) with installed informix odbc driver and I have configured a DSN system named "v240" with a...

BOB

01-07-2010 12:43 PM
BOB

I think that I have found the error. When comparing with a sysadmin database in a working instance of 11.50.XC6 I noticed that a number of tables...

Ulf

01-07-2010 09:15 AM
Ulf

All, Does anyone know if the ontape platform-dependancy was removed in or prior to 11.50.* ie: can I restore a level0 archive from a Solaris Sparc...

Lello, Nick

01-07-2010 05:00 AM
Lello, Nick

"Richard Kofler" <richard.kofler (AT) chello (DOT) at> wrote I've done that (uninstalling Java): # rpm -qa | egrep...

Fernando Nunes

01-07-2010 04:31 AM
Nothing

Hey all, Some time ago I asked if anyone had generated a script to rebuild the "cdr define" commands for replicates based on what was in the...

Jarrod Teale

01-06-2010 03:01 PM
Jarrod Teale

*ratios.shr_ak* <http://www.iiug.org/software/index_all.html#ratios.shr_ak> New Package Ratios.shr_ak provides a stored procedure and shell script...

Art Kagel

01-01-2010 08:52 AM
Art Kagel

isql version : 7.32fc2 ids version: 11.5FC3 upgrade to 11.5FC5 After upgarading to 11.5fc5. Running isql select form -> compile . It will not list...

joe

12-31-2009 08:48 AM
theBP

Hello, in the odbc control panel in windows, i go to the connection pooling tab (not sure in english how it shows to you), i double click on IBM...

eferreyra

12-29-2009 08:54 AM
eferreyra

Hi, I have two identical database installations in two identical machines. Is it possible restore one dbspace from one machine to another...

HFS

12-27-2009 07:55 PM
Beau Nanaz

We have our Informix Database ( version 11.x) running on our Primary Server and replicating the same to our Secondary and Remote Shard Secondary...

sdhaya

12-27-2009 09:30 AM
Neil Truby

Have you ever think that you also can be able to get A Free Project Management Software provided at http://www.project-drive.net/ Yes, Project Drive...

Projectdrive

12-24-2009 08:07 AM
Projectdrive

Dynamic Master/Slave Relationship within a Peer/Peer Network. As cryptic as that sounds, it will be significant in the near term future.. To Jerry...

Ian Michael Gumby

12-24-2009 06:15 AM
Ian Michael Gumby