HP3000-L Archives

April 1999, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: DB blocking factor education.
From:
Mike Hornsby <[log in to unmask]>
Reply To:
Mike Hornsby <[log in to unmask]>
Date:
Mon, 12 Apr 1999 16:26:05 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (15 lines) 
DBSCHEMA automatically determines the number of data records that fit in a
block that makes the best use of disk space under the BLOCKMAX specified.

WHY NOT SIMPLY SPECIFY A BLOCKMAX=2560?

The data set entries are fetched from the disk into 4096 byte pages that
consist of the above blocks. When selecting BLOCKMAX you are trading off
disk space utilization versus fetching the block into multiple pages, and
the possibility of separating the bit map on the front of the block from
data at the end of the block.

 Mike

--

ATOM RSS1 RSS2