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
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.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
List some fields from sqlca?
How can you quickly find out the # of rows updated after an update statement?
How connect db2 database to datastage?
What is innodb buffer pool?
How to find the maximum value in a column in the db2 database?
What is the reason behind not using select * in embedded sql programs?
What is rct?
What is load replace in db2?
Explain in brief how does db2 determine what lock-size to use?
How do you eliminate duplicate values in db2?
What is db2?
B37 abend during spufi?
What db2 400?