How to increase table space in DB2?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to increase table space in DB2?

User ALTER command to change the PRIQTY and SECQTY of the Tablespace.
Eg.
ALTER TABLESPACE db.ts PRIQTY 50 SECQTY 50.
Here PRIQTY => primary quantity in 50 KB and SECQTY => Secondary quantitly 50 KB.
If the definition of the above parameter is lesser at the TS creation time, then the tablespace size will increase.

(Continued on next question...)

Other Job Interview Questions

• How would you find out the total number of rows in a DB2 table?
• Is BETWEEN inclusive of the range values specified? –
• Is DECLARE TABLE in DCLGEN necessary? Why it used?
• Where do you specify them ?
• What is the restriction on using UNION in embedded SQL?
• What else is there in the PLAN apart from the access path? –
• What is UNION,UNION ALL? –
• Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?
• How does DB2 determine what lock-size to use?
• What is the restriction on using UNION in embedded SQL?
• More...