HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: Informix I-Net problem
Reply-To: shemminga@cix.compulink.co.uk
Date: Fri, 11 Sep 1992 16:21:00 +0000



Any one remember this?

> In <memo.572497@cix.compulink.co.uk> I wrote:
> 
> > Can anyone help me? We're running a small net of 386/486 boxes. On
> > the 486 machine we've got Informix SE installed along with SQL and
> > I-Net. On the other 2 machines we've go SQL and I-Net.
> > 
> > We also have a number of Informix 4GL programs running. The problem
> > is that when a number of sqlexec processes are started the system
> > reports the following error messages if someone tries to start
> > another one:
> > 
> >         -932 : Error on network connection, t_open system call failed
> >           28 : No space left on device
> > 
> > The message appears on the client terminals, the server doesn't seem
> > to be getting upset about it. I don't know however, whether it's the
> > client or the server that's generating the error message.
> 
> In the replies that followed it was suggested that the kernel
> parameter NQUEUE was set wrong. I've since re-tuned the kernel on
> both the server and the clients. Using crash it would appear that the
> kernel resources are adequate (at least there are no failures).
> 
> I've discovered that the error occurs if there are 8 remotely started
> sqlexec processes started on the server.
> 

This problem remains and is causing me a lot of grief. My dealer
can't help, they've passed it on to Sphinx Level V (the distributors)
and they've so far done nothing.

AFAIK, nobody yet has even managed to identify the device referred to
in the error message.

I'd really appreciate any help anyone out there could offer.

--------------------------------------------------------------
| Who cares whos opinions these are?!                        |
| Send me mail and I'll love you forever (Maybe)             |
|------------------------------------------------------------|     
| Stuart Hemming       | shemminga@cix.compulink.co.uk       |
| Tudor Labels Ltd     | uunet!cix.compulink.co.uk!shemminga |
| Roman Bank Bourne    | Tel :  (+44) 778 426444             |
| Lincs PE10 9LQ. UK.  | Fax :  (+44) 778 421862             |
--------------------------------------------------------------


Stuart
|8-)
From: patrik@caligula.his.se (Patrik Johansson)
Newsgroups: comp.databases.informix
Subject: Error 581 ???
Date: 14 Sep 92 14:41:58 GMT
Organization: University of Skoevde


I've recently installed INFORMIX dbaccess Ver: 5.0.

When I tried to create a stored procedure I got the message:

  581: Error loading message file.

It surely looks like an installation problem? But I can't figure out
what message file the error is referring to.
The procedure is the example "read_address" from the stores5 demos.

I've checked the file and directory permissions and they seem to be
sufficient. Also, no files seem to be missing according to the table of
contents from the installation tapes. 

(The more "standard" operations, e.g. creating tables, indexes, works
ok.) 
 
Anybody got any idea ?

Thanks in advance.

Patrik

--
-----------------------------------------------------------------------
|COOL PEOLPE WEAR	| 	Patrik Johansson 
|DARK GLASSES    	| 	System Administrator
	   		|	University of Skoevde
|____Calvin&Hobbes______________________________________________________
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: moving tables
Date: 9 Sep 92 12:43:08 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1434>

Quoting J. David Schronce...
} 
} On our Altos 2000 machine the drive which contains my database is 
} almost full.  I would like to move some of the larger data files to 
} another drive.  I've noticed that systables contains the path for each 
} of the tables, but it won't let me edit the path (or anything else).
}   
} I've logged in as myself, root and even created a user called informix 
} to try to edit it without success.
}   
Before you even install the Informix software, you must create an owner and
group called "informix".

} Can this table be editted?  Can I move my files?  Am I doomed to 
} purchase a larger hard drive for this database?  Answers to these and 
} other questions in your next newsfeed.
}   
The table can be editted by the "informix" user provided that the permissions
for certain files are OK.  The permissions of your engine should be:
  mode=6755, owner=root, group=informix

The permissions for your database directory should be:
  mode=770, owner=you, group=informix

The permissions for all the files in your database directory should be:
  mode=660, owner=you, group=informix

I can't promise that what you intend to do will work, but I can't really
see any problems with it either.  I've never tried it so let me know
what happens.

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: bochner@das.harvard.edu (Harry Bochner)
Newsgroups: comp.databases.informix
Subject: Re: Endless loops on abstract quitting?
Date: 10 Sep 92 18:25:40 GMT
Article-I.D.: das.1992Sep10.182540.7181
Organization: Aiken Computation Lab, Harvard University

