On the create tablespace, what does the CLOSE parameter do?

Answer Posted / s

CLOSE YES parameter tells DB2 that when DB2 needs to close
datasets when DSMAX is reached, DB2 will choose this
tablespace to be closed.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630


Explain about rct.

654


What is null value in db2?

567


What is role in db2?

622


If I have a view which is a join of two or more tables, can this view be updateable?

695






How can you do the explain of a dynamic sql statement?

637


What is a system catalog table in db2?

590


On which levels locks can be applied?

663


What is query_cache_limit?

548


How to find the maximum value in a column in the db2 database?

614


What is reorg?

619


What is ibm db2 client?

523


How to run db2 command in windows?

654


What is buffer pool in the db2 database?

622


How do you concatenate the firstname and lastname from emp table to give a complete name?

604