Too many files open.

John Webster john.webster@cdp.co.nz
Fri, 18 Jun 1999 10:35:53 +-1200


As I understand it there is a difference in PowerHouse between "file opens" and "files open". Quick counts each different "file open" separately eg if you run a screen maintaining a table the file will be open for read-write; if you subsequently run a screen where the table is used as a reference file the file will be opened read-only. You will have two files counted in the table, not one as you might think. One possible solution is to use the "OPEN" option on the FILE statement to open the file the same way each time.
John W
----------
From: 	Martie Ressing[SMTP:Martie.Ressing@cens.nl]
Sent: 	Thursday, 17 June 1999 22:43
To: 	'powerh-l@lists.swau.edu'
Subject: 	Too many files open.

In an application built with PowerHouse 8.13d (DG-Unix on a Intel machine),
in combination with a C-ISAM database, users often get the following error:
"Data access error. Too many files (ISAM 104)". We think this happens more
often in 8.13 than in 7.33. 
We have simulated this situation and found out, that at that time only 102
UNIX-files were at least one time opened (fuser-command). The maximum of the
number of open files in C-ISAM is 255. 
We also found out, that using the close-option on a file-statement didn't
have the expected effect (it helps only a little bit).

What can we, besides using the close-statement, do to prevent our
application crashing due to too many files opened?

Thanks,

Martie Ressing
Inter Access Cens
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.