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 |
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What do you need to do before you do EXPLAIN ?
What is the maximum length of sqlca?
how do you resolve -805?
What is a synonym ?
What does CURRENTDATA option in bind indicate
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
what is SMP/E? and what are the major steps of it? thanks...
How to fetch the last row from the table in SQL (db2)?
What is a cursor in programming?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is a dbrm in db2?