Thanks for the input. Just a brainfart on my end. I have a script that checks every 10 minutes to ensure the engine is online. However, it doesn't...

Darren_Jacobs@carmax.com

08-26-2005 05:16 PM
Darren_Jacobs@carmax.com

I'm getting the following errors in the log when attempting to restart the engine after the server crashed. It appears it gets to a point in...

Darren_Jacobs@carmax.com

08-26-2005 04:56 PM
James Maes

hello in each DB, there is a syscolumns table. one of the columns in that table is called "Coltype". can someone point me to where i would find the...

tomcaml@gmail.com

08-26-2005 12:59 PM
June C. Hunt

Hi Fellows, I am looking for a tool that turns the front-end of programs 4gl to user-friendly (GUI), Somebody knows of some tool that makes this...

Guido Jimenez M.

08-26-2005 12:43 PM
Jean Sagi

Hi, I want to know how I should do to get UPDATE, INSERT, DELETE query on some specified tables, in some critical OLTP environment. Are there any...

ikb

08-26-2005 06:33 AM
ikb

We need to move an Informix Database (Standard Engine) that currently resides on a box with HP-UX as the operating system to one with SCO Openserver...

Mark

08-26-2005 04:06 AM
Martin Fuerderer

Hi I've not used Informix for seven years now - I'm rusty - please excuse my ignorance. I'm trying to restore an export, pretty quickly into the...

E

08-26-2005 03:07 AM
Dirk Moolman

Hi, I have to set up EDR on two servers: primary - SPARC Solaris 8, IDS 9.40.FC5; read-only - Intel Solaris 7, IDS 9.21.UC2. As...

dm

08-25-2005 07:16 PM
try_and_err@web.de

Hi, I had just installed Informix Advanced Server version 10.0 for Windows and was checking out the security features. I created two operating system...

anupam.mukherjee@gmail.com

08-25-2005 05:59 PM
scottishpoet

I was recently assigned to a project that uses informix (I have no previous experience). The base system is an windows box running Windows Server...

Fran

08-25-2005 05:22 PM
Fran

Just a quick note to share a problem encountered today on one of our servers. We have users that connect to an Informix database using an...

steven_nospam at Yahoo! Canada

08-25-2005 02:32 PM
steven_nospam at Yahoo! Canada

The dbspace where the indexes are being build is already full. The importation is being made whether in the dbspace datachunk or in rootdbspace. You...

Alejandro Mendoza

08-25-2005 01:39 PM
Alejandro Mendoza

I've gotten and ignored it (no interest in the NYC area or converting a system to Squeal, either). --EEM

Everett Mills

08-25-2005 11:37 AM
Everett Mills

Hello everyone. Following one of the recent threads I read about BTscanner and how it works. Then I checked its output and found out potential place...

Davorin Kremenjas

08-25-2005 09:43 AM
Davorin Kremenjas

I am on a search for an Informix DBA professional. This role is with a very exclusive global law firm in New York City. I am looking for someone in...

Database

08-25-2005 09:03 AM
Gene Sais

hello friends i work with Informix 9.4 and JDBC V3.0. My CLIENT_LOCALE and DB_LOCALE env variables are set to iw_il-8859-8. I would like to know if...

Rivka Shisman

08-25-2005 08:10 AM
Superboer

Scenario: ========= During a system reboot, our startup routines are automated and try to bring up the Informix instances. These are standard...

steven_nospam at Yahoo! Canada

08-25-2005 06:54 AM
Dirk Moolman

Hi, We are currently having problems testing a remote cold restore of an informix 7.31.TD6 database. Scenario is: server 1 running Windows 2000 SP4...

Stefan.Gabriel@nylex.com.au

08-25-2005 02:41 AM
Stefan.Gabriel@nylex.com.au

How do I determine when onpload has failed when it is run from the command line is ksh? The exit code is inconsistent. Most of the time it appears...

mils@actrix.co.nz

08-25-2005 01:32 AM
mils@actrix.co.nz

I'm about to build two indexes: 1 unique with datatype serial and 1 non-unique with datatype datetime year to second, Am I right in thinking I use...

Colin Dawson

08-24-2005 05:10 PM
david@smooth1.co.uk

We're looking at using the Microsoft patterns & practices Enterprise Library in the development of a new .NET application. The Enterprise Library...

Sean Baker

08-24-2005 05:07 PM
david@smooth1.co.uk

I've got an OLTP system that has developed poor performance. I eventually tracked it down to excessive DBSPACETEMP I/O by monitoring onstat -D. The...

Jeff

08-24-2005 05:02 PM
david@smooth1.co.uk

I'm having little luck trying to find either of the following books: Informix DBA Survival Guide (2ns Edition) - Joe Lumbley Informix Online Dynamic...

jziegler@wi.rr.com

08-24-2005 02:46 PM
jziegler@wi.rr.com

Greeting All, Since IDS 10.0.UC3 is out with many excellent features and bug fixes, does any one know if IDS 10.0 supports invalidate views if...

hariog@yahoo.com

08-24-2005 03:07 AM
hariog@yahoo.com

we get this error (Illegal SPL Routine Entry) when running dbschema but server studio will generate all procedures to a script without a problem. is...

