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



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

Answer / 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

More DB2 Interview Questions

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,


Can we delete records from view?

0 Answers  


What does the CHECK Utility do ?

1 Answers  


What do you mean by rollback?

0 Answers  


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


When the like statement is used?

0 Answers  


What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,


What is the difference between plan and package in db2?

0 Answers  


what is dynamic cursor?gives syntax for this?

1 Answers   TCS,


What is bind in db2?

0 Answers  


What are the 2 sqlcodes that are returned?

0 Answers  


Categories