Anyone care to comment on the output below. The waits seem excessive for threads 14 and 141. Unfortunately this version of IDS 9.40FC5 does not...

Mark

01-20-2005 06:54 AM
Mark

hi, how can i know the number of transactions on a database in a given period (for example 1 day) ???

__toto

01-20-2005 01:46 AM
Willem Roos

Hi Bill! You need to download and install the Informix Client SDK for Windows on the client machine. Look for Informix CSDK in the downloads section...

likvid

01-20-2005 12:32 AM
likvid

It was recently brought to our attention that there has been an issue with email messages being sent to software (AT) iiug (DOT) org. In some...

June C. Hunt

01-19-2005 09:26 PM
June C. Hunt

This thread is actually a continuation or actually an underlying problem of a previous thread I posted yesterday "IDS 9.40 UC5/linux update...

loden

01-19-2005 03:18 PM
loden

421279 I have not heard anything back from them yet...

loden@networkip.net

01-19-2005 03:13 PM
loden

IDS 9.40FC3 HP-UX hp9ux3 B.11.11 U 9000/800 (ta) Trying to track down the root cause of these errors: 14:36:53 listener-thread: err = -25580: oserr...

Kennedy, Randy

01-19-2005 12:41 PM
asheesh rastogi

This would be great to see in Informix: Row Aggregates and the Compute Clause The SQL Server COMPUTE clause is used to generate row...

tomcaml@yahoo.com

01-19-2005 12:08 PM
scottishpoet

In the field clause of an SELECT statement one can call a SPL such as - SELECT .... p_get_ref_cost("ME", xr_oem_code, xr_oem_partcode) as...

Adam Tauno Williams

01-19-2005 08:55 AM
Adam Tauno Williams

Hi everyone, I have observed that problem: 02:04:14 Lock table overflow - user id 1, session id 9425 02:04:14 Lock table overflow - user id 1,...

LUQUE Valdivia Omar

01-19-2005 03:58 AM
Martin Fuerderer

Hi, In order to get a shared lock (using cursor stability in a transaction) on a particular row is it necessary to use "select * from...

abhishek

01-18-2005 07:43 PM
Art S. Kagel

