Is there anything glaring that I'm missing here ? The below sqexplain output describes a query that is running slow. I've attached the ddl for the...

Floyd Wellershaus

12-01-2006 07:04 AM
Floyd Wellershaus

Greeting All, HP-UX B.11.11 U 9000/800 IDS 9.21.HC2 Though it's not an issue but it is bugging me on & off. I am sure some one here will be able to...

hariog@yahoo.com

12-01-2006 05:45 AM
TBP

Hi Guys Can any one of you help me in improving the performance of the query: SELECT DISTINCT A.BUSINESS_UNIT ,A.PROJECT_ID ...

nita

11-30-2006 10:32 PM
nita

Ooooo, you got me beat.... My rootdbs is 150MB in production. Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical...

Sebastian, Norma J.

11-30-2006 12:41 PM
Floyd Wellershaus

Hi, On Tue, 25 Nov 2003 Art S. Kagel wrote: WHY using three or more temp dbspace improve performance ? Thanks, Rein

Rein Puksand

11-30-2006 11:42 AM
Art S. Kagel

Oracle's honeymoon with users of the JD Edwards and PeopleSoft software applications it acquired at the start of 2005 is over, the UK Oracle User...

Dirk Moolman

11-30-2006 09:01 AM
Obnoxio The Clown

Hi, I'm new in these newsgroup. I habe a big problem! Our server is crashing yesterday and I can't restore the database. I copy the last backup...

Marco Schwarz

11-29-2006 11:47 AM
Art S. Kagel

So I've got this application running on AIX 5.0 Informix 9.3 I'm testing on Linux, but I've only got Informix 9.4 (uc 2 & uc 8) for Linux. We keep...

monkeybutlersband@yahoo.com

11-28-2006 07:32 PM
Art S. Kagel

