Rating Thread / Thread Starter	Last Post	Replies	Views
Re: Row level lock [1899] Don't go updating systables. This is not the correct approach. Alter table <tabname> lock mode row; Mark ----- Original Message ----- From:... Mark Denham	09-18-2003 09:02 AM Mark Denham	0	80
RE: Urgent: Assert Failed: Page Check Error in btsearch:bad btree Hi This hint given in online.log 17:02:53 Results: Possible inconsistencies in index 'baandb:"".#' 17:02:53 Action: Run 'oncheck -cI... hiten.bhawsar	09-17-2003 11:42 PM hiten.bhawsar	0	98
Raw or Buffered device? ( 1 2 3 ) Hi, group today i found another problem about my informix. The ROOTPATH pointed to /dev/dbroot instead of /dev/rdbroot. in the manul, however, i... steven	09-17-2003 10:01 PM Andrew Hamm	26	254
Re: FW: Check out this modified PC case Dirk Moolman wrote: HTML post. 164 lines for something that is even more off-topic than I usually am. Nice one. -- "C'est pas parce qu'on n'a... Obnoxio The Clown	09-17-2003 09:58 PM Andrew Hamm	2	81
I4GL V7.30 and up - undocumented reserved words Well, OK, it took the special breed of programmer we have here to find them and any fool should have known not to use these words in... Malc P	09-17-2003 09:52 PM Andrew Hamm	1	79
Nagios Plugin Hi, Any pointers to a Nagios plugin for Informix? (IDS 9.30.FC5, SunOS 5.9) Thank you, -- Tielman de Villiers Tielman de Villiers	09-17-2003 07:41 PM Obnoxio The Clown	4	156
ER ... yes / no ? IDS 7.31 FD3 Solaris 8 I know this statement is a bit vague, but if I have the choice to use Enterprise Replication or not, should I go for it ? ... Dirk Moolman	09-17-2003 06:22 PM Dave Thacker	3	115
Question on split reads... Quoting from page 17-10 of the IBM Informix Dynamic Server Administrator's Guide (IDS 9.4 on Solaris 8) -- "A data page is read from either the... Rajesh Kapur	09-17-2003 05:57 PM Rajesh Kapur	0	90
Error 1069 when starting service Hi, I get an error 1069 logon failure when starting the informix 7.30.TC7 service on Windows NT4 SP4. I have a user "informix" which is assigned to... ofero	09-17-2003 05:12 PM Murray Wood $IList$	1	98
Urgent: Assert Failed: Page Check Error in btsearch:bad btree node Dear All, I have got the subjected error in my online.log file. Please let me know why this error has occured, how serious it is? what should I do... Kalgaonkar, Ruturaj S.	09-17-2003 04:16 PM Kalgaonkar, Ruturaj S.	0	100
Math problem Three guys in a hotel call room service and order two large pizzas. The delivery boy brings them up with a bill for exactly $30.00. Each guy gives... Dirk Moolman	09-17-2003 03:49 PM Art S. Kagel	4	148
query to return table structure hi, Is there any command or query that returns the table structure informix. fxthomas	09-17-2003 12:11 PM Obnoxio The Clown	4	72
Database Migration to new server - Any suggestions Urgent Hi All We are running production box with informix 9.21 on solaris, the present database has installed with DATABLADES (ETX,LLD adn TXT) but we are... KalpanaPai	09-17-2003 11:54 AM vivek.chaudhary@st.com	4	67
table extents "Gorazd Hribar Rajteriè" <gorazd.hribar (AT) telekom (DOT) si> wrote Well, on any platform. "Fixed" in IDS 9.40. A few other things to bear in... Rüdiger Mähl	09-17-2003 11:06 AM Neil Truby	3	92
Re: Question on Extent Size KalpanaPai wrote: My guess is that the tables have got too many extents, but they're probably in their own dbspace, so they're increasing... Obnoxio The Clown	09-17-2003 10:46 AM malcolm.iiug	7	88
java.sql.SQLException: Could not position within a table Hi, I have an application running on Tomcat on Windows 2000 and the database is Informix running on a HP-UX box. Once in a while i get this... shivas	09-17-2003 06:11 AM Simmons, Keith	3	142
Re: Assert Failed (Exception Caught. Type: MT_EX_OS, Context: mem) Hi Alan, we seem to suffer from the same problem. Did you get a solution for this? cheers knikkink	09-17-2003 05:10 AM knikkink	0	113
IDS 9.40 Documentation (LRUs). Hello. I´ve been trying to find some information about changes in the way IDS 9.40 handles LRU Queues. It seems that there is a new algorithm... rdtbra	09-17-2003 04:19 AM David Brent	8	98
Onstat -d output for 32bit 9.40 version (9.40.UC*) Can someone provide me the output of the onstat -d command for a 32 bit version of 9.4? Thanks in advance. dcgigem	09-16-2003 04:59 PM Langelage, Frank	1	80
Re: Long Transaction [1879] about 60,000 rows in all, but only about 1000 rows are involved when the procedure is run. The procedure runs fine for 3 months worth of data... Mark Denham	09-16-2003 09:00 AM Mark Denham	0	74
How big is my result set? If you're using IDS 7.3x there is some very useful documentation available at my... Scott Burns	09-15-2003 07:44 PM Obnoxio The Clown	9	102
Re: Clarification on SQL performance tuning.... See the suggestions below ... Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: ... Rajib Sarkar	09-15-2003 06:33 PM Mark D. Stock	1	97
variable used for proc name A co-worker is trying to get the following SPL procedure to work and gets error 674 when he runs it. What he wants to do is have a generic stored... John David Adamski	09-15-2003 01:06 PM Paul Watson	1	83
OPTCOMPIND some of my jobs are very faster with OPTCOMPIND at 0 and others are faster with OPTCOMPIND at 2. is it possible to dynamically change this value ??? bil	09-15-2003 11:58 AM Abhishek Mathur	5	162
Re: -640 : QPlan sanity failure (2139.3). Leonid Vorontsov wrote: Have you done what the error description suggests? Mind you, if I was a query optimiser, I think one look at your SQL, and... Mark D. Stock	09-15-2003 10:55 AM Rajib Sarkar	1	140
Question on Lvarchar Datatype Hi Could naybody clarify me , which is the best datatype to use VARCHAR or LVARCHAR? I need to store data like Comments could be less than 255 or >... KalpanaPai	09-15-2003 10:53 AM Rajib Sarkar	1	93
Fw: Turn off logging for a single table [1871] You cannot turn off logging for a single table, unless you convert it to raw. Raw tables cannot have indexes. You can make the process more... Mark Denham	09-15-2003 08:42 AM Mark Denham	0	77
4gl to C problem Having not used 4gl to C for a while something is doing my head in, IDS 9.30, 4gl 7.30.UC3 on Solaris 7 Why doesn't this not work, it cores on the... Paul Watson	09-15-2003 07:55 AM Paul Watson	2	103
ER : how to speed up sender ? Hi, i am working with ER replication. I have 2 computers : A 4 CPU RM400 (siemens) with sinix OS (or reliant unix) and a 7.31UD2 database server. A... Jean-Francois BOUDRY	09-15-2003 05:53 AM Jean-Francois BOUDRY	0	65
Using ontape when the server is up ? ( 1 2 ) Andrew Hamm wrote: Finally, someone with some sense. It's all very well being able to go fast round a corner, but where is the thrill if you're not... Jack A	09-15-2003 02:09 AM Obnoxio The Clown	14	111
Command "DATABASE" is making problems Hallo specialists! I am running a 4ge-application since years. The database-tables are situated in some different databases (DATABASE arzt, DATABASE... Philipp Walderdorff	09-13-2003 03:47 PM Philipp Walderdorff	0	62
How to convert the CHAR type to NUM in the select? Hi : I want to convert a char column to a num type; I don't known which internal function can be used! Sample : select to_num( char_column_name )... Killwind	09-13-2003 05:14 AM Paul Watson	1	82
[HELP] What my Informix is doing? ok, I run some onstat and get the following: --------------------------- cut ---------------------------------------------- $ onstat... steven	09-13-2003 05:03 AM steven	7	80
HDR Failure Scenario I would like to know if the following scenario will work (or whether it's feasible): 1) Primary goes down. 2) Secondary is changed to standard... antzz	09-12-2003 06:42 PM Everett Mills	3	88
How to export an Informix db to MS SQL Server 2000? ( 1 2 ) Hi, My client has an Informix SE database on Windows Platform (NT). How do I export such a db to MS SQL Server 2000? I've searched this... Doug Baroter	09-12-2003 06:03 PM sysprog@yahoo.com	11	148
Problems with Shared Memory I have problems with Shared Memory. Only 5 or 6 users can login at the same time at database using shared memory INFORMIXSERVER. All run ok... Diego Morales	09-12-2003 12:58 PM Obnoxio The Clown	7	113
Onbar imported restore fails I have been doing an imported restore of 5 servers for 5 months without a problem. Recently I had a file system fail and my backup up scripts were... Colin Bull	09-12-2003 12:49 PM Brice Avila	1	77
Informix Stored Procedure Hello! I am using Informix 7 se and having problems with updating the stored procedure everytime I run it. Basically, I have made changes to the... Ahmer Sajjad	09-12-2003 12:37 PM Diego Morales	3	103
Same Instance Name Running on Seperate Hosts This in my mind is a daft question but I have to be clear. Can I have the same instance name running on different servers on the same... Clanmac4	09-12-2003 12:29 PM Mark D. Stock	5	75
Database with buffered and unbuffered log. What is significance of Informix database buffered log or unbuffered log parameter. Suket	09-12-2003 09:36 AM Robert A. Reissaus	3	98
Querix Debug ( 1 2 ) Hi all, How can I debug 4gl program with Querix under Windows 2000? Is it necessary debug under Unix with d4gl or Querix have a debugger... Renza Rebecchi	09-12-2003 09:07 AM Mark D. Stock	18	319
Re: [Solved] -- Re: RE: How do I pass a collection type to a prepared Jean Sagi wrote: You have had several solutions to this. You can, you just don't want to. Something like: " where field_code = ?", ... Mark D. Stock	09-12-2003 07:03 AM Mark D. Stock	1	85
Reuter's article - - - IFMX a mainframe company ( 1 2 ) Here's the quote . . . . International Business Machines Corp. IBM.N unseated Oracle as the overall leader in total new database software sales with... John Carlson	09-12-2003 07:00 AM Mark D. Stock	13	121
Informix vs. Oracle ( 1 2 ) Daniel Morgan wrote: Oh, go on -- I want to know about all of those... :o) ky	09-12-2003 03:35 AM Dirk Moolman	11	131
How to acrtivated Kernel Access IO (kaio) on IDS Ver 7.31.UD2 on Linux Suse 8.0 pro I am used to make running an engine on HPUX with KAIO... Is this fonctionnality possible on Linux Suse 8.0 pro (under a Compaq box) ? If yes, !waht... ECKLE Bruno	09-12-2003 03:17 AM Ronald Cole	1	85
[Solved] -- Re: RE: How do I pass a collection type to a prepared statement in [1836] Well, I come to a conclusion that Informix 4gl 7.30 could not pass dinamucally a list of strings to a prepared query for use in an IN filter in the... Jean Sagi	09-11-2003 08:32 PM Jean Sagi	1	69
[Solved] -- Re: RE: How do I pass a collection type to a prepared statement in [1836] Well, I come to a conclusion that Informix 4gl 7.30 could not pass dinamucally a list of strings to a prepared query for use in an IN filter in the... Jean Sagi	09-11-2003 02:03 PM Jean Sagi	0	65
[Solved] -- Re: RE: How do I pass a collection type to a prepared statement in [1836] Well, I come to a conclusion that Informix 4gl 7.30 could not pass dinamucally a list of strings to a prepared query for use in an IN filter in the... Jean Sagi	09-11-2003 02:02 PM Jean Sagi	0	76
Re: RE: [Fwd: How do I pass a collection type to a prepared statement in [1829] I think the same, maybe in Informix-4gl 7.32 they are properly supported. Chucho! -----Original Message----- From: "Scott O'Rourke" <SORourke (AT)... Jean Sagi	09-11-2003 01:33 PM Jean Sagi	0	80
nettype hi, i have a ifx 9.21 engine on a linux RH 7.3 server. i have my client applications on the same server. must i use a SHM nettype or a TCP nettype... bil	09-11-2003 12:54 PM Obnoxio The Clown	1	167

Page 168 of 179

168

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