Fair but hard question :) In fact it depends on the database size and the kind of data and usage... But I assume you want numbers, so I'll risk to...

red_valsen

02-02-2012 09:49 AM
Fernando Nunes

There is an updated release of my utils2_ak package available as of 1/30. This update includes the following changes: Myschema: Shifted the...

Art Kagel

02-01-2012 06:14 AM
Art Kagel

The last weeks I discovery a behave of the engine what is something new for me. I believe others will be surprised too... IFX 11.50 FC9 When you...

Cesar Inacio Martins

01-31-2012 01:26 PM
Martin Fuerderer

Hello All Have been doing some reading about clustered indexing and wondering what experiences other folks have had with them? We currently do not...

Tom Lehr

01-31-2012 11:23 AM
Art Kagel

Why is it a bad idea to grant DBA to all developers? On one project I support, the programmers all use the same project-level account 'projectXdba'...

red_valsen

01-30-2012 07:43 PM
Jonathan Leffler

Folks, Registration is open! We are excited to announce that the next WashingtonArea Informix User Group event will be a one-day Hands on Lab on the...

Lester Knutsen

01-30-2012 05:44 PM
Lester Knutsen

hi all, one of our informix servers starting abnormally. the services on Widows starts ok but with no access to the database. one of the chunks seem...

Omar Gassama

01-30-2012 01:30 PM
Superboer

Yes. Also a properly designed application will use Optimistic Locking Protocols and not perform SELECT ... FOR UPDATE, insert, update,...

BeGooden-IT Vercelletto

01-30-2012 08:44 AM
Fernando Nunes

In case you haven't heard, the annual IIUG Conference for 2012 takes place April 22nd - 25th at a new location in San Diego, CA. Here is a sampling...

Art Kagel

01-27-2012 03:19 PM
Art Kagel

Art, The error with the cast was occurring on SELECT from a table that has a CHAR(5) or a VARCHAR or LVARCHAR with a length of 5 characters. I...

Waters, Benjamin

01-26-2012 07:03 PM
Waters, Benjamin

Ben: The DB2 driver does not understand any Informix specific types like BOOLEAN. Fortunately Informix has some built-in casts that you can...

Art Kagel

01-26-2012 06:49 PM
Art Kagel

Art, I think you may be missing my problem. My issue is not in selecting the Boolean. In ODBC and DRDA they are selecting fine, it is doing the...

Waters, Benjamin

01-26-2012 05:17 PM
Waters, Benjamin

hello all the manual states "This mode denies other processes both read and write access to the table". Does it also affect the dynamic allocating ...

Tom Lehr

01-25-2012 04:42 PM
Tom Lehr

Art, Based off you feedback I have tried a few things to try and get this to work with no success. I have tried making the parameter object have a...

Waters, Benjamin

01-25-2012 01:46 PM
Waters, Benjamin

LinkedIn ------------ floyd wellershaus requested to add you as a connection on LinkedIn: ------------------------------------------

floyd wellershaus via LinkedIn

01-25-2012 09:19 AM
floyd wellershaus via LinkedIn