Running 10.00.UC5I1 on linux With the following schema and static data i.e. I am the only user create table 'informix'.phone ( id SERIAL not...

Clive Eisen

11-28-2006 07:24 PM
Art S. Kagel

Ladies and Gentlemen: I'm kind of working in the blind without my Ron Flannery book, or my six metric tons of other references. They'll be here in...

Rob Konikoff

11-28-2006 07:14 PM
Art S. Kagel

Christine Normile said: But I guess it didn't satisfy you? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine...

mark.scranton@gmail.com

11-28-2006 06:37 PM
Art S. Kagel

Hi: Calling ALL INFORMIX GURUS, how could I convert existing massive database of close to 25 Million rows which is sitting as en_US.819 to en_US.utf8...

chetan.anand@gmail.com

11-28-2006 06:24 PM
Art S. Kagel

Look at ORDER BY row This may be a new reserved word (have not looked for the list of new reserved words in 9.40). MW -----Original...

11-28-2006 06:16 PM

Hey everyone. We're having a problem with slow connections to a 9.3 database I recently inherited. The system is basically an OLTP but they have...

brian.fink@xerium.com

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

Trouble restoring database on test system (IDS 9.40.HC3 on HP-UX 11i (11v1) Yesterday when I was restoring the production database on...

jda

11-28-2006 02:15 PM
Christine Normile

Ladies and Gentlemen: New question... IDS 7.2, HPUX 11 SQL 7 Customer situation: Table with numbers stored in a CHAR(7) field. A few of...

Rob Konikoff

11-28-2006 12:05 PM
Rob Konikoff

Hi all, In informix, how do we define a big table? In other words, normally a big table should have how many rows? I have a table that consists of...

Henry

11-28-2006 11:43 AM
Christine Normile

Problem This article describes how to disable parallel clearing of the physical and logical logs on the secondary of a HDR pair during its logical...

Andrew Ford

11-28-2006 10:57 AM
TBP

MI5-Victim (AT) mi5 (DOT) gov.uk said: I can't imagine WHERE they get that idea from... -- Bye now, Obnoxio "I don't read newspapers anymore...

Obnoxio The Clown

11-28-2006 10:08 AM
Obnoxio The Clown

Are there any training institues in India for Unidata/ Universe database?

sakthi

11-28-2006 06:28 AM
scottishpoet

Hi to all. I have problems to unload/load a table to set extents correctly (I have table with more than 500,000 records and more than 100 extents)....

Diego Morales

11-28-2006 04:04 AM
Diego Morales

export and import is the only way :-( in place change of the data is impossible.

Model-Bosch, Tilman

11-28-2006 02:38 AM
Model-Bosch, Tilman

This is a repeat of a problem I posted a couple of months back. Searching for inspiration really. IBM Informix Tech Support says it's a network...

Neil Truby

11-27-2006 08:34 PM
Sebastian, Norma J.

Hi! We have a strange problem connecting from a windows client through ODBC to an Informix SE on a SCO Openserver 6 server. Situation: Server: SCO...

giacomoscoccia@gmail.com

11-27-2006 07:54 AM
giacomoscoccia@gmail.com

Hi - i need help, the Output form "oncheck -pt my_database:mytable" is: TBLspace Report for my_database:informix.mytable Physical Address ...

hoffiman@googlemail.com

11-27-2006 07:11 AM
hoffiman@googlemail.com

Hi Gurus out there! Using IDS 10 on Sun Solaris 10. I have a question about Informix performance when using a dedicated temporary dbspace (properly...

Rupan3rd

11-27-2006 07:00 AM
Rupan3rd

Good Morning, i have to unload a database table while processing a stored procedure called by a database trigger (table name is passed as...

spilker

11-27-2006 02:42 AM
Claus Samuelsen

I am currently thinking about my future. I want to find a challenging position that would fit my skills. If you have anything or know of anything...

bozon

11-25-2006 07:29 PM
bozon

Good morning/evening, We have installed IDS 10.00.UC4 on a Linux box, RedHat Enterprise ES v4. The server has 8Gb RAM and 4Gb swap. IDS uses...

philippe

11-25-2006 08:26 AM
westoreys

Hi, Next query: "SELECT data.code1, data.code2, "D" AS flow, "151/501" AS class, data2.group AS class1, data3.t_code AS class2, Sum(mb_data.deebet)...

Rein Puksand

11-25-2006 06:13 AM
Claus Samuelsen

Hi, we 've installed 4GL development 7.32.UC2 on suse linux 10.1. i4gl -v 7.32.UC2 gcc --version: 4.1.0(SUSE linux) compiling a simple program we...

nowzamani@zv.fh-koeln.de

11-24-2006 01:10 PM
Eric Rowell

Solaris 9 IDS 10.00 FC4 Compiling, linking and registrating ER checksum routines done without a problem (on both primary and target) But, when using...

Davorin Kremenjas

11-24-2006 03:02 AM
Davorin Kremenjas

this is what i got!!!! ========================================================= from the online log: Wed Nov 22 23:20:46 2006 23:20:46 Event...

alias shaari

11-23-2006 02:46 PM
Andreas Legner

For some testing purposes I have to load and basically administer a DB2 Version 8.2.5 instance on a Solaris 10 Server. Because I have no clue with...

Habichtsberg, Reinhard

11-23-2006 03:02 AM
Habichtsberg, Reinhard

My impression of the current board is that they operate like a clan or a gang. The board members themselves create and tailor rules to suit...

jpierrot@chubb.com

11-22-2006 09:06 PM
Sebastian, Norma J.

Hi to all. After 3 years working fine the performance of Informix is not fine. I want to check the query to calculate the number of extents for...

Diego Morales

11-22-2006 11:17 AM
Andrew Ford

Dear Informixers, datetime issues keep haunting me :-( What is the most economic way to convert an ESQL/C date variable to a datetime variable? I...

Richard Spitz

11-22-2006 10:19 AM
Superboer

I'm pretty new to Informix and AIX and have a bit of a problem. The Informix log is showing the error "out of shared memory segments". From the...

DLC

11-21-2006 03:50 PM
DLC

I'm currently in need of a UNIX 4GL programmer with EDI experience. The successful candidate should be able to read and understand EDI mapping...

MagdaRec

11-21-2006 02:58 PM
MagdaRec

I am writing some benchmark scripts to keep track of chunk and table IO. According to the manual, the following is true about...

Floyd Wellershaus

11-21-2006 11:49 AM
Floyd Wellershaus

Anyone using HP's Continuous Access product on their XP as their High Available/Disaster Recovery solution? Good? Bad? Don't...

Jerry Hamilton

11-21-2006 08:47 AM
Jerry Hamilton

http://flying-rugs.com/project-management

pm

11-20-2006 11:17 PM
pm

Help! I posted this in the public MS SQL-Forum, but noone answers, perhaps the problem is at the Informix-Server. I'm trying to create a simple...

Benedikt Ries

11-20-2006 11:04 AM
Traveller

This is kinda wierd, i have few aplications in java tha what basicly do is drop a table, create the table (instad of using "delete from table", i do...

berso

11-20-2006 10:44 AM
Superboer

Depending on your hardware/software and the over all sizes of the arrays you are dealing within this may not be an option. On 11/20/06, Aleksander...

Tam O'Shanter

11-20-2006 10:32 AM
Superboer

I'm very new to Informix and I was wondering if anyone had any tips on running cursors in Informix. What software will I need on my...

slandry11@gmail.com

11-20-2006 10:02 AM
Art S. Kagel

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-20-2006 09:55 AM
Art S. Kagel

Hello, I am about to choose the hardware platform for IDS server on Linux. I am used to HP Proliants regarding Intel and AMD based hardware, so...

darko

11-20-2006 07:20 AM
darko

hi , I am gettting this error. Any body having any idea.... 2:42:54 Checkpoint Completed: duration was 0 seconds. 02:42:54 Checkpoint loguniq...

doitman

11-19-2006 05:53 PM
Gentsch, Sam

Hi, Are there any tools in the market which can parse through 4GL code and produce flowcharts/decision control diagrams? TIA

warm_iiug@yahoo.com

11-18-2006 06:21 PM
Andrej Falout