Hi , I tried to migrate database from ids73 to ids10, I can not move data from ids73 to ids10 by INSERT ... SELECT statement. the steps that I done...

roger@star2000.com.tw

10-24-2006 04:08 AM
scottishpoet

Hi All, Don't laugh on IDS version (IDS 9.21.HC2, HP-UX B.11.11), Sorry. onstat -g ntd shows some connections "Rejected" numbers and...

hariog@yahoo.com

10-23-2006 06:56 PM
hariog@yahoo.com

Hello All, Wondering if there is a way to script a backup operation for specific tables as opposed to an entire database? Our scenario involves...

Tam OShanter

10-23-2006 02:03 PM
FRANK

Hi, We have been told by Sarbanes Oxley to tighten up our database permissions (ie revoke DBA from public !) and I have granted resource to all...

bondsfis

10-23-2006 09:37 AM
bondsfis

Dear, So far I beleived that raw device offers far better performance over cooked files. recently, I had the opportunity to install 2 instances on...

Deldongo

10-23-2006 09:08 AM
Claus Samuelsen

Hi, Need help from the folks on list regarding VLDB design. Are there any books out there that can provide the design basics for VLDB application...

asheesh rastogi

10-20-2006 10:10 AM
FRANK

Hello We are having problems with onabr and Veritas NetBackup. Our logical logs are bing backed up to tape just fine but when we try to kick off...

tomcaml@yahoo.com

10-20-2006 04:37 AM
Martin Fuerderer

Hi people !!! I have the following situation : Informix 9.40.UC6 with Big Chunks Enable Linux Red Hat 8 - kernel 2.4 1 - I done the dbexport with...

cboccio@yahoo.com.br

10-20-2006 12:14 AM
Denis.Zhuravlov@gmail.com

Hi All, We at keane (www.keane.com) have a urgent requirement for Microstrategy Consultant. Its very urgent requirement. About Keane: Keane is a...

Keane_recruiter

10-19-2006 03:10 PM
Nog

There has been debate on whether or not to turn it on by default. Some say it uses resources (CPU cycles) some say it does not make a significant...

Model-Bosch, Tilman

10-19-2006 07:50 AM
Model-Bosch, Tilman

What is the deleting sqlexec waiting for the most time? You migth use this SQL statement - select sum(cumtime), reason from...

Model-Bosch, Tilman

10-19-2006 07:38 AM
Floyd Wellershaus

Am I overlooking something here ? I just became aware that a high profile ec program is having major slowness doing deletes from a big table. The...

Floyd Wellershaus

10-19-2006 06:56 AM
Floyd Wellershaus

Hi, I would like to know some Performance Tips for Informix IDS. I am trying to debug an issue with the oninit process blocking 100% CPU utilisation....

fun-do

10-19-2006 02:42 AM
Young

Hi, I have IDS 9.3-TC1 on Win 2000 SP4. When I run the command onstat -d two dbspaces are marked as down. Is there a way to bring them...

arxngos@gmail.com

10-18-2006 04:34 PM
scottishpoet

I was doing some research to see if there was any truth in Double Enema's rumour that IDS 10 was available for download. Lo and behold, it seems that...

Obnoxio The Clown

10-18-2006 03:05 PM
Jerry Hamilton

One has to appreciate the irony of my consulting on IDS working on a new Macbook. Well ok - not running IDS on the Macbook, but it does bring up an...

mark.scranton@gmail.com

10-18-2006 11:44 AM
DA Morgan

Or perhaps a large red nose -----Original Message----- From: informix-list-bounces (AT) iiug (DOT) org On Behalf Of Obnoxio The Clown Sent:...

Dale Gilbert

10-18-2006 08:14 AM
Jerry Hamilton

Rumor has it that the latest upcoming download of IDS at the IIUG website will not have a timebomb... very cool. This is something that IIUG...

Double Echo

10-18-2006 07:58 AM
Jerry Hamilton

Hi, I've got a question regarding backing up with ontape. Our database is not big. The idea is to have a nightly Level 0 backup to STDIO. The...

Aleksander

10-18-2006 06:53 AM
Aleksander

Hi all. Is it possibile to know the duration of transaction in order to kill(onmode -z) the transactions lasts long? Is it possible to do this in a...

Marino Decaro

10-18-2006 03:38 AM
Marino Decaro

To me it seems it's something wrong with reports regarding free space in dbspaces. Or, in the worse case, could be something wrong with our database....

darko

10-18-2006 01:12 AM
darko

http://www.db2mag.com/postcards2.shtml jgp

Jean Georges Perrin

10-17-2006 07:28 PM
Jean Georges Perrin

I'm trying a couple of performance tests on simple queries; for example, setting/unsetting IFX_FLAT_UCSQ. So, I set up an SQL and run something...

malc_p@btinternet.com

10-17-2006 05:14 PM
mpruet@comcast.net

Do I read this correctly that your socket pollers are consuming large amounts of cpu cycles, with a high fraction of system time, and still the IDS...

Andreas Legner

10-17-2006 03:58 PM
Art S. Kagel

The term 'Black Panther' is usually applied to any large black cat, they tend to be either Jaguar (S.America) or Leopard (Africa/Asia) with a...

Jean Georges Perrin

10-17-2006 01:25 PM
Keith Simmons

