HDTenEightyP/NetNews huggingface dataset:
From: paul@acus1.cc.uky.edu (paul linton)
Subject: logfile format?
Organization: University of Kentucky
Date: Tue, 10 Nov 1992 19:33:15 GMT

Does anyone have the format that the logfile for informix SE engine
is in?

Also, is it something the changes from version to version?

Regarding Online:
What kind of problems are people running into with regards to
relying completely on informix tools?  I may be under the group
of people that are "scared of what they can't see".  I like the idea
of backing up with tar and knowing I can trot over to another machine and
read the table onto it.  Does everyone running Online currently have a
dedicated tape drive for its use?

Thanks,

Paul
From: walt@mathcs.emory.edu (Walt Hultgren {rmy})
Newsgroups: comp.databases.informix
Subject: Problems at gateway site
Date: 10 Nov 1992 11:18:57 -0500
Organization: Emory University
Distribution: world
NNTP-Posting-Host: emory.mathcs.emory.edu

There were some network problems here at Emory over the past weekend that
caused the system running the gateway between the Informix mailing list and
comp.databases.informix to be off the air for a while.

Unfortunately that "while" was long enough to cause sendmail to kick back
several outgoing messages.  Judging from the bounces, messages with List-ID's
<list.1576> and <news.2067> through <news.2072> failed to get out.  I am
re-mailing these to the list.

On the Usenet side of the fence, things were less affected, except that a few
messages posted to the list experienced a 3-4 day delay going through the
gateway instead of being sent through immediately.  And, of course, articles
posted to c.d.i have also been delayed going out to the list.

To my knowledge, the problems were all internal.  The news host continued to
receive and spool all c.d.i articles.  If you posted something to the mailing
list early in the problem period, your message may have bounced back to you.
You should get an obvious bounce message if that occurred.

It may take another day or so for things to smooth out.  If you've posted
something recently and haven't seen it yet, wait a little longer than usual
before you assume that it didn't make it, or that no one has replied to it.

Let me know if you have any questions, or if you need to check on a list
message or news article.

Thanks,

Walt.

-- 
Walt Hultgren              Internet: walt@rmy.emory.edu       (IP 128.140.8.1)
Emory University               UUCP: {...,gatech,rutgers,uunet}!emory!rmy!walt
954 Gatewood Road, NE        BITNET: walt@EMORY
Atlanta, GA  30329  USA       Voice: +1 404 727 0648
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Updating with editing capability
Date: 11 Nov 1992 16:38:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dave.snyder@snide.com (Dave Snyder)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1588>

Quoting Ron Choi...
} 
} i've using perform for entering and updating records.  for updating,
} it would be nice if the user-interface supplies some sort of editing capability.
} only way one can update in perform is to type over the old entry.  can 
} we do better than that in 4gl or third-vendor user-interface?  in other words, 
} is there a way to insert characters and delete characters with out typing 
} over the original entry?
} 
While in ADD/UPDATE mode, do a CONTROL-W.  This will give you a help screen
of all the editing keys available to you.

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: jim@tct.com (Jim Kunzman)
Subject: Estimating sizes of indexes
Date: Tue, 10 Nov 1992 16:31:06 GMT
Organization: TC Telemanagement, Clearwater, FL

Informix provides very useful tools for estimating sizes of rows in
a table.  Perhaps I've overlooked it, but I can find nothing about
estimating sizes for indexes.  In other words, given table X with
indexes A, B, and C, how much overhead is required for each additional
row in table X?

Can this be done easily?  Is there somewhere in the documentation where
this is covered?  Is there any difference in overhead for SE and Online
(unfortunately, we have to support both)?

TnxInAdvance.
-- 
Jim Kunzman at Teltronics/TCT     <jim@tct.uucp>, <uunet!pdn!tct!jim>
-----
OS/2 2.0 - 1,400,000+ copies sold.  Sweet dreams Mr. Balmy.
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Triggers in Informix?
Date: 10 Nov 92 16:24:17 GMT
Organization: Informix Software, Inc.

Tim Smith writes:
>Are the 5.01 triggers "after statement" triggers, or do you support
>the SQL3 standards for all trigger types (I think there are 12 of
>them)?

Offhand I do not know wtaht what SQL3 standard for triggers is, but 5.01
will support BEFORE and AFTER triggers on UPDATE, DELETE, and INSERT
operations, with FOR EACH ROW clauses and WHEN clauses.  So for UPDATE,
DELETE, and INSERT operations, a trigger can take effect before the action
or after it, you can apply the trigger action to each row and can place
tests upon columns in the row to determine if the triggered action  should
be executed.  The triggered action can be an insert, delete, update, or
execute procedure statement.  For update triggers, the update of individual
columns can invoke the trigger, or the update of any column.

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
From: rchoi@thylacine.cs.wisc.edu (Ron Choi)
Newsgroups: comp.databases.informix
Subject: Updating with editing capability
Date: 10 Nov 92 16:48:07 GMT
Organization: University of Wisconsin, Madison -- Computer Sciences Dept.

