Re: Database Files Exceeded

[Larry Bolhuis <lbolhui@xxxxxxx>]

Chuck,

  Even if the files being created have NO logical files and only a few fields
there would be a huge hit for this.  All the I/O that goes into creating the
file, reserving space, setting authority, updating the system database tables
etc.

  Consider this:  Every try restoring a source file with say 5000 members?  
Takes
FOREVER and it runs NO WHERE NEAR tape rated speed even on a very large system,
meanwhile the disks are scrambling!  Restoring a member has somewhat less impact
than an entire file.

  This has GOT to be a major consumer of resources on this system!

  - laRRY

Chuck Lewis wrote:
> 
> Larry,
> 
> ESPECIALLY depending on the size of the files, access paths, etc. ! It could 
>be nothing and it could be a MAJOR hit !!!
> 
> Chuck
> 

-- 
Larry Bolhuis         |         What if it's True?
Arbor Solutions, Inc  |
(616) 451-2500        |  
(616) 451-2571 -fax   | 
lbolhui@ibm.net       |
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---