How to calculate logical file size

23730 pts.
Tags:
AS/400
DB2
File
Logical File
Hi, I need to be able to estimate the size of a logical file (inc access path). I've tried creating this file and almost filled the machine up. This is logical has quite a lot of key fields. Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out what to do with it). Thanks in advance, Martin Gilbert.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You must be running very tight on disk space or this file is extremely large.

For an example on our system, here’s what our order detail file looks like

Physical has no key fields,
164 fields and a record length of 798 characters.
Total number of records in the file 3,604,910
file size in bytes 2,952,830,976

one of our logicals over this file looks like this
we have 8 key fields over the entire file. ( No select or omits. )
The file size of this logical in bytes is 3,686,400 for a ratio of .12%

Very small compared to the physical.

Check your availablr disk space by using the command WRKSYSSTS.

in the upper right ours looks like

Auxiliary storage:
System ASP . . . . . . : 668.8 G
% system ASP used . . : 57.0926
Total . . . . . . . . : 668.8 G
Current unprotect used : 10056 M
Maximum unprotect . . : 17609 M

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out what to do with it). Simplest way for me is to test it physically. Create the index and add 100, 5000, 10000 entries. The more increments you can use, the better your trendlines will be. I might work the formulas if you supply key length and access path size. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following