Rating Thread / Thread Starter	Last Post	Replies	Views
4gl Syntax One of the developers here at my company get the following when attempting to compile a 4gl script based on what he thought the manual was... John Hibner	08-16-2004 10:24 AM Mark D. Stock	2	70
ontape restore failing Good morning everyone. I am trying to use ontape to restore some dbspaces and I am getting a weird message: / dd: 0511-051 The read failed. : There... sumGirl	08-16-2004 10:01 AM Brice Avila	2	213
Integer versus character fields Where can I find a good explanation on the web of why integer fields are better than character fields. There will probably be cases where character... Dirk Moolman	08-16-2004 05:49 AM Dirk Moolman	0	34
SMALLINT precision error - 4gl I have this error message in my log file, executing a 4gl program. Date: 08/08/2004 Time: 09:07:40 FORMS statement error number -1214. Value... Guillaume Duret	08-16-2004 02:12 AM Nebojsa Sevo	2	66
connection not established on TCP Informix 7.3 HP-ux 11.x A query runs on Informix database and returns only one row. This data should be sent across to other server say (pegasus4)... Shevkar, Mukund	08-14-2004 06:37 AM Shevkar, Mukund	2	39
PHP and Informix I work for a company that uses Informix as it's primary database engine. Our Informix installation runs on Red Hat Advanced server. We currently... Trevor	08-13-2004 11:40 AM CKGeier@nwc.edu	6	81
Informix Tuning Problem My server run very slow for this few weeks.. I've checked the %cache go 99%.. Hardware : IBM - H80 , 4 CPU , 2G Ram , HD x 2 dskreads pagreads... Andy Leung	08-13-2004 04:32 AM Ben Thompson	4	68
-710 - Table (informix.systables) has been dropped, altered or renamed. Hi, I have two servers in replication, server Bdsalud (Primary) and server Bdcemena (secondary). I run dbexport in server bdcemena(secondary) and... LUQUE Valdivia Omar	08-13-2004 02:20 AM Ajay Gupta	1	64
ontape Info Hi All, i'm not a DBA, my question is very simply. I have executed the following command: ontape -s -L 0. From the documentation this command... Abanero	08-12-2004 08:31 PM unknown	8	67
Copying across databases Is INSERT INTO .. SELECT FROM inherently slow across databases? Does it keep having to re-make database connections or something? I am... Andy Kent	08-12-2004 06:06 PM Andy Kent	8	53
HDR: MULTISET gives -626 on secondary Hi, everybody, We've encountered very unpleasant problem: a lot of our reports (containing MULTISET in SELECT statement) give -626 error when run on... Alexey Sonkin	08-12-2004 05:42 PM Alexey Sonkin	3	54
onstat -z via sql command? Hi, is there a SQL command to reset the statistics like "onstat -z"? I got some scripts with selects from the system tables and it would be fine if... Helge Baumann	08-12-2004 11:18 AM Madison Pruet	1	49
ISAM writes (sysptprof) Someone told me long ago that the ISAM writes in sysmaster:sysptprof, are not record writes, therefor 5 isam writes will not be equal to 5 records... Dirk Moolman	08-12-2004 08:37 AM Dirk Moolman	0	36
non-Informix Replication software Does anyone on this list use Veritas or SUN replication software for failover / disaster recovery purposes ? Dirk Moolman Database and Unix... Dirk Moolman	08-12-2004 07:46 AM Dirk Moolman	0	34
Linux libpam.so.0 install error Hi, I've been trying to install informix 9.40 on Slackware linux, but I keep on getting this error: etc/brand: error while loading shared... Trev	08-12-2004 04:00 AM Eric Delaet	2	50
problemas con DBEXPORT Tengo problemas con el dbexport de mi BD. Me sale el siguiente mensaje de error: Disk space may be full. Cannot flush file(s). Dbexport... Dooku Maul	08-11-2004 07:06 PM Ferronato	2	305
virtual memory segments added greetings all, we are on 9.40 FC3 on hp-UX 11i - sometimes segments are being added and cannot flush with onmode -F . is there a way to view what... tomL	08-11-2004 05:01 PM Madison Pruet	1	38
problems of Inztallation's Hi: I have problems with thle installation of IDS. Plataform: HP-UX 11.11 IDS: 7.31 FD8 I cannot initialize !!! If I want to iniciarlize via... Dooku Maul	08-11-2004 01:04 PM Dooku Maul	0	48
onpload - assert fails, mt_shm_alloc problem? Hi team Using onpload in command-line mode and with commands that used to work on our IDS7.31, HP-UX10.20 setup is now failing under... Malc P	08-11-2004 10:26 AM Neil Truby	2	64
Connection from AS server I am getting a problem that connection from a physically different AS server is not happening to DB server. When I telnet from AS server into unix... Shevkar, Mukund	08-11-2004 06:38 AM Shevkar, Mukund	0	54
change logging Hello list. Online 7.20 UC2 I want to change the logging status to NOLOG so I do: ontape -s -L 0 -N mydbs I got a message that logging status... H.J. Sanders	08-11-2004 03:41 AM Claus Samuelsen	4	349
DB_LOCALE Running Informix-SE What should DB_LOCALE be set to when running on a linux machine ? Joe	08-10-2004 08:43 PM Tsutomu Ogiwara	1	54
Smart Blob/JDBC -> getBytes returns null! I have an annoying rare problem. Infrequently, JDBC reads of a Smart Blob return null bytes. That is blob.getBytes() returns null without throwing... Steve	08-10-2004 06:25 PM Steve	2	31
search mailinglist Hello Where can I search the mailing list? There used to be an entry at iiug.org bur I cannot find anymore Anyone any idea Thanks H.J. Sanders	08-10-2004 10:28 AM Dirk Moolman	2	49
Re: Database Tuning On Mon, 09 Aug 2004 14:56:07 -0400, Roger Cariah wrote: PLEASE DO NOT POST MIME to this newsgroup/maillist. Doing so triples the bandwidth... Art S. Kagel	08-10-2004 09:48 AM Art S. Kagel	0	32
Cursor with hold on DBD:Informix 1.00? Does anybody knows if DBD:Informix has the cursor with hold feature? Is there any example available? I intent to use this to build a script that... Eduardo Bispo	08-10-2004 09:46 AM Jonathan Leffler	1	54
Unexpected backslashes \ in dbaccess unload output rkusenet wrote: It's slightly more complex than that. It came up on one of the IUG mailing lists recently, and I gave an answer there, too. The... Michael Ben-David	08-10-2004 03:07 AM Jonathan Leffler	1	51
How to find the creation date of a chunk ? (not a dbspace, a chunk ?). --0-2003821237-1092088394=:10165 Content-Type: text/plain; charset=us-ascii Hello all, Could some one tell me the fastest and easiest way to find... Mike Smith	08-09-2004 05:53 PM Mike Smith	0	39
write buffer stats down after install of fast write cache hardware? Good morning. I installed write cahching hardware on my disk subsystems over the weekend and I was surprized to find my buffer stats down from what... sumGirl	08-09-2004 01:34 PM Neil Truby	1	48
rcmd: Connect all users from one server to ONE user in the other Hi, I have 2 boxes (SCO & RedHat) with Informix databases. In SCO I have a large database with +50 different users and a lot of information, and in... Manuel Daponte	08-09-2004 12:56 PM Art S. Kagel	5	53
RE: Testing backups ... Dirk Moolman wrote Our developers are always asking for a cut of live, so we now have an automatic process - Colin Bull	08-07-2004 09:13 AM Clive Eisen	3	43
Re: SE at EOL? ( 1 2 ) We've had a similar offer but, as rkusenet implies, I don't think there's anything sinister in the absence of further development for SE. -- Neil... Neil Truby	08-07-2004 05:56 AM Obnoxio The Clown	11	97
dbspace down I have stopped the database with onmode -k and now it refuse to come up saying that it will need restore of dbspaces. What is the best way to restore... Shevkar, Mukund	08-07-2004 05:16 AM scottishpoet	1	82
database snapshot i am told oracle has a way to take a "frozen snapshot" of a production system - does informix have this capability? when i move production... tomL	08-06-2004 06:03 PM scottishpoet	4	54
How to use Informix Hi Guys, I am very new to informix.I got a copy of informix IDS 9.4 and installed it.It went succesfull except datablade which needed VC++.But after... Mickykt	08-06-2004 05:23 PM Wandering Child	2	80
Replication (different OS-es and IDS versions ) Hello, I have 2 IDS 7.3/Uniware servers working with replication enabled. I would like to migrate one of them to 9.4/AIX and then to... Wojtas	08-06-2004 04:17 PM Madison Pruet	6	42
Informix executables. Hi All, We have an application that needs to be deployed in the following way. There are 2 machines & the informix executable (Both screen &... Vijay Kumar	08-06-2004 02:48 PM scottishpoet	2	43
Implict Update Statistics Within the last few weeks one of our WEB applications hangs because the DB never responds. After some investigation we have found that the... Shannon Sellers	08-06-2004 12:28 PM Dave Griffen	2	55
ONBar Restores and Tivoli Storage Manager I am having problems with restores from ONBar via Tivoli Storage Manager (TSM). I can perform backups that complete fine according to the logs, and... PEEK, CHRISTOPHER	08-06-2004 06:48 AM Bill Dare	4	52
Connection Pool Error in Linux - Work in Windows --=======2B2546CE======= Content-Type: text/plain; x-avg-checked=avg-ok-24C6DE2; charset=us-ascii; format=flowed Content-Transfer-Encoding:... Fabio Tsuzuki	08-06-2004 02:53 AM ogj@tollpost.no	1	53
AW: alter table: 'lost' extents I've just made some deeper investigation. One of extents (I took the largest for simplicity) reported by chunk's extent list (oncheck -pe) as... Alexey Sonkin	08-05-2004 10:47 PM Alexey Sonkin	0	47
Excalibur Datablade AFAICR, this used to be a bundled part of the IIF suite. We have identified the requirement to check if Excalibur may be useful to us, but it's not... Malc P	08-05-2004 07:31 PM Alexey Sonkin	2	51
alter table: 'lost' extents Hi, everybody, I've just found a very unpleasant problem with 9.21uc4 I have a huge table that was altered (column added) when it was big... Alexey Sonkin	08-05-2004 07:28 PM Alexey Sonkin	0	35
4GL CHAR Manipulation Hi everybody, I need to eliminate the first 3 charactes of the value in a CHAR variable, for example LET myvar="MV NAME" I need to eliminate "MV "... Francisco Roldan	08-05-2004 07:11 PM Everett Mills	2	57
Extra lines added to ONCONFIG by onparams We are experiencing a phenomenon whereby extra lines are being added to the ONCONFIG file. After these lines have been added we are unable to use... malcolm weallans	08-05-2004 02:15 PM Bill Dare	2	42
Re: Extra lines added to ONCONFIG by onparams - B169031 Malcolm Weallans <malcolm.iiug (AT) btopenworld (DOT) com> wrote: Dear Malcolm, I've created bug B169031 for this since I can reproduce the... Jonathan Leffler	08-05-2004 02:07 PM Jonathan Leffler	0	51
Primary server blocking when creating indexes on large tables Hello, We have IDS 9.40.FC2 running on AIX 5.2, also running HDR (data replication). When creating an index on a large table (2 million+ rows), the... Sean Baker	08-05-2004 01:42 PM Sean Baker	0	33
Re: changing owner You can't do an in place ownership change. You can do a dbexport, drop and dbimport under the new user. If you want to change object ownership as... Dave Griffen	08-05-2004 12:17 PM Dave Griffen	0	39
writes to dbspace unknown ! I have a database where there are writes to ps2dta dbspace. I looked through schema for all the database (except system ) tables. None of the tables... Shevkar, Mukund	08-05-2004 05:40 AM Eric Herber	1	42
Error Initialize Informix Dynamic Server Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing... madiego	08-05-2004 03:13 AM Jonathan Leffler	2	199

Page 110 of 158

110

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off