File size for DB2/iSeries

pts.
Tags:
DB2 Universal Database
When CREATE TABLE (PRIMARY KEY) is executed and before loading rows, the sizes related to the files are: DSPFD Data space size in bytes . . . . : 24576 Access path size . . . . . . . . : 139264 Total of member sizes . . . . . . : 163840 DSPOBJD Size . . . . . . . . . . . . . . . : 188416 Why are they so big? specially the access path? Why the diference between "Total of member sizes" and "DSPOBJD Size"? Thanks in advance

Answer Wiki

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

so big !?! are you sure ? it’s not a textpad, it’s a database.

today’s unit of count is not the byte but the megabyte. How many giga in your PC ? probably more than in your I5

Discuss This Question: 2  Replies

 
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
  • JohnDavid
    Hi, Whenever an object is created the system allocates space for various object components. In the case of a file space will be allocated for the object description and the data. I suspect that in the case of a file with a primary key the system stores information about the keys, etc. in the object description and also allocates a nominal amount for the data portion that will be extended when data is loaded. Best of luck JohnDavid
    5 pointsBadges:
    report
  • Jobregonr
    Thanks for your reply. The data i sent to you was just a test. I'm trying to develop a tool to estimate the space and growth needed for any-size files, but the only formulas i have found (DB2 UDB for iSeries Database Programming V5R3) are for files created with i5 native commands like CRTPF and CRTLF. What i really need are formulas for files created with SQL sentences like CREATE TABLE and CREATE INDEX. Regards
    0 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