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:
From:
Denys Beauchemin <[log in to unmask]>
Reply To:
Date:
Wed, 14 Apr 1999 10:46:32 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (70 lines)
X-no-Archive:yes
I think James' explanation is incorrect.  Let's go back in time.  On MPE/V
the maximum file size was calculated as follows:  Number of bytes in a
sector (256) times maximum number of sectors in an extent (65,535 or
(2^16)-1) times the maximum number of extents in a file (32).

So a quick calculation reveals that 256*65535*32 is 536,862,720  (524 MB)
or a little over a half GB.

So...  It would seem to me that while DBUNLOAD is extracting the data, it
comes to a point where it sees that the data contained in the dataset has
now exceeded the maximum size of an IMAGE dataset under MPE/V.  It warns
you about that, so that you do not try to DBLOAD the database on MPE/V.

Kind regards,

Denys. . .

Denys Beauchemin
HICOMP America, Inc.
(800) 323-8863  (281) 288-7438         Fax: (281) 355-6879
denys at hicomp.com                             www.hicomp.com



-----Original Message-----
From:   James Clark, Jr. [SMTP:[log in to unmask]]
Sent:   Wednesday, 14 April, 1999 10:16 AM
To:     [log in to unmask]
Subject:        Re: Dataset Size

If you create a table which after including key information and the number
of rows asked for, and that size is greater than 4GB then you will get that
error. DBUTIL may truncate down to the 4GB limit which has not caused her a
problem, but you may as well turn on JUMBO dataset option, which will allow
you to have 10 4GB files tied together for one table.

James

> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
> Behalf Of Curt Brimacomb
> Sent: Wednesday, April 14, 1999 10:31 AM
> To: [log in to unmask]
> Subject: Dataset Size
>
>
> Hello,
>
> I have a database question.  I had a client unload data from a turboimage
> database, create a new database, then reload the data.  During the
process
> she got a message that said something to this effect "exceeded MPE5 file
> size" on the major detail dataset.
>
> Anyone aware of what this message might be?  It did not seem to cause her
> any problems at this point.
>
> TIA
>
> Curt Brimacomb                             http://www.magiclink.com
> System Manager                             http://www.idahocomputer.net
> Idaho Computer Services, Inc.              http://www.datanow.net
> PO Box 446                                 Voice: (208) 734-2245
> Twin Falls, ID 83301                       Fax: (208) 733-9663
>
> "It is easier to ask a stupid question than it is to fix a stupid
mistake"
>

ATOM RSS1 RSS2