i've using perform for entering and updating records.  for updating,
it would be nice if the user-interface supplies some sort of editing capability.
only way one can update in perform is to type over the old entry.  can 
we do better than that in 4gl or third-vendor user-interface?  in other words, 
is there a way to insert characters and delete characters with out typing 
over the original entry?

thanx in advance, 

-- 
---------------------------------------------------------------------------
ron choi 				\\  #include <disclaimer.h>
university of wisconsin, madison	\\
	"when i was your age, i walked ten miles to school, unarmed."
From: davidm@consilium.com (David S. Masterson)
Newsgroups: comp.databases.informix
Subject: Re: Triggers in Informix?
Date: 12 Nov 92 00:41:09 GMT
	<1992Nov10.063200.2163@netcom.com> <1992Nov10.162417.734@informix.com>
Distribution: comp
Organization: Consilium Inc., Mountain View, California
In-reply-to: davek@informix.com's message of 10 Nov 92 16:24:17 GMT
X-Posting-Software: GNUS 3.13  [ NNTP-based News Reader for GNU Emacs ]

>>>>> On 10 Nov 92 16:24:17 GMT, davek@informix.com (David Kosenko) said:

> Offhand I do not know wtaht what SQL3 standard for triggers is, but 5.01
> will support BEFORE and AFTER triggers on UPDATE, DELETE, and INSERT
> operations, with FOR EACH ROW clauses and WHEN clauses.  So for UPDATE,
> DELETE, and INSERT operations, a trigger can take effect before the action
> or after it, you can apply the trigger action to each row and can place
> tests upon columns in the row to determine if the triggered action  should
> be executed.  The triggered action can be an insert, delete, update, or
> execute procedure statement.  For update triggers, the update of individual
> columns can invoke the trigger, or the update of any column.

Will you be able to define more than one trigger (of different types) against
a table?  That is, could each table have one each of BEFORE UPDATE, AFTER
UPDATE, BEFORE INSERT, AFTER INSERT, etc. triggers?

--
====================================================================
David Masterson					Consilium, Inc.
(415) 691-6311					640 Clyde Ct.
davidm@consilium.com				Mtn. View, CA  94043
====================================================================
We should develop anti-satellite weapons because we could not have
prevailed without them in 'Red Storm Rising'.
       -- Vice President Dan Quayle
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re: defer interrupt.
Date: 11 Nov 1992 03:33:08 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1585>

>From: uunet!rhi.hi.is!gaukur (Kristjan Gaukur Kristjansson)
>Subject: Re: defer interrupt.
>Date: 9 Nov 92 13:22:18 GMT
>X-Informix-List-Id: <news.2090>

>>Did you read pages S-29 - S-32 (in the English version, anyway) of the
>>4GL 4.1 Supplement document? If so, what was unclear?

>Yes I've read them, but maybe theres something wrong with my configuration.
>In my test exemplar I'm interrupting a foreach loop thats fetching rows
>and getting some of them into a report.

All is revealed...  The problem is that reports are pigs to break into, not
that the defer interrupt stuff doesn't work particularly.  Reports always have
been neear enough impossible to interrupt, and they haven't changed recently.
If you subject the program to blizzard of interrupts, then eventually, you
usually manage to get a report to acknowledge that an interrupt has occurred.

I haven't done exhaustive checking of SQL INTERRUPT ON but I think you
will find it will work, except when there is a report in use.

One day when I get some time, I'll try an track down what it is about reports
that makes them immune from interrupt, but they always have been like that.

>So is it maybe something wrong with my termcap?

No, but an interrupt at an inconvenient moment may throw the key handling
code out of kilter.  That is the problem with interrupts...  They're never
expected.

>Also one comment on the int_flag testing; if youre interrupting open, fetch,
>close statements (with something in between) do you have to test the int_flag
>after every statement (because you never know in loops where the ctrl-c will
>hit)?  