In article <5295@krafla.rhi.hi.is>, gaukur@rhi.hi.is (Kristjan Gaukur 
Kristjansson) writes:
|> My system is I-OnLine 4.1 with I-4GL RDS on an IBM R-6000 320 AIX 3.1 with
|> users coming in through ethernet.  Now sometimes when they quit abstractly
|> (like turning off the terminal/computer without quiting the system or breaking
|> out with ctrl-c or somesuch) the 'fglgo' process goes into an endless loop
|> eating up all the cpu it can get.

I used to have this problem a lot. I don't know if my experience under SunOS
applies to what you're seeing under AIX, but maybe it will help.

In my environment, when a user gets disconnected, the processes get sent a
SIGHUP.  Now, the Informix libraries have a signal handler for SIGHUP that shuts
things down neatly, just the way you would want. The problem is that (at least
under 2.10.03, which is what I was running when I had this problem) this signal
handler doesn't seem to be active all the time. My impression was that the
handler was active when the form-handling library routines were waiting for
input, but not otherwise (i.e. while calculations or SQL calls are taking place).

In my particular case, I had a program that, for obscure reasons, called a C
function to read from the terminal, bypassing the Informix libraries. If the user
got disconnected while this program was waiting for input, it would loop
endlessly, eating up CPU time in the way Kristjan describes. I rewrote the
program so that all the IO went through the Informix libraries, and the
problem disappeared.

Hope this helps,

-- 
Harry Bochner
bochner@das.harvard.edu
From: baskett@hermes1.sps.mot.com (Bob Baskett)
Newsgroups: comp.databases.informix
Subject: sql question
Date: 15 Sep 92 18:38:06 GMT
Reply-To: baskett@hermes1.sps.mot.com (Bob Baskett)
X-Informix-List-ID: <list.1450>


help, im having trouble doing a select.  we have a table (trace) which
has two trace_types, (WAF and ASM).  what i want to know is the ASM
source_lots which have more than one WAF source_lot.

the trace table:

create table trace
  (
  source_lot 	char(16),
  test_lot	char(16),
  test_lot_class char(3),
        ...
  );

my first select looks like:

select a.source_lot, count(DISTINCT b.source_lot)
from   system:trace a,
       system:trace b
where  a.trace_type = "ASM"
  and  b.trace_type = "WAF"
  and  b.test_lot = a.test_lot
  and  b.test_lot_class = a.test_lot_class
group by a.source_lot
having count(DISTINCT b.source_lot) > 1

which yeilds a syntax error on the 'having count(DISTINCT...'.

i have tried changing the having to 'having 2 > 1' in an attempt to
force sql to use ordinal types - it failed as well.

i can load my initial select into a temp table and then select from
it where the count is > 1, but the trace table has 3.8 million rows.

any help/comments would be appreciated.

------------------------------------------------------------------------------
Bob Baskett
Motorola, Inc.

Newsgroups: comp.databases.informix
From: root@candle.uucp (Bruce Momjian)
Subject: Where's my Reverse field
Organization: a consultant's basement
Date: Tue, 8 Sep 1992 21:31:42 GMT
X-Newsreader: Tin 1.1 PL5

I have a field on a form I have specified as REVERSE, but it just comes
up blank.  I know Informix knows about the reverse video on my terminal
because my menus come up reverse.  In fact, I have some Informix
executable from another person and its fields are reverse.  Does anyone
know why this is happening?  Below is my form description file.

I have tried this from the console, from an xterm, and from a vt220. 
None work.  I am just starting out and this is my first form.

------------------------------------------------------------------------

database formonly
screen
{
			Summary of Client/Matter Activity
			
			
		As-of Period [a]
				
}
end
attributes
a = formonly.begdt TYPE CHAR, REVERSE;
end
instructions
delimiters "<>";
end
				

-- 
Bruce Momjian                      |  830 Blythe Avenue
root%candle.uucp@bts.com           |  Drexel Hill, Pennsylvania 19026 
                                   |  (215) 353-9879(w)  853-3000(h)
From: ado@ibg1.ibg.sub.org (Christoph Adomeit)
Newsgroups: comp.databases.informix
Subject: My really LAST experience with Informix
Date: 15 Sep 92 17:13:01 GMT
Organization: ibg

Yes, after asking our Distributor over and over he said today, that
Informix Online 5.0 is available. First I was glad because our 4.1
version has a lot of bugs.

