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

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1232


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

581


List some fields from sqlca?

608


How can you quickly find out the # of rows updated after an update statement?

629


How connect db2 database to datastage?

759






What is innodb buffer pool?

560


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

605


What is the reason behind not using select * in embedded sql programs?

601


What is rct?

749


What is load replace in db2?

560


Explain in brief how does db2 determine what lock-size to use?

589


How do you eliminate duplicate values in db2?

679


What is db2?

739


B37 abend during spufi?

978


What db2 400?

673