I have no experience with Informix, but am looking for some suggestions. I need to dump out tables from an Informix database to text files. ...

wes.faul@gmail.com

10-17-2006 09:30 AM
kevin.kempter@dataintellect.com

Re. my previous issue with loads of V segments; We're on HP-UX11i and IDS9.30, and onmode -F does absolutely *squat* with regards to releasing any...

malc_p@btinternet.com

10-17-2006 07:05 AM
Art S. Kagel

Hello, Regarding the Sysprofile SMI table in sysmaster, what does the "isreads" field REALLY represent?

in4mixDBA

10-16-2006 04:10 PM
Art S. Kagel

Hello… they can help me with sintaxys of the command ONSPACES to recover dbspaces. I execute it this way: $onspaces -s dbspace_name -p...

Juan Pablo

10-16-2006 12:17 PM
Juan Pablo

Hi, I'm very new to informix and I try to write simple test procedure that return multi rows value to the caller. I tried : create function...

Gil Lapid

10-16-2006 11:28 AM
Doug Lawry

onmode -F does two things: 1) it cleans up pools inside IDS shared meory and returns these pools to the pool free list This pool memory is then...

Model-Bosch, Tilman

10-16-2006 11:22 AM
Model-Bosch, Tilman

I have an Informix 5-based application on AIX and need help with SQLEXECD (I-Star). Specifically, I am trying to get desktop PCs running...

Webb, Eric

10-16-2006 08:11 AM
Art S. Kagel

both work's, second looks pretty, tnks.

Denis.Zhuravlov@gmail.com

10-16-2006 03:35 AM
Denis.Zhuravlov@gmail.com

Hi All Thanks for your response. I solved the "All logical logs are FULL" . I did the following : ShutdownServer : onmode -ky Change Onconfig :...

Torben Hansen

10-16-2006 01:25 AM
Torben Hansen

HI All All my logical logs are full and I have a long running job that have filled the logs. I tried to do a backup of the logs with "onbar -b -l",...

Torben Hansen

10-16-2006 12:00 AM
mark.scranton@gmail.com

Hello everybody. I have IDS 7.31 FD6 running on AIX 5.3. For memory configuration I have the following parameters in the onconfig file: BUFFERS...

Bispo

10-15-2006 06:53 PM
david@smooth1.co.uk

All; I need a copy of 9.3 or 9.4 IDS for Redhat (32bit). I'm hearing that IBM no longer sells 9.x... Anyone have a copy to sell?

kevin@kevinkempterllc.com

10-15-2006 06:47 PM
david@smooth1.co.uk

All; I need a full (non-trial) copy of 9.3 or 9.4 IDS for Redhat (32bit). I'm hearing that IBM no longer sells 9.x... Anyone have a copy to sell?

kevin.kempter@dataintellect.com

10-14-2006 08:04 PM
Jean Georges Perrin

Is any know , how can I monitor which user alter my table ?

roger@star2000.com.tw

10-14-2006 01:58 PM
Jonathan Leffler

Hi guys HP-UX11i; IDS9.30HC5; i4GL 7.20UD8 (I know they're old but we're working on it.... ) Just had this pair of errors (finderr output and the 4gl...

malc_p@btinternet.com

10-13-2006 07:20 PM
scottishpoet

Hi, no. This address is not the problem. It is the address where the SHM segment is mapped to in the instances private memory...

Martin Fuerderer

10-13-2006 02:42 AM
Martin Fuerderer

Im working on Windows environment. my scenario is something like this: I have pc A and B. I have install the informix database in pc A. I want to...

fnag_sq

10-12-2006 08:11 PM
fnag_sq

Hi, Check your network speed connection between both servers. Checkpoints between primary and secondary servers running HDR are synchronous,...

Francisco Roldan

10-12-2006 04:47 PM
Francisco Roldan

Has anyone done this. I'm trying to get the numeric representation of a unicode character. DEFINE vpos int; DEFINE vUnicodeStr...

Alan Treece \(atreece\)

10-12-2006 10:38 AM
Alan Treece \(atreece\)

Christine Normile said: Life Donors Anonymous wants you NOW, JGP. :o) -- Bye now, Obnoxio "... no bill is required as no value was provided." --...

Jean Georges Perrin

10-12-2006 08:00 AM
Jerry Hamilton

Hi all, We have installed IDS10 on AIX 5.3. During starting instance of Informix we have received the following exception; # oninit IOT/Abort...

Navaid Arif

10-12-2006 03:23 AM
Navaid Arif

Hi all, We are running around 10 stable instances of IDS 9.21 with lots of 4GL code written in v7.3 on HP-UX 11.0. I know, it's really old and long...

PK

10-12-2006 12:37 AM
PK

Is it possible to dd an ontape backup from one tape to another, to make a copy of it ? Dirk Moolman

Dirk Moolman

10-11-2006 09:19 AM
Superboer

The effort to find a single portal effectively on software testing has been mainly in vain. I have found the site below, which atleast categorizes...

xest.learner@gmail.com

10-11-2006 03:39 AM
xest.learner@gmail.com

Hi everybody. I need to query my database from MS Excel. I am using INFORMIX SE 7.2 on WINDOWS XP. How can i do it?. Where can i get the appropriate...

Luis Carlos Díaz Otero

10-11-2006 03:21 AM
scottishpoet