But then the Distributer told me the conditions for updating FROM A
BUGGY RELEASE to a hopefully more stable version :
a) I have to pay 9 percent of the end-user price because I do not have 
	 a support contract yet.
b) I have to pay another 18 percent of the end-user price for the support
	 contract.
c) If the new list-price is higher than the old one, I have to pay
	 DM 1000, dont know for what.
d) Online itself once costed twice as much as as the Computer (486/33)
	 we use it on.

I relly do not need a support contract, a database is for making developers
life easier. If an experienced database developer would need support for
using a database it cannot be a good product. 

Those crazy update conditions are not only for Informix-Online, they are
equal with Standard Engine, ESQL-C, isql, Informix-Star, Net and so on.
All in all I think I could buy a nice car for those costs.

I am not willing to use these program anymore, if anyone likes to buy
them :-). But I suppose you have to pay some 100 percent more, If you
would ever update them.

Does anybody know about other Unix sql-databases ? I heard about 
db-vista, but I heard that it is not as flexible as a relational
database. I don't care about networking facilities and datatypes
like BLOBS because they are easy to simulate with Unix-facilities.

Never buy Informix
BTW: My Signature : It's not a bug, it's a feature was written one day
when Informix told me about the fact that $describe does not work with
updates and that this is a feature in their opinion.  
-- 
Origin: It's not a bug, it's a feature !
From: pp@q8.dk (Poul Pedersen)
Newsgroups: comp.databases.informix
Subject: Client-Server-Istar
Date: 5 Sep 92 08:03:10 GMT
Reply-To: pp@q8.dk (Poul Pedersen)
X-Informix-List-ID: <list.1431>


        Hey experts

        can you help me with an ethernet calculation for a client
        server installation with ISTAR and Informix Online.
        If I have the following informations from tbstat -p

        dskreads        50 per second     (Calculated worst case)
        bufreads      3650 per second               -
        dskwrits        10 per second               -
        bufwrits       100 per second               -

        I estimate the average record length to be 80 bytes.
        The tables in my database will use row locking.

        The number of data bits to transfer between client and
        server will be around (3650+100)*80*8 = 2.4 Mbit per second.
        There will be some SQL commands, which will be transfered as
        well.
        I then suppose, that the ethernet with a capacity of
        1 Mbit per second will be insuficient, but a 10 Mbit
        net will have the needed capacity. Is this correct ?

        Thanks for your help from
-----------------------------------------------------------------
Databaseadministrator Poul Pedersen
Kuwait Petroleum (Denmark) A/S
Hummeltoftevej 49                         Mail:   pp@q8.dk
2830  Virum                               Voice:  +45 45 98 45 94
Denmark                                   Fax:    +45 42 85 14 18
-----------------------------------------------------------------
From: nparkar@seamis1.gsfc.nasa.gov (Nuruddin Parkar)
Newsgroups: comp.databases.informix
Subject: Informix position available
Summary: informix
Keywords: Informix
Date: 11 Sep 92 18:36:18 GMT
Distribution: usa
Organization: Goddard Space Flight Center

Informix position is available.  The qualified candidate must have 

          Bachelor's or Master's degree in Computer or any physical science,
	  5 years of experience with Informix and Wingz, and
	  Knowledge of SCO unix.
  
Please email your resume immediately to
	nparkar@seamis1.gsfc.nasa.gov

Thanks
Nuru Parkar
From: baskett@hermes1.sps.mot.com (Bob Baskett)
Newsgroups: comp.databases.informix
Subject: db names
Date: 13 Sep 92 18:08:07 GMT
Reply-To: baskett@hermes1.sps.mot.com (Bob Baskett)
X-Informix-List-ID: <list.1442>


here is a program that should dump the database names for an online instance:
-----------------------------------------------------------------------------

/*
===============================================================================
program : dbnames.ec
compile : esql -o dbnames dbnames.ec
short description : 
          list all available database names in an online system
long description :
          program created (by Informix) for a customer to get all the
          database names, makes unsupported library calls, use at your own risk
notes   : modified printf so that it pipe delimits the output so it
          can be loaded into a db table
===============================================================================
*/

#include <sqlhdr.h>
#include <sqlca.h>
#include <stdio.h>

#define MAXDBS 100
#define FASIZ  MAXDBS * 19

