Multiple database opens

[Neil Harvey]

My understanding is that if the first screen that causes a database open
only requires the dataset for read (Activities Find), or the dataset is a
Reference file, then the database will be opened DBMODE 5 (read only).
Subsequent screens that need any dataset in that database for update will
cause another open of the database in DBMODE 1 (Shared, Update).

We often force a dbmode 1 open on the users first screen to overcome this. 

You can also force a unique open of a dataset (and therefore, database) for
a screen on the file statement, and this may have been left on some screens
(can't remember the exact syntax here, but it may be "open each level" or
similar). This is often used if you need to maintain two "pointers" into a
dataset on one screen.

Also, if screens call external subroutines, these may also do their own
dbopen's.

But isn't it great to have all this control?

Good luck.

Regards

Neil


> -----Original Message-----
> From:	Tom Renz [SMTP:tom@cotc-consulting.com]
> Sent:	Friday, July 09, 1999 2:54 AM
> To:	powerh-l@lists.swau.edu
> Subject:	Multiple database opens
> 
> Listers,
> 
> I have noticed on my system using Glance or any other system monitoring
> tool that at times when a new screen is executed another database open is
> performed.  In a period of a day several users will have opened the
> database 10+ times and these opens will not be released until they exit
> the
> application completely.  Are there any switches that can be set either at
> the dictionary level or screen level to stop these multiple opens.  I
> understand a couple opens to retain some pointers but when a user has the
> same database opened 20 times is a little ridicules to me.
> 
> We are on 7.29C8 and I know this was this way for 7.29C5 on MPE/iX.
> 
> Please let me know.
> 
> Thanks,
> 
> Tom Renz
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> 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.