Great! To make life a bit easier (so you don't have to change INFORMIXDIR or PATH in any users profile or in various scripts and cron jobs, make...

Malc P

01-24-2012 10:18 AM
Art Kagel

Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.

red_valsen

01-23-2012 12:50 PM
Fernando Nunes

Hello, We are being asked to archive off some data from very large tables. They want to keep 2 years worth in the main table and move the rest to...

Floyd Wellershaus

01-22-2012 03:03 PM
scottishpoet

Folks, Save the date, we are excited to announce that the next Washington Area Informix User Group event will be a one-day Hands on Lab on the...

Lester Knutsen

01-20-2012 01:57 PM
Lester Knutsen

I'd like to expand on Jack's comment and the 'it depends' comment. If all your queries include a date (dss and oltp), then fragmentation by date is...

Scott Lashley

01-18-2012 12:23 PM
Scott Lashley

Would normally simply test this but I don't have my test system at present due to hardware failure, and I'm not going to have it for a few...

Cats

01-12-2012 10:09 AM
Cats

Hi Folks, I have to move around a terabyte of a blobby table (not TEXT or BYTE) to another machine. I'm trying without success to make the HPL...

aclarke

01-11-2012 01:23 PM
Art Kagel

Hi, I have problems understanding how informix handles utf locales and specifically collations. I have a few en_us.utf8 databases but want to order...

Kamenik, Aleksander

01-10-2012 06:08 AM
Kamenik, Aleksander

Five minutes after my data warehouse project's weekly ETL script for its logged database completed, an assert failure occurred and the informixserver...

red_valsen

01-08-2012 03:08 AM
Jon Ritson

Over complicated things: select ( select MAX(t1.col1) from table( set{t0.zipcode::integer, t0.customer_num::integer} ) t1(col1) )...

Tom Lehr

01-05-2012 09:12 PM
Fernando Nunes

Please see below, and contact me on careers at ardenta dot com if you are interested. Thanks M DBA who is also a competent Linux/UNIX sysadmin...

Mary Whittington

01-05-2012 07:42 PM
Mary Whittington

Hi all, we have running in a lot of trouble with 64 bits OS servers and desktops that are clients of IDS11.5x This servers have several applications...

eferreyra

01-04-2012 10:23 AM
Rajendra H Kamath

The DRDA driver suite infact has two drivers underneath, the recommendation is to use the DB2.NET driver (supports Informix as well...

eferreyra

01-04-2012 09:22 AM
Art Kagel

LinkedIn ------------ June Nebab requested to add you as a connection on LinkedIn: ------------------------------------------

June Nebab via LinkedIn

01-03-2012 01:16 PM
June Nebab via LinkedIn

Hello, Does anyone have a list of the current possible values for the sysmaster:sysseglst table for the seg_class column? I searched through...

Dave

01-03-2012 04:46 AM
Stuart Brooks

hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are...

Tom Lehr

12-30-2011 11:52 AM
mpruet

Hi We're looking at reducing TCO and want to check the full spec for Innovator-C; all we can find so far is the Overview page...

Malc P

12-28-2011 11:15 AM
Malc P

I have uploaded a new version of utils2_ak. Look for the new release to be posted to the IIUG Software Repository in a few days, the README.1st...

Art Kagel

12-27-2011 11:40 AM
Art Kagel

I am out of the office until 01/03/2012. Note: This is an automated response to your message "Informix-list Digest, Vol 305, Issue 5" sent on...

Douglas Dailey

12-24-2011 12:03 PM
Douglas Dailey

I created several informix server on a host. To monitor each server's chunk space,I have to setup environment parameter then run 'onstat -d' to check...

joe

12-23-2011 03:02 PM
david@smooth1.co.uk

LinkedIn ------------ Art S. Kagel requested to add you as a connection on LinkedIn: ------------------------------------------

Art S. Kagel via LinkedIn

12-22-2011 08:42 AM
Art S. Kagel via LinkedIn

hi all has anyone had experience with using Informix and Splunk? if so, care to share thoughts, experiences, etc thanks

Tom Lehr

12-21-2011 03:11 PM
Tom Lehr

Hi , IFX 11.50 FC9X6 , AIX 6.1 I'm trying create a simple UDR to get the current 'transaction id' with less overhead possible... To use this UDR...

Cesar Inacio Martins

12-19-2011 03:02 PM
Richard Harnden

IDS11.50.FC3 HPUX11.11 this is the error message in the online.log we have been getting WARNING! Physical Log size 300000 is too small. Physical...

howie.lfc@googlemail.com

12-19-2011 10:40 AM
Art Kagel

I am out of the office until 01/09/2012. I will be on vacation, I will check my voice mail and email daily. For urgent issues please call me on my...

Michael Pintus

12-15-2011 12:07 PM
Michael Pintus

Sounds like a network problem or perhaps the machine's NIC card (the one having intermittent dbaccess connection problems as well) is going...

Art Kagel

12-14-2011 09:49 PM
Art Kagel

Good day. Is there anybody who uses version mentioned in the title on AIX platform?

ifmx@inbox.lv

12-14-2011 09:37 PM
Jonathan Leffler

When running the command 'cdr list server' I am seeing the following error on an intermittent basis.. Error returned from...

Laurie Gustin

12-14-2011 07:49 PM
Laurie Gustin

I post this, or something very like it about once a year. It seems to be overdue. This is addressed mainly to newbies, but we are all guilty...

Art Kagel

12-13-2011 11:33 AM
Jonathan Leffler

Hallo, isql 7.50.UC1 IBM Informix Dynamic Server Version 7.31.UD10X1 (I know, it's out of support) SUSE Linux Enterprise Server 11 VERSION =...

Weitkamp Heinz

12-09-2011 10:38 AM
Jonathan Leffler

I am out of the office until 01/03/2012. I will be out of country from 12/8 thru 12/15. No email or phone. I will be on vacation at home from...

Scott Lashley

12-08-2011 12:05 PM
Scott Lashley

Hi all Having a ball here doing proof-of-concept converting our old HP-UX 4GL to see if we can run it on Ubuntu using A.N. Other vendor's...

Malc

12-08-2011 10:26 AM
Art Kagel

We're testing IDS 11.70.FC3 on RHEL5.7/2.6.18 for a data warehouse application, and had to turn read-ahead off due to the instance- crashing bug...

red_valsen

12-05-2011 05:54 PM
LIGHT SCANS

We are having an issue with idle sessions timing out after 60 minutes on our IDS 10.0 server (HP-UX 11i). I have looked through all the...

Laurie Gustin

12-05-2011 03:45 PM
Art Kagel

I am out of the office until 12/05/2011. Note: This is an automated response to your message "Informix-list Digest, Vol 302, Issue 4" sent on...

Douglas Dailey

12-03-2011 04:37 PM
Douglas Dailey