You should check after the open (because if the staetment was interrupted,
you don't have a properly open cursor with which to fetch data), after each
fetch (because if the row wasn't fetched, you don't have any new data in your
variables), and probably after the close (simply because you're about to go
and do something with the fetched data, and ought to check that all was OK).
You don't really need to check after each intermediate calculation; once per
fetch loop is enough, nomally. (That assumes no nested SQL statements -- you
should check after each database operation -- hence after open, fetch, close).

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: inf_bb@hermes1.sps.mot.com (informix users bb)
Newsgroups: comp.databases.informix
Subject: table creation timestamp
Date: 12 Nov 1992 12:58:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: inf_bb@hermes1.sps.mot.com (informix users bb)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1594>


i there a way that the creation timestamp of a table can be obtained.
tbcheck -pt db:tab displays it, but i want to get this info non-
interactively and without having to wait for tbcheck to finish.  also,
does informix stores the last update, last alter timestamp anywhere.

------------------------------------------------------------------------------
                                                            |     .     .
  Bob Baskett                                               |    ...   ...
  Software Engineer, DBA                                    |   ..... .....
  Semiconductor Products Sector                             |  ..   ...   ..
  Business Systems Integration Group                        | .      .      .
  Mesa, AZ                                                  |
                                                            |  Motorola, Inc.
------------------------------------------------------------------------------
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Informix logs read-only queries? can't handle 'not-exists'?
Date: 12 Nov 92 16:19:43 GMT
Organization: Informix Software, Inc.

Ron Choi writes:
>i'm running Online 5.0 and seemed to have discovered a bug (or bugs).
>i ran the following query overnight:
>
>select count(*)
>from relA
>where (relA.x10A = 0 or relA.x10A = 5) and not exists (
>	select relB.evenAcct
>	from relB
>	where (relB.x100B = 0 or relB.x100B = 49) and
>	relB.evenAcct = relA.acct
>	);
>
>and got hundreds of "Logical Log Files are Full -- Backup is Needed".
>the worst thing is that this corrupted the database.  first of all, the above
>query is read-only, so it should not create log records (unless informix
>is doing something weird and supporting cascade aborts).  secondly, 

The reason log entries are being generated is that the sub-query is 
generating a temporary table, and the creation of this temp table is being
logged.  Because you are using a correlated sub-query (the where clause of the
sub-query references a table in the dominant query), the subquery must be
executed for every tuple in the dominant query.  If many rows are being
examined by that dominant query, then many temp table are going to be
generated for processing the sub-query.  These tables do not hang around, but
the log entries will fill up the logs.

>the database had logging turned off (with 'tbtape -N databasename'), but 
>it still logs anyway!  and a query sure shoudn't corrupt the database.  

The log records are still being written because OnLine logs all DDL 
statements (whether logging is on or not) and the creation of even an
implicit temp table is, at the rsam level, a DDL action.

I agree wholeheartedly that a query should not corrupt the database.  What
exactly become corrupted and how?

>has anyone seen this before?  i can reproduce it; i ran this twice already 
>with the same result.  and yes, i was the only person accessing the database 
>that night.

I cannot say for sure if this is considered a "bug".  There are reasons
why DDL statements are always logged (it is the only way that they can be
"undone" in OnLine, in the event that the statement should fail for some
reason), but it is not entirely clear that implicit temp tables should
have log records written to the log on disk (believe me, there are many 
complicated elements around this, relating to recovery issues).


Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: Help Needed with 'pstartsql' & 'pisql' error message.
Date: 8 Nov 92 02:42:51 GMT
Organization: Helen Keller Bondurant's Performance Driving School for the Blind

In article <1992Nov2.202959.24795@informix.com> dsimon@informix.com writes:
>>Machine: 386DX 25mhz, 8mb RAM, VGA
>>Version of Informix is 2.10.06
>>
>>Error message: DOS/16M error: Cannot run 286 protected mode within
>>               Virtual 8086.
>
>The err message you are getting is telling you that somehow, your machine is in
>V86 mode.  As such, it can not start a protected mode application, only real mode
>is available in V86 mode.  Possible causes of this...are you trying to start 
>pstartsql and pisql from within Windows?
>
>Also note that these are the only allowable combinations:
>
>startsql and isql
>pstartsql and pisql
>pstartsql and isql
>
>you cannot do startsql and pisql.

This is incorrect; startsql and pisql DO work together OK (in 2.10.06, at
least).

>> Bob Beaulieu                                 bobb@netcom.com  
>don simon


--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

"A leopard never changes his stripes" 
           -- Al Gore, Vice-president-elect
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: paul linton
Date: 13 Nov 92 16:06:37 GMT
Organization: Informix Software, Inc.

Ann Barnes writes:
>One undesirable side effect is that during the day, even if we log off the
>logger, we cannot use that tape drive with cpio/tar etc. It always tells us
>that shared memory has it tied up. So I assume because Turbo was brought to
>multi-user mode with that device defined for its use, it wont let anyone else
>use it. I hope On-Line will be more forgiving. 

This must certainly be a side effect of your o/s if it is true.  If the
process that does the log backup (tbmonitor or tbtape) has been terminated,
then Turbo will NOT have that tape drive open.  Turbo being on-line with 
that tape device *defined* as the backup device (but no backup process in
progress) will NOT open or in any way monopolize that tape drive.  Are you
sure that by "logg[ing] off the logger", you are in fact stopping the
continuous backup (I assume that is what you are using for the log backup)?

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
Newsgroups: comp.databases.informix
From: john@elsouth.uucp (John White)
Subject: SE vs OL - Lets get to the crux.
Summary: What is the factor that OL is less susceptible to as user load goes up?
Organization: Electrical South Inc
Date: Fri, 6 Nov 1992 19:41:29 GMT

Folks,

   Appreciate all of the suggestions/responses from you to my
recent OnLine indexing performance degradation question I posted. 
I decided that I'd be better off biting the bullet and sitting on 
hold for several days to talk to tech support. Thanks for the 
advice and so on, but based on the response I don't think that 
this is the right forum to ask tech support questions. I'll get 
over the stumbling blocks behind the scenes.

   On the other hand, I do think think this is the right forum for
one of the non-application-specific issues that was brought up.
It has been repeatedly pointed out that OnLine doesn't show its 
performance increase at lower user numbers. I've been promised that 
OnLine is buttloads better when the user count goes up. I don't 
think so. 

   TEST: 
      o Put 50 users on each of two machines
	 o One machine running OnLine
	 o One running Standard Engine
      o Have all of the users pull up perform screens.
      o Have the users do nothing (easy).
      o Run database performance tests on each machine.
      
   I think you'll get very similar numbers to when there is a single 
user. I submit that the important factor in the equation is not the 
number of users, it is more likely the number or transactions per 
second, or the number of transactions per user per second.

   Having said that and feeling the incoming corrections in my 
peripheral conscience, I ask four things:

   1) That we stick to the subject at hand. I don't want to hear about
      how performance is not the issue, because performance IS the
      issue.
   2) If I'm wrong, what is the correct answer? What is that elusive 
      most-important-factor (X), that as X increases, the performance 
      of OnLine does not degrade as rapidly as Standard Engine.
   3) How does a person measure this factor on his active system? How 
      can I say with confidence that at my shop X = 4.63?
   4) What is the break point? At what point do the performance gains 
      that OnLine brings make up for its overhead costs? i.e. When X > 2.

   - john (john%elsouth@concert.net)
