Hello Friends, Any compelling reason not to use a page size on my database greater than 2K (which I understand is the default)? I have some tables...

Tam O'Shanter

11-18-2006 05:01 PM
scottishpoet

Hi, I have a problem at a clients machine, where we are getting a lot of these messages in the online.log 13:52:41 listener-thread: err = -25587:...

Dirk Moolman

11-18-2006 04:31 AM
Dirk Moolman

Hi all - first time post-ee here. I need to store .pdf files in Informix (Dynamic Server 10 on Linux) After days of futile research I am still...

debbie@diversifiedmetals.com

11-17-2006 03:28 PM
Paul Watson

Amigos listeros: Les escribo para proponerles iniciar una "comunidad iiug-esp onlline" y poder realizar las consultas y comentarios de manera mas...

Juan Pablo

11-17-2006 02:23 PM
Juan Pablo

Hi, the command for select the first 100 rows is: SELECT FIRST 100 * FROM tab ... but the command DELETE FIRST 100 FROM tab .. is not possible, and...

Michael Andreas

11-17-2006 10:24 AM
Carsten Haese

Michael Andreas wrote I'd do it in two steps: - Read in the first 100 rows - determine their primary key , store these values in an internal table...

Model-Bosch, Tilman

11-17-2006 04:15 AM
Model-Bosch, Tilman

Hello, I wonder what this means, if anyone can tell me. We have some databases that do not have transaction logging turned on. On those databases...

Floyd Wellershaus

11-16-2006 11:00 AM
Floyd Wellershaus

Hi , In ids10, sysprocedures had added lots of system stored procedure. How can I tell the difference from the stored procedure that user created or...

roger@star2000.com.tw

11-16-2006 09:34 AM
Art S. Kagel

It's taken a while but I've finally got our onstat reference pages (www.oninit.com/onstat) up to data with all the recent (ish) stuff. The V11...

Paul Watson

11-16-2006 04:23 AM
Obnoxio The Clown

Hello, We have this Solaris machine indicating high device busy times whenever the Informix application folks does a refresh operation. To...

Sylvia

11-16-2006 03:41 AM
Paul Watson

Okay, Here is a copy of the command used, the schema file used and the outup when I last ran archecker. The frustrating bit is this: Table...

Tam O'Shanter

11-15-2006 08:04 PM
Tam O'Shanter

Hi , In ids10, sysprocedures had added lots of system stored procedure. How can I tell the difference from the stored procedure that user created or...

roger@star2000.com.tw

11-15-2006 07:38 PM
roger@star2000.com.tw