main()
{
  int fcnt;
  char *frmname[MAXDBS+1];
  char farea[FASIZ];
  int i;

  sqgetdbs(&fcnt,frmname,MAXDBS,farea,FASIZ);

  for ( i=0; i<fcnt; ++i) {
    printf("%s~\n",frmname[i]);
  }
}

compact(frm,fcnt)
char **frm;
int fcnt;
{
  register char **to, **from;
  register char *last = " ";
  int same;

  from = to = frm;
  while (fcnt-- > 0)
    {
    same = stcmpr(last, *from);
    last = *from;
    if (same != 0)
      *to++ = *from++;
    else from++;
    }
  return (to-frm);
}

frmcmpr(n1,n2)
char **n1, **n2;
{  
  return (stcmpr(*n1,*n2));
}

------------------------------------------------------------------------------

like it says, it makes unsupported calls - use at own risk, may not work with
all version or upgrades.

------------------------------------------------------------------------------
Bob Baskett
Motorola, Inc
From: M22367@mwvm.mitre.org
Newsgroups: comp.databases.informix
Subject: Re: eed info on UNIX relational databases
Date: 8 Sep 92 15:53:57 GMT
Organization: The MITRE Corporation, McLean VA 22102

The August 1, 1992 issue of Datamation has a dbms buyers guide.  I *know* it's
a year old, but it lists just about every dbms on the market - relational or
not - what OS's it runs under, whether it supports SQL, has a GUI front-end,
etc., and contact information.
 
There's more to Unix dbms than Informix, Oracle, and Ingres.  If you're willing
to try something different ya gotcher InterBase, yer CA-Datacom, yer CA-DB, yer
yer Queo-V, yer Integra/SQL...
 
I am not reccomending any of the above products - just trying to answer the
question.
 
                 - Mike
From: kurt@sdd.hp.com (Kurt Andersen)
Newsgroups: comp.databases.informix
Subject: Re: ESQL/C & $set explain on problem
Followup-To: comp.databases.informix
Date: 10 Sep 1992 11:06:36 -0700
Organization: Hewlett Packard, San Diego Division
Distribution: comp.databases.informix
NNTP-Posting-Host: hpsdde.sdd.hp.com
Summary: do $set explain after $database
Keywords: ESQL C select explain

Thanks to all who made suggestions.  For those who are curious on the net
here's the original question and the answer(s).
-----------------------------------------------
> 
> > 
> > While I wait for Informix tech support to call me back, I thought that I
> > would see if anyone on the net could help with this problem.
> > 
> > In an ESQL/C program (ESQL version 4.10.UD2) running on an HP 9000/380,
> > I am trying to do a '$set explain on' to watch the execution of the select
> > statements following throughout the program.  No errors come back, but I 
> > don't get a 'sqexplain.out' file anywhere that I can find either.
> > 
> > Any suggestions?  BTW, the program is talking to a standard engine (version
> > 5.00.UC2) on another machine through I-NET.
> 
* * *
> 
> Maybe you have your $database statement after the $set explain statement, if
> so try it before.
> 

That's the problem in my case since the program changes databases in the course
of running and I was looking for the query information about the second db.

Also, per 2 suggestions I received, I found that Informix is writing the 
sqexplain.out file to my home directory on the server.  IMHO, this is not
a great idea since engine users are not required to have home directories 
on the server, but maybe it is the least of many potential evils.

Thanks to all who responded to my question...I still have not been able to
contact/received a call back from Informix tech support.  Now I don't need
to.

Cheers,
  Kurt Andersen

--
                          kurt@hpsdid.sdd.hp.com
                  619/592-4373 (voice); 619/592-8191 (FAX)
             16399 W. Bernardo Dr. MS 61U65/San Diego, CA 92127

-----Standard disclaimer stuff applies for all of the standard reasons-----
-- 
                          kurt@hpsdid.sdd.hp.com
                  619/592-4373 (voice); 619/592-8191 (FAX)
             16399 W. Bernardo Dr. MS 61U65/San Diego, CA 92127
-----Standard disclaimer stuff applies for all of the standard reasons-----
Newsgroups: comp.databases.informix
From: ado@ibg1.ibg.sub.org (Christoph Adomeit)
Subject: How to get list of all databases
Organization: ibg
Date: Thu, 10 Sep 1992 22:39:26 GMT

This was asked some time ago, but the articles have expired.
How can I get a list of all databases from esql-c ?
Must be some function like sqgetdbs or so.
Does anyone have some documentation about all the library functions
from libsql.a ?
Thanks for help
Bye  
	Christoph
