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 |
How to execute stored procedure in db2 command editor?
What is IMAGECOPY ?
can you use symbolic parameters in JOB?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
For Read Stability locks are not applicable for phantoms, What is Phantoms?
My SQL is not performing well. Describe how will you fine tune it?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
Is db2 a mainframe database?
What is Skeleton cursor table (SKCT)?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What does DSNDB07 database do?
What is the syntax for creating a table in the db2 database?