By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Storage quantity

P: 4
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
Share this Question
Share on Google+
1 Reply


P: 2
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.