Greetings all, The various postings I have observed in this group have proven to be very helpful (as I am a novice Informix database...

Kyle

01-18-2005 02:53 PM
Kyle

I have scripts that use the unix here document mechanism to do a simple query using isql. i. e. isql finance <<EOF unload to...

ccwallin

01-18-2005 02:27 PM
ccwallin

On the Windows XP, I install IDS(IIF_9.40.TC5_w2k_tl.zip) , and everything is OK. Then I install CSDK(CSDK.2.81.TC1.WIN.zip), success too. But, when...

ikb

01-18-2005 10:37 AM
ikb

I received today an email from "Informix Marketing" directing me to the ICON programme webite at http://www.informixconnect.com/icon for the...

Neil Truby

01-18-2005 08:46 AM
Data Goob

Hi Andy. Taking Dirk's suggestion a bit further, firstly create a FIFO file in Unix using mknod or mkfifo, then start up an awk script reading from...

Andy Kent

01-17-2005 08:06 AM
Andy Kent

Data Goob wrote http://www.timeout.com/film/review.php?id=71958&redirect=true Or watch it on http://www/homechioce.co.uk IT IS about teenage sex in...

Colin Bull

01-17-2005 03:37 AM
Colin Bull

Washington Area Informix and DB2 User Group meeting Date: Thursday, January 27, 2005 Time: 9:00-5:00 Location: IBM, Bethesda offices. Building 6710,...

Lester Knutsen

01-16-2005 05:35 PM
Lester Knutsen

I'm using VB6 and Informix 5 on Solaris. I have a table with a column named TimeIn of type "datetime hour to second". I get a Runtime error '3146',...

Jak

01-14-2005 12:20 PM
Jak

rotor wrote: Hello, your session memory leak is occuring in various pools (ralloc/opentable/fragman ...). From my experience this indicates...

Steffen Herold

01-14-2005 11:41 AM
Alexey Sonkin

Hi, I'm an experienced Informix db admin. The company I work for purchased a system that uses Oracle for its backend a few years back. I need some...

Gregg Walker

01-14-2005 09:56 AM
Gregg Walker

hi, i refine my question : Host1 is under Aix 5.3 / IDS 9.40 the DB is DB_1 Host2 is under Aix 5.1 / IDS 7.31 the DB ids DB_2 i want to transfer...

__toto

01-14-2005 08:36 AM
__toto

I have been trying to find a way to insert less than the maximum number of characters into an LVARCHAR column using SPL or 4GL and there doesn't seem...

Bill Dare

01-14-2005 07:55 AM
Bill Dare

Greetings, We are on Infx 9.40 FC3. Does anyone know if there are plans for a future version to implement multiple triggers per table? Thanks in...

tomcaml@yahoo.com

01-14-2005 05:10 AM
Dirk Moolman

I was unfortunate enough once to upgrade (in-place) to an Informix version where there was a bug in the revert portion of the engine - I could not...

Dirk Moolman

01-14-2005 05:05 AM
Dirk Moolman

first create an entry in sqlhosts or modify. $INFORMIXDIR/etc/sqlhosts os whereever INFORMIXSQLHOSTS points to myserver sesoctcp ...

superboer

01-14-2005 02:32 AM
superboer

Hi, I get the following error message when i try to compile : c4gl diffusion.4gl client.c client.tcp.c pos_util.c -o diffusion.4ge Message...

Hamid HABZI

01-13-2005 09:50 PM
Jonathan Leffler

Hi Leo. In server Install Informix-NET 5. Execute sqlexecd daemon. See manual as INFORMIX-NET&STAR In client ADD USEV5SERVER in JDBC connection...

Tsutomu Ogiwara

01-13-2005 07:52 PM
Tsutomu Ogiwara

Hi , we have a VB6 DDL that execute some query on Informix IDS 9.40UC4 on Solaris 8 System. When we try to exec a select query that use a optimizer...

root

01-13-2005 02:28 PM
Fernando Ortiz

We are trying to evaluate Tunplus to accomodate data exchange between Informix 5.x and Visual Foxpro 8.0 We installed a Tunsql client for Unix OSF1...

rob smit

01-13-2005 09:21 AM
rob smit

hi, i've made a level 0 archive using ontyape on a remote filesystem TAPEDEV host2:/backup/SL0 when i try to restore the archive on host1 with...

__toto

01-13-2005 06:31 AM
Simmons, Keith

Hi, I'm newbie with informix and I have to develop a java application that will have to connect to Informix. It will be running with Informix 5 SE on...

Leo

01-13-2005 05:57 AM
Leo

We're planning on upgrading from AIX 4.3.3 to 5.1 and IDS 7.24 to 9.4 over the weekend soon. Does anyone else think this is a bit risky? I recall...

Olaf Gustafson

01-12-2005 06:15 PM
Olaf Gustafson

Isn't Unix great ? :-) -----Original Message----- From: owner-informix-list (AT) iiug (DOT) org On Behalf Of Doug Lawry Sent: 12 January 2005...

Dirk Moolman

01-12-2005 12:45 PM
Dirk Moolman

Well, kaio has a specific purpose - you might alleviate one problem but cause another - you can only do some performance tuning, and when that fails...

Dirk Moolman

01-12-2005 12:39 PM
Dirk Moolman

hello all! I try to define a new replicate using cdr define repl and I receive next error in online.log: 11:14:06 CDR Queuer: rqmQueueTxn...

cristizaharioiu

01-12-2005 09:48 AM
Madison Pruet

The question is not really clear; what is the problem; is it slow due to seq scans?? try to get a explain and analyze it or when the program...

superboer

01-12-2005 05:20 AM
Dirk Moolman

hi, can anyone explain me what are the benefits of running informix with Aix 5.3 and the 64 bits kernel ? what will change in the everyday life...

__toto

01-12-2005 03:59 AM
Martin Fuerderer

ids v9 what do you think to the theory that turning off kaio might relieve a cpu-bound system?

The Harlequin

01-12-2005 01:26 AM
Madison Pruet

Does anyone have any information of Informix's implementation of .net for visual basic. I can not seem to find much from IBM about it and not enough...

bodidley

01-11-2005 02:59 PM
SteFetS

Hi all, I have a customer with a "how long can a database name be?" question. The story is they have a standard engine, and lots of small...

Sebastian, Norma J.

01-11-2005 02:33 PM
malcolm weallans

Hi everybody! we tried to increase the size of SHMVIRTSIZE previously it was 94000 and SHMADD 8000 I tried to change SHMVIRTSIZE to 110000 and got...

sshumilov@gmail.com

01-11-2005 02:27 PM
TBP

I am attempting to create a runner with the following conditions.. AIX: 5.3 GCC: 3.3.2 RDS: 7.32 IDS: 9.40 have created my personal cfglgo...

toonsez

01-11-2005 12:05 AM
Jonathan Leffler

hello all can someone point me to where i find info on Generating the Information Schema Views / Accessing them ,etc in the docs? i would like to...

tomcaml@yahoo.com

01-11-2005 12:02 AM
Jonathan Leffler

When does IBM plan to support kernel AIO for Linux? The kernel aio patches for pre-2.6 kernels have been available for quite a while, and Linux 2.6...

Red Valsen

01-10-2005 10:21 AM
Sandor Szabo

Hello, Can someone help me with the following problem ? IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line -- Up 01:58:29 -- 245760...

Richard Roe

01-10-2005 09:37 AM
Richard.Roe@caramail.com

--- BEGIN WORK.... -- $DECLARE sel CURSOR WITH HOLD FOR SELECT f INTO :f FROM lvo; ------------------------^^^^^^^^^^ ..... -- $EXECUTE IMMEDIATE...

superboer

01-09-2005 12:11 AM
Jonathan Leffler

Hello All, I started to play with Informix recently and experienced following problem. The server IDS I installed on Windows 2000 host....

Grzesiek M

01-08-2005 08:52 PM
Captain Pedantic

I have a foreign key question. The manual and I are having a disagreement. THis is IDS 9.3 create table cow foo char (5), bar char (10), bas char...

dthacker@omnihotels.com

01-08-2005 04:47 AM
Claus Samuelsen

-------------------------------------------- A VERY HAPPY NEW YEAR - 2005 TO ALL OF YOU -------------------------------------------- IDS...

Hari Gupta

01-07-2005 02:03 PM
Neil Truby