From: randy@turq.b8.ingr.com (Randy Paries)
Newsgroups: comp.databases.informix
Subject: Help with structs and .ec
Date: 5 Nov 1992 15:03:08 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: randy@turq.b8.ingr.com (Randy Paries)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1574>

Hi,

	I having problems fetching into a structure when using a prepare.
	I will explain.

	/*------------------------------------------------------------*/
	$struct open{
		int  var1;
		int  var2;
		char var3;
	};
	$struct open open_rec;

	main()
	{
		$declare X cursor for
			select * from table where table.var1 = 2;
		$open;
		$fetch X into $open_rec;
	}
	/*------------------------------------------------------------*/
	This above example works ok. The following example fails on the
	compile with the following error:
	line 13: RECORD objects 'open_rec' are not allowed in this list
	/*------------------------------------------------------------*/
	$struct open{
		int  var1;
		int  var2;
		char var3;
	};
	$struct open open_rec;

	main()
	{
		char qvar[200];

		strcpy(qvar,"select * from table where table.var1 = 2");

		$prepare Y from $qvar;
		$declare X cursor for Y;
		$open;
		$fetch X into $open_rec;
	}
	/*------------------------------------------------------------*/
	
	if I replace $fetch X into $open_rec; with
		     $fetch X into $open_rec.var1,$open_rec.var2,$open_rec.var2
	it works ok.

	The problem is the tables that I need to fetch in real life have
	LOTS of columns.  



	Thanks for any help..
-- 
------------------------------------------------------------------------     
 |--------------|            #          -------------------------------|
 | Randy Paries |       ____/|   _______| b8!turq!randy                |
 | x6191   cr041|        \ oO|  /       | uunet!ingr!b8!turq!randy     |
 |--------------|    ##   | ~|_/ ##     | randy@turq.b8.ingr.com       |
                    ####  `-U'  ####    |Intergraph, Huntsville Alabama|
                       \\  ||  //       ================================
 TEAM "CATS"             \/  \/ ples exuse al speln mstaks
"Smells like team spirit" |  | 
------------------------------------------------------------------------