tomcaml@gmail.com

08-23-2005 05:39 PM
Fnu Gaurav

I have a project where it is necessary for me to add an IDS9.4 server to a replicated set of servers that are running IDS9.3. Adding the server to...

rwboardley@west.com

08-23-2005 12:01 PM
rwboardley@west.com

I would like to create the ODBC data source (DSN) automaticly and found the MS tools odbcconf.exe. But the statement odbcconf.exe /a {CONFIGSYSDSN...

Martin Thole

08-23-2005 09:20 AM
Martin Thole

Art S. Kagel wrote: I totally agree with you. I'd love to move my customer to 10.00 but I fear the day when I must browse those books... Besides...

Fernando Nunes

08-22-2005 04:03 PM
Scott Stark

Hi. We converted a database running on HP-UX 11.11 from 9.21 to 9.4 without a problem, but when we ran the script to convert ER, we hit a snag. The...

caver

08-22-2005 02:39 PM
caver

We accept data in a number of languages but the client applications do not always display data correctly. I believe this is a problem with the...

Colin Dawson

08-22-2005 11:57 AM
Martin Fuerderer

I've created a routine that returns a MUTLISET so we can encapsulate a rather complicated query in a SPL. However it keeps producing an exception...

Adam Tauno Williams

08-22-2005 10:07 AM
Adam Tauno Williams

Hi, We are reengineering our existing informix 4gl environment and to determine which code is actually being run we would like to audit code being...

informix@southriver.com.au

08-22-2005 09:23 AM
informix@southriver.com.au

--0-1958201504-1124376709=:23030 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Id: Content-Disposition:...

Leona Ankrah

08-21-2005 07:44 PM
david@smooth1.co.uk

IDS 10.0FC3 on Solaris 9 I'm doing some backups to disk. An ontape backup of the 30G database with a 768k TAPEBLK takes about 25 mins, but an onbar...

Neil Truby

08-19-2005 10:37 AM
Andreas Breitfeld

We have four locations running the same apps against the same schema on the same hardware. It's an order-entry and dispatching OLTP system. Two of...

Jeff

08-19-2005 10:10 AM
Bill Dare

Still waiting for a response from IBM tech supp on this here in the UK. cf. previous posts, we're upgrading tools from 7.20 to 7.32 on HP-UX 11.11...

malc_p@btinternet.com

08-19-2005 09:54 AM
malc_p@btinternet.com

Apologies if this has been discussed before..... I'm interested in people's opinions on what they have set this parameter to for OLTP systems and...

Colin Dawson

08-19-2005 07:43 AM
Jean Sagi

Art S. Kagel replied: Many thanks for this. I have replied by e-mail but my real address is the address I use to post with "no" and "spam" removed...

Ben Thompson

08-18-2005 10:22 PM
John Carlson

Well, well I'm getting different results under IDS 10.00.TC3 under windows. with 2000 locks onstat -g seg gives:- Segment Summary: id key ...

Bill Hamilton

08-18-2005 06:48 PM
david@smooth1.co.uk

Want to sleep in milliseconds in your 4GL program ? // C function fcm_millisleep(n) int n; { int x; int valret; popint(&x);

SteFetS

08-18-2005 12:16 PM
Art S. Kagel

Hello. I'm looking for iODBC informix driver (from linux) . I'm using IDS 7.31. Where can I find it ? Thank for help gg

GG

08-18-2005 12:14 PM
Art S. Kagel

Neil, in addition to Martin's suggestion I would like to suggest an action plan for one specific tape device. The 'NSR device' parameter 'volume...

Robert Seifert

08-18-2005 09:05 AM
Robert Seifert

I need to restore informix database(IDS 7.31 in Window NT4.0) from a backup tape. Below is my problem: 1. When I'm use warm restore 'ontape...

Allen

08-18-2005 04:25 AM
Superboer

Our IDS 9.21 system has developed some performance problems lately. It used to handle the load just fine, but it's really been chewing up the CPU and...

Jeff

08-18-2005 03:06 AM
Superboer

If possible do an upgrade/test what you need to do on a lab. machine. J. -----Original Message----- From: "William Weaver" <wweaver (AT) amicus...

Jean Sagi

08-18-2005 12:15 AM
Jonathan Leffler

Hey all, We finally upgraded to UD8 about four months ago, after some fairly thorough testing. However, we're having some problems that seem to...

Anthony

08-17-2005 06:05 PM
Dave Griffen

IDS 10.0FC3 on Solaris 9 I'm trying to do a redirected restore as per the instructions...

Neil Truby

08-17-2005 04:48 PM
Bill Dare

I'm running Informix 7.31 TD2 on win xp and I'm trying to run a select and I get the following error: 264: Could not write to a temporary file. 131:...

dan.tofan@gmail.com

08-17-2005 04:06 PM
Art S. Kagel

It's a little difficult to fully explain Makefiles here, but here are some of the basic rules: * The make utility defaults to a certain set of...

Thomas Ronayne

08-17-2005 11:29 AM
Thomas Ronayne

It seems odd that there would be a discussion on the use of DBA procedures in the manual to get around security if you don't require a DBA procedure...

Andrew Rowe

08-17-2005 02:59 AM
Andrew Rowe