Hi, I am using an ODBC connection to get user information from an Avaya (CentreVue Supervisor) system, (it's using Informix 2000). I work in a call...

jahillia@yahoo.com

11-15-2006 03:59 PM
Captain Pedantic

For my sins I've got the Informix FAQ now and I'm busy re-visiting it and trying to get it upto date. Anyone who has looked at recently will see...

Paul Watson

11-15-2006 11:41 AM
Ian Wilson

AIX 5.3, gcc compiler, IDS 10.0 FC5. Anyone come across this before in compiling dostats?: $ export INFORMIXC=gcc $ esql dostats.ec >...

Neil Truby

11-15-2006 09:44 AM
Carsten Haese

Ver: INFORMIX-OnLine Version 7.23.UC11 UNIX: 11.x Ok, we have a logged database and do our bulk data manipulation and extract jobs via cron. One...

Konikoff, Rob

11-15-2006 09:34 AM
Art S. Kagel

Hello We are running into some major walls trying to configure and use AIX 5.3 and Informix v10 with HACMP clustering and Informix HDR. AIX looks to...

tomcaml@yahoo.com

11-15-2006 05:59 AM
Brett Geer \(DHL ZA\)

Hi, I've a bit of an SQL question (for use on IDS10): I want to do an update of two columns in each row, indexed by another two columns of that row...

Tim

11-14-2006 05:45 PM
Art S. Kagel

Hello, IDS 10.0 UC5 Attempting to use archecker to do a table level restore and getting an error saying my target table doesn't exist. Wondering...

Tam O'Shanter

11-14-2006 05:06 PM
Obnoxio The Clown

Use the "raw" device, but you can just use the block device; as I read it you don't need the special raw-device anymore. You get the...

ruediger.papke@t-online.de

11-13-2006 03:17 PM
Adam Tauno Williams

Hi All, I am using IBM INFORMIX-SQL Version 7.32.FC3 and AIX 5 . Earlier i was using some older version of informix. Then i upgraded that version...

Arbind

11-13-2006 12:13 PM
Art S. Kagel

Hello, How to find sid, or ip address or machine name of client executing a query? Eleftherios Fotopoulos OBI-IT Information Services

Fotopoulos Lefteris

11-13-2006 09:09 AM
Rich or Kristín

Hi, Any one tried using MS-2005 BI product, MDX code and ROLAP with IBM Informix XPS as RDBMS ?? Hints, warnings, samples of how to do are more than...

Bjarne Wilken Jensen

11-13-2006 08:15 AM
Bjarne Wilken Jensen

onstat -g sql shows session id (SID) and database. onstat -g ses shows SID, user, process id (PID) and hostname. Type onstat -g sql SID or onstat...

Habichtsberg, Reinhard

11-13-2006 07:55 AM
Habichtsberg, Reinhard

Hi Fernando, You would like to have look on the "who-access.sh" script which can be found in the IIUG software repository. Regards, Reinhard.

Habichtsberg, Reinhard

11-13-2006 01:50 AM
Habichtsberg, Reinhard

this my onconfig file. I am using Informix Dynamic Server Version 7.31.UD6W4, HP-UX 11.11 , no of cpus- 2, REPORT SERVER (used for creating report...

madh

11-12-2006 09:25 PM
madh

OK, maybe it's not that great, but it's proved damn useful to me. IFX_DIRTY_WAIT Basically, you set it to a timeout value, and with it set, you...

Thomas J. Girsch

11-10-2006 08:03 PM
Fernando Nunes

I received the email from IIUG regarding the free IDS version available for download in the IIUG member area. They...

eric@herber-consulting.de

11-10-2006 03:40 PM
Neil Truby

We operate Symix (an older version) which still runs on Progress. When going into the main menu under vendors - then to vouchers & adjustments we...

dfisher@diequip.com

11-10-2006 02:18 PM
Obnoxio The Clown

Hello Friends, I'm looking for the reasoning in deciding on how many DB Spaces to use on a given system. Specifically, if using a SAN where disk IO...

Tam OShanter

11-10-2006 11:07 AM
scottishpoet

Hello Friends, I'm looking for the reasoning in deciding on how many DB Spaces to use on a given system. Specifically, if using a SAN where disk IO...

Tam OShanter

11-10-2006 10:45 AM
stefan@weideneder.de

Hello, Is there any way to free extents allready claimed by a table after removing data from said table? Running out of disk space for a table and...

Tam O'Shanter

11-10-2006 09:58 AM
Colin Dawson

Hi all, I am new to informix. I would like to know how to calculate the rootdbs 1) Is it (Logfiles x log size) + (PHYsical log) + some schemas...

doitman

11-09-2006 12:59 PM
Art S. Kagel

Hi, A informix-ODBC-connection wrote the errormessage: HY106:In SQLExtendedFetch, only SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY...

Michael Andreas

11-09-2006 12:49 PM
Art S. Kagel

I have just been through a DR situation on one of our customer sites that had offset 0 for some chunks. And the recovery process couldn't...

malcolm weallans

11-09-2006 11:53 AM
Colin Dawson

Hello to Everybody out there, Can any one be the medium of help in resolving the dilemma whether to opt the field of a Developer or stay as a DBA ....

meraj000@gmail.com

11-09-2006 11:39 AM
DA Morgan

Hi, Anybody is using the following settings LRU_MAX_DIRTY=1 LRU_MIN_DIRTY=1 using Informix 7.3 Engine.........7.31.FD5 / HPUX-11 Heavily used OLTP...

good_ifmx@yahoo.com

11-08-2006 06:37 PM
Fernando Nunes

Hi there, I desperately need your help. I am just trying to insert text with multilines to a char-field. We still use the very outdated version 7.2...

tom

11-08-2006 05:06 PM
Carsten Haese

Hi to all, as result of an app-error there are rows in the master-table are deleted but not the associated rows in the detail-table. In a view using...

Igo Besser

11-08-2006 01:40 PM
Ferro

Hello all! For those of you making nominations or accepting them, please make sure iiug.election (AT) gmail (DOT) com will not be blocked by your...

Gentsch, Sam

11-08-2006 01:15 PM
Gentsch, Sam

Hi ! I tried to convert some of characters to uppercase using the informix function UPPER but this does work only on English characters, does not...

Shadbasham

11-08-2006 12:16 PM
Shadbasham

Hello list. I'got a small problem with one report. I have to write a report which results is an overview about age distribution in one table I try...

emmermacher@hotmail.com

11-08-2006 12:09 PM
Ferro

Ben wrote: These strange objects with space in their name are indexes that implement unique constraints for fragmented tables. These get created...

Model-Bosch, Tilman

11-08-2006 05:09 AM
Model-Bosch, Tilman

IDS 9.4 UC4 Solaris 2.6 We are having trouble with one of our instances - the root database space 'rootdbs' keeps filling up. The problem coincides...

Ben

11-07-2006 09:20 PM
madh

Good day. Description. I have 80Gb DB on Linux, and want to onunload it to file. I've tried command "onunload -t file_name -s 100000000 db_name" but...

rotor

11-07-2006 02:34 PM
Ferro

Mathew Alexander said: Have you tried UPDATE STATISTICS? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine...

Obnoxio The Clown

11-07-2006 10:03 AM
Campbell, John \(GE Money\)

since 4gl.4ge cannot be executed if compiled with gcc version 4 I tried the following modification of the generated 4gl.c output and it seems to...

apo

11-07-2006 09:55 AM
apo

Jerry Hamilton said: ....not waste a moment talking about the bloody IIUG. :o) -- Bye now, Obnoxio "... no bill is required as no value was...

Paul Watson

11-07-2006 04:49 AM
Obnoxio The Clown

Hello, If we have an idea we believe is something good for IIUG to pursue, how do we get that idea presented? I see on the website that I can email...

Sebastian, Norma J.

11-05-2006 05:23 PM
June C. Hunt - IIUG

I would like to say....The current IIUG board is doing an amazing job! I was at IOD in October/Anaheim this year. I was at what I think was the...

Sebastian, Norma J.

11-05-2006 04:42 PM
Sebastian, Norma J.