467,154 Members | 788 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

Storage quantity

Hello all,
Can you please brief me on how does the pri qty and sec qty which is given during the create tablespace statement affect the tablespace.

Will the tablespace once created use the size given in priqty or it is only that that much space is allocated?

When i am doing bulk loads to a table in a tablespace, my load size is more than the priqty or sec qty, how does db2 allocate the tablepsace and what is the size of the tablespace after the load, will the load end in an error?

I am a beginner in db2 admin. i have tried this but i dont knwo what is the operation internally,,,pls someone brief me

thanks in advance
Jul 12 '07 #1
  • viewed: 1519
Share:
1 Reply
Hello all,
Can you please brief me on how does the pri qty and sec qty which is given during the create tablespace statement affect the tablespace.

Will the tablespace once created use the size given in priqty or it is only that that much space is allocated?

When i am doing bulk loads to a table in a tablespace, my load size is more than the priqty or sec qty, how does db2 allocate the tablepsace and what is the size of the tablespace after the load, will the load end in an error?

I am a beginner in db2 admin. i have tried this but i dont knwo what is the operation internally,,,pls someone brief me

thanks in advance

DB2 will allocate the primary quantity and if needed will take extents using the secondary allocation up to a maximum of 119 extents per volume.

Once your table is loaded run a reorg utility to clean up free space and use the stospace utility to update the catalog with the actual amout of spaced being used by the table, then you can adjust your primary and secondary quantities accordingly.
Jul 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Michael J. Astrauskas | last post: by
5 posts views Thread by Mark 123 | last post: by
2 posts views Thread by nielsh | last post: by
4 posts views Thread by SSUK | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.