-- 
Origin: It's not a bug, it's a feature !
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re: HELP! Trying to UPDATE temp table HELP!
Date: 14 Sep 92 12:23:07 GMT
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
X-Informix-List-ID: <list.1444>

>From: Dave Snyder <uunet!widener!das13!dave.snyder>
>Subject: Re: HELP! Trying to UPDATE temp table HELP!
>Date: Mon, 7 Sep 92 14:27:56 EDT
>X-Informix-List-Id: <list.1432>
>
>Quoting Mark L Trotter...
>}
>}    I am trying to create a temporary table, insert some elements from
>} another table, then go thru the temporary table using a cursor and
>} do some updating of other elements.  All works except:
>}    1. I can't DEFINE a memory record LIKE the temporary table because
>}       it doesn't exist at compile time so I assume I must define the
>}       entire memory record via listing all of the elements, but if I do
>}       that then:
>}    2. I can't UPDATE the temporary table using
>}        UPDATE temptablename SET temptablename.* = memrecord.*
>}       because I get a compile error saying that memrecord was not
>}       defined using the RECORD LIKE phrase.
>} Is this a know bug and is there any workarounds?

No, it is not a bug but it is a known pair of restrictions.

>Try this:
>DEFINE the record the "long hand" way and then use an UPDATE statement like
>this one...
>
>UPDATE temptablename SET (temptablename.col1, temptablename.col2, etc...)
>		       = (memrecord.col1, memrecord.col2, etc...)

As an alternative, define a view which (a) contains no rows, and (b)
contains the required column types, and compile against that view.

This may not work with temporary tables, but I do use the technique for
input where I need data from a number of different tables.  The sort
of view I have in mind is:

CREATE VIEW Compiler_view_001 (ColumnA, ColumnB, ...) AS
	SELECT A.Column1, B.Column2, ...
		FROM TableA A, TableB B, ...
		WHERE 1 = 0;

The other alternative is to create a permanent table with the required
columns and use that instead of the temporary table.  This is often not
satisfactory in a multi-user environment, but sometimes it can work.
I have a batch program that grabs the database in exclusive mode and
uses a permanent table as an intermediate results file; when the program
completes, it drops the table and rebuilds it.  The program is run once
a week in the wee small hours (about 04:00) and this works quite nicely
in this case, thank you.  It may not be relevant for your problem -- sorry.

Finally, you could try preparing the UPDATE statement and execute it
with a USING clause listing all the elements in the record.  You will need
to worry about supplying the values for the WHERE clause as well as the SET
clause.  If you prepare it just once, your performance will also improve
(provided you execute it more than once), though the difference may not
be easily measurable.

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: adamt@ant.EBay.Sun.COM (Tom Adam)
Newsgroups: comp.databases.informix
Subject: Wingz on Xterminal
Date: 16 Sep 1992 00:14:58 GMT
Organization: Sun Microsystems, Inc.
Distribution: world
Reply-To: adamt@ant.EBay.Sun.COM
NNTP-Posting-Host: ant.ebay.sun.com

I have an end user who is trying to use Wingz on an  Qume Xterminal.
He gets the following error:
OPEN LOOK Toolkit Error in application "Wingz": Could not find the OPEN LOOK font: h12lucida.snf
How do I tell Wingz where the OPEN LOOK font is?


Thanks in advance for your help.
From: david@cssnet.UUCP (J. David Schronce)
Newsgroups: comp.databases.informix
Subject: moving tables
Date: 7 Sep 92 21:06:49 GMT
Organization: Computer Support Services

On our Altos 2000 machine the drive which contains my database is 
almost full.  I would like to move some of the larger data files to 
another drive.  I've noticed that systables contains the path for each 
of the tables, but it won't let me edit the path (or anything else).
  
I've logged in as myself, root and even created a user called informix 
to try to edit it without success.
  
Can this table be editted?  Can I move my files?  Am I doomed to 
purchase a larger hard drive for this database?  Answers to these and 
other questions in your next newsfeed.
  
If you wish to reply via email, please reply to: 
        david%kelly@wolves.durham.nc.us         or
        dschronc@lee.cerf.fred.org
  
THANK YOU!!!!!


---dave---
+-----------------------------------------------------------------+
|J. David Schronce     "Death Before Decaf!!"    david@cssnet.UUCP|
|Computer Support Services                            919/775-2145|
|-----------------------------------------------------------------|
|          "The opinions and the company are both mine..."        |
+-----------